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

[cockroach-teamcity]

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

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/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 WITH
			with_14345 (col_89289)
				AS (
					SELECT
						*
					FROM
						(VALUES ((NULL::INTERVAL * (-31309446584928473.45):::DECIMAL::DECIMAL)::INTERVAL))
							AS tab_42671 (col_89289)
				),
			with_14346 (col_89290)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(NULL),
								(e'Mi\x06N\x0e':::STRING),
								('T2>aBj':::STRING),
								('^':::STRING),
								(e'\x19':::STRING),
								(e'K\x17\x12B':::STRING)
						)
							AS tab_42672 (col_89290)
				)
		SELECT
			(-7905044399277333436):::INT8 AS col_89291,
			NULL AS col_89292,
			tab_42673.col4_8 AS col_89293,
			172551908:::OID AS col_89294,
			tab_42673.col4_4 AS col_89295,
			'[[], [[null], 1.2689848362013112], {"c": [[], []], "c2GE": {"b": null}}, {"0C* (!.1)@8": true, "a": {}}, {"baz": []}]':::JSONB
				AS col_89296,
			tab_42673.col4_1 AS col_89297,
			tab_42673.tableoid AS col_89298,
			tab_42673.col4_6 AS col_89299
		FROM
			defaultdb.public.table4@[0] AS tab_42673, with_14345 AS cte_ref_4243
		ORDER BY
			cte_ref_4243.col_89289 ASC, tab_42673.col4_6;

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

[cockroach-teamcity]

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

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/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 WITH
			with_4123 (col_21212)
				AS (SELECT * FROM (VALUES ('-6 years -6 mons -842 days -24:40:13.605035':::INTERVAL)) AS tab_12270 (col_21212))
		SELECT
			NULL AS col_21213, tab_12271.col1_4 AS col_21214
		FROM
			with_4123 AS cte_ref_1173, defaultdb.public.table1@[0] AS tab_12271
		ORDER BY
			cte_ref_1173.col_21212 DESC, tab_12271.crdb_internal_mvcc_timestamp, tab_12271.col1_4 DESC
		LIMIT
			52:::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