roachtest: sqlsmith/setup=rand-tables/setting=no-mutations failed

[cockroach-teamcity]

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

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:
		SELECT
			'1975-12-03':::DATE AS col_39974,
			tab_17562.col1_2 AS col_39975,
			3301607114:::OID AS col_39976,
			tab_17562.crdb_internal_mvcc_timestamp AS col_39977,
			'infinity':::DATE AS col_39978,
			tab_17562.col1_4 AS col_39979,
			tab_17562.col1_0 AS col_39980
		FROM
			defaultdb.public.table1@table1_col1_1_col1_3_expr_col1_2_idx AS tab_17562
		WHERE
			st_dwithinexclusive('0105000020E610000002000000010200000003000000000000000000244000000000000024400000000000003440000000000000344000000000000024400000000000004440010200000004000000000000000000444000000000000044400000000000003E400000000000003E40000000000000444000000000000034400000000000003E400000000000002440':::GEOGRAPHY::GEOGRAPHY, '0103000060E6100000010000000A0000005A5CA0B3EC7D52C0D01A6712E0D210C04CB1F55A2B34EB4173ABF1947E5E51C0A09D88DA44600BC080DE51F85115D2414E3DDF76A06866C0724871E00CF252C06A1180AAAF9001C2781305DD4D055940400D1F1CE217184096D036C308BBEEC1F0B236F46E6C54404C49F828CDAC3540223D1B3AD93FEEC15CFE9F01E24E5D40F4C59D4866C24C40A655D5CC8B9CE4C1E42A6D9DAF294840C447F09165E9524090CF088B573FF7414885591E6CBF35C0C2B34A63A93F504058F1B4E434F5E7C14A5102FA64C858C0B61BE5F437655340E0E1060D1472D8415A5CA0B3EC7D52C0D01A6712E0D210C04CB1F55A2B34EB41':::GEOGRAPHY::GEOGRAPHY, tab_17562.col1_2::FLOAT8, (true OR NULL)::BOOL)::BOOL;

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-15263

[cockroach-teamcity]

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

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_49 (col_383) AS (SELECT 4225082963:::OID AS col_383),
			with_50 (col_384) AS (SELECT * FROM (VALUES ('vtm':::rand_typ_2)) AS tab_156 (col_384))
		SELECT
			tab_157.col2_0 AS col_385,
			tab_157.col2_3 AS col_386,
			'58b4:dbef:3056:fc6e:a4fa:ae9b:3da9:d6f/68':::INET AS col_387,
			e'\x03xC':::STRING AS col_388,
			e'\x0f':::STRING AS col_389
		FROM
			defaultdb.public.table2@table2_col2_8_col2_1_col2_9_col2_7_col2_2_col2_5_col2_4_col2_3_col2_10_col2_6_col2_0_key
				AS tab_157
		WHERE
			tab_157.col2_10 LIKE e'@JN>\x03':::STRING
		ORDER BY
			tab_157.col2_6;

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

[rytaft]

Dup of #80820