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

[cockroach-teamcity]

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

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: required ordering refers to non-output columns (op project)
		stmt:
		EXPLAIN WITH
			with_805 (col_4935)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								(
									('24:00:00-15:59:00':::TIMETZ::TIMETZ + '70 years 4 mons 668 days 17:26:15.518431':::INTERVAL::INTERVAL)::TIMETZ
								)
						)
							AS tab_2328 (col_4935)
				)
		SELECT
			NULL AS col_4936,
			tab_2331.col1_7 AS col_4937,
			0.0:::FLOAT8 AS col_4938,
			tab_2329.col1_5 AS col_4939,
			(-0.7081894874572754):::FLOAT8 AS col_4940,
			tab_2331.col1_3 AS col_4941,
			tab_2329.col1_5 AS col_4942,
			'24:00:00-15:59:00':::TIMETZ AS col_4943,
			0.14201487600803375:::FLOAT8 AS col_4944
		FROM
			defaultdb.public.table1 AS tab_2329
			JOIN defaultdb.public.table1 AS tab_2330 ON
					(tab_2329.col1_2) = (tab_2330.col1_2)
					AND (tab_2329.col1_8) = (tab_2330.col1_8)
					AND (tab_2329.col1_6) = (tab_2330.col1_6)
					AND (tab_2329.col1_4) = (tab_2330.col1_4)
					AND (tab_2329.col1_7) = (tab_2330.col1_7),
			defaultdb.public.table1@table1_col1_2_col1_5_col1_1_col1_0_col1_7_col1_4_idx AS tab_2331,
			with_805 AS cte_ref_237
		WHERE
			true
		ORDER BY
			tab_2330.col1_5, cte_ref_237.col_4935 ASC
		LIMIT
			6:::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-19859

[DrewKimball]

Dup of #88037