Skip to content

sql: internal error: in-between filters didn't yield a constraint #80820

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ a2e1910f51593bd2ef72e1d7c615e08f95791186:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-mutations/run_1
	sqlsmith.go:265,sqlsmith.go:305,test_runner.go:876: error: pq: internal error: in-between filters didn't yield a constraint
		stmt:
		WITH
			with_60848 (col_348252)
				AS (
					SELECT
						*
					FROM
						(VALUES ('hviat':::rand_typ_0), ('ymlez':::rand_typ_0), ('pzlue':::rand_typ_0), ('ivkys':::rand_typ_0))
							AS tab_152645 (col_348252)
				)
		SELECT
			NULL AS col_348253,
			tab_152646.col1_3 AS col_348254,
			tab_152646.col1_6 AS col_348255,
			tab_152646.col1_8 AS col_348256,
			23871:::INT8 AS col_348257,
			'\x5c91d7a0d2edd6fc0f':::BYTES AS col_348258,
			tab_152646.col1_5 AS col_348259,
			e'F\x01W[\x12':::STRING AS col_348260,
			(-6.335565852276255591E+29):::DECIMAL AS col_348261,
			tab_152646.col1_4 AS col_348262,
			NULL AS col_348263
		FROM
			defaultdb.public.table1@[0] AS tab_152646
		WHERE
			(7679919245303374124:::INT8 < tab_152646.col1_2)
		ORDER BY
			tab_152646.tableoid DESC;
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-15503

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions