roachtest: sqlsmith/setup=seed/setting=no-ddl failed

[cockroach-teamcity]

roachtest.sqlsmith/setup=seed/setting=no-ddl failed with artifacts on master @ 89f4ad907a1756551bd6864c3e8516eeff6b0e0a:

test artifacts and logs in: /artifacts/sqlsmith/setup=seed/setting=no-ddl/run_1
	sqlsmith.go:266,sqlsmith.go:327,test_runner.go:928: error: pq: internal error: expected required columns to be a subset of output columns
		stmt:
		EXPLAIN SELECT
			tab_2462._float4 AS col_5881,
			'[[{"V``;": {"<Ev$7I2@": {}, "fAGw": {}}, "a": [[{"bar": []}]], "gdub^": false}, 0.04545953921641038, true], [], {}]':::JSONB
				AS col_5882,
			'2028-02-05 20:55:16.000655':::TIMESTAMP AS col_5883,
			'117.177.214.75/24':::INET AS col_5884
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_2462
		WHERE
			tab_2462._bool
		ORDER BY
			tab_2462._float4, tab_2462._bool ASC, tab_2462._enum, tab_2462._decimal DESC;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-19887

[cockroach-teamcity]

roachtest.sqlsmith/setup=seed/setting=no-ddl failed with artifacts on master @ 51c8aae748d338549400c047796c6c9b892527da:

test artifacts and logs in: /artifacts/sqlsmith/setup=seed/setting=no-ddl/run_1
	sqlsmith.go:266,sqlsmith.go:327,test_runner.go:928: error: pq: internal error: required ordering refers to non-output columns (op project)
		stmt:
		EXPLAIN WITH
			with_700 (col_5008) AS (SELECT * FROM (VALUES ('0.0.0.0/0':::INET)) AS tab_2132 (col_5008)),
			with_701 (col_5009)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									CASE
									WHEN false THEN ARRAY[13739:::INT8,(-21413):::INT8,30121:::INT8]
									ELSE ARRAY[(-25841):::INT8,27293:::INT8,14982:::INT8,27511:::INT8,12409:::INT8]
									END
								),
								(ARRAY[4612:::INT8,2292:::INT8]),
								(ARRAY[4198:::INT8,28127:::INT8,12747:::INT8]),
								(NULL),
								(ARRAY[30016:::INT8])
						)
							AS tab_2133 (col_5009)
				)
		SELECT
			4.569721954336327972E+28:::DECIMAL AS col_5010,
			tab_2134._float4 AS col_5011,
			1.401298464324817e-45:::FLOAT8 AS col_5012,
			(-21691):::INT8 AS col_5013,
			'64.83.141.103/17':::INET AS col_5014,
			'-52 years -11 mons -473 days -21:18:10.803719':::INTERVAL AS col_5015,
			'1995-11-11 13:57:26.000184+00:00':::TIMESTAMPTZ AS col_5016,
			tab_2134._jsonb AS col_5017,
			NULL AS col_5018,
			(tab_2134.crdb_internal_mvcc_timestamp::DECIMAL + tab_2134._int8::INT8)::DECIMAL AS col_5019,
			tab_2134._date AS col_5020,
			tab_2134._int8 AS col_5021,
			false AS col_5022
		FROM
			defaultdb.public.seed@seed__int8__float8__date_idx AS tab_2134, with_700 AS cte_ref_209
		WHERE
			tab_2134._bool
		ORDER BY
			tab_2134._bool ASC, tab_2134.crdb_internal_mvcc_timestamp DESC;

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

[DrewKimball]

Dup of #88037