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

[cockroach-teamcity]

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

test artifacts and logs in: /artifacts/sqlsmith/setup=seed/setting=no-mutations/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 WITH
			with_59 (col_437) AS (SELECT * FROM (VALUES (2924106723:::OID)) AS tab_164 (col_437)),
			with_60 (col_438)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(ARRAY[3666837383:::OID,2847154393:::OID,2530542134:::OID]),
								(ARRAY[2646833212:::OID]),
								(ARRAY[2205376569:::OID,287067757:::OID]),
								(ARRAY[4176006205:::OID,3902997240:::OID,2535852452:::OID]),
								(ARRAY[172158989:::OID,2675521685:::OID,3337201923:::OID,516109218:::OID]),
								(ARRAY[1593187871:::OID,0:::OID])
						)
							AS tab_165 (col_438)
				),
			with_61 (col_439) AS (SELECT '14:55:44.961781':::TIME AS col_439 FROM with_60 AS cte_ref_18 WHERE true)
		SELECT
			false AS col_440
		FROM
			with_59 AS cte_ref_19, defaultdb.public.seed@seed__int8__float8__date_idx AS tab_166
		ORDER BY
			cte_ref_19.col_437, tab_166._date DESC, tab_166._inet DESC
		LIMIT
			46:::INT8;

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-19956

[cockroach-teamcity]

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

test artifacts and logs in: /artifacts/sqlsmith/setup=seed/setting=no-mutations/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 SELECT
			1.5703001324555936:::FLOAT8 AS col_1010,
			(-0.4777094423956818):::FLOAT8 AS col_1011,
			tab_429.col_1008 AS col_1012,
			tab_429.col_1006 AS col_1013,
			0.9054663709692872:::FLOAT8 AS col_1014
		FROM
			(
				SELECT
					0.026437223647842956:::FLOAT8 AS col_1000,
					tab_428._float8 AS col_1001,
					0.39176466258393106:::FLOAT8 AS col_1002,
					tab_427._float8 AS col_1003,
					1.0551537471134682:::FLOAT8 AS col_1004
				FROM
					defaultdb.public.seed AS tab_427 JOIN defaultdb.public.seed AS tab_428 ON (tab_427._int8) = (tab_428._int8)
			)
				AS tab_429 (col_1005, col_1006, col_1007, col_1008, col_1009)
		ORDER BY
			tab_429.col_1009 DESC,
			tab_429.col_1008 DESC,
			tab_429.col_1007 ASC,
			tab_429.col_1005 DESC,
			tab_429.col_1007 ASC,
			tab_429.col_1008
		LIMIT
			100:::INT8;

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