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

[cockroach-teamcity]

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

test artifacts and logs in: /artifacts/sqlsmith/setup=tpcc/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 WITH
			with_347 (col_1835, col_1836)
				AS (
					SELECT
						tab_877.c_data AS col_1835, 1687505591:::OID AS col_1836
					FROM
						defaultdb.public.customer@primary AS tab_877
						JOIN defaultdb.public.customer@customer_idx AS tab_878 ON
								(tab_877.c_state) = (tab_878.c_first)
								AND (tab_877.c_first) = (tab_878.c_city)
								AND (tab_877.c_phone) = (tab_878.c_phone)
								AND (tab_877.c_street_1) = (tab_878.c_street_2)
								AND (tab_877.c_street_2) = (tab_878.c_street_1)
								AND (tab_877.c_city) = (tab_878.c_street_2)
								AND (tab_877.c_data) = (tab_878.c_last)
					WHERE
						true
					GROUP BY
						tab_877.c_data
				)
		SELECT
			tab_879.o_entry_d AS col_1837,
			(-91115.94655337263588):::DECIMAL AS col_1838,
			tab_879.o_all_local AS col_1839,
			3078938119:::OID AS col_1840
		FROM
			with_347 AS cte_ref_118, defaultdb.public."order"@[0] AS tab_879
		ORDER BY
			tab_879.o_carrier_id, cte_ref_118.col_1835, cte_ref_118.col_1836 ASC, tab_879.o_d_id, tab_879.o_id ASC
		LIMIT
			45:::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-19931

[DrewKimball]

Dup of #88037