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

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on release-22.2 @ 552ade7b20b91d333edae28b87c4c49d76c70081:

								COALESCE(
									'-(d':::STRING,
									(
										SELECT
											NULL AS col_15453
										FROM
											defaultdb.public.table1@[0] AS tab_7364
										WHERE
											true
										ORDER BY
											tab_7364.col1_6 ASC NULLS LAST,
											tab_7364.col1_4 DESC,
											tab_7364.crdb_internal_mvcc_timestamp ASC
										LIMIT
											1:::INT8
									)
								)
							),
							e'DLW^\x01\x11HV':::STRING,
							'[false, {}]':::JSONB
						),
						(e'F\b7W8':::STRING, NULL, '1':::JSONB),
						(NULL, NULL, '{"a": "c", "foobar": [[true], null, true, 0.1611935306129058]}':::JSONB),
						(
							'/':::STRING,
							e'tD\x04':::STRING,
							'[[[false, [true, {}]], [null, {}, []]], [false], [], null, {"bar": "[ -qIyD"}]':::JSONB
						),
						(
							NULL,
							e'\t]\x15':::STRING,
							e'{"R?``)Jx,:})\\"\\"": false, "fo>E&$!": [], "foo": 2.154232470416546, "m\\\\b<>\':": {"b": {}}}':::JSONB
						)
				)
					AS tab_7365 (col_15454, col_15455, col_15456)
		),
	with_2434 (col_15457) AS (SELECT * FROM (VALUES (false)) AS tab_7366 (col_15457))
SELECT
	(tab_7367.col1_3::BYTES || '\x':::BYTES::BYTES)::BYTES AS col_15458,
	tab_7367.col1_3 AS col_15459,
	tab_7367.col1_1 AS col_15460,
	0.24073993202778687:::FLOAT8 AS col_15461,
	tab_7367.col1_0 AS col_15462,
	(-35204931991094011.2):::DECIMAL AS col_15463
FROM
	defaultdb.public.table1@table1_expr_expr1_col1_8_col1_7_col1_2_idx AS tab_7367
WHERE
	true
LIMIT
	21:::INT8;

Parameters: ROACHTEST_arch=amd64 , 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-29201

[mgartner]

The error is:

06:01:33 test_impl.go:340: test failure #1: full stack retained in failure_1.log: (sqlsmith.go:261).func3: error: pq: internal error: unexpected error from the vectorized engine: non-nullable column "table1:col1_0" with no value! Index scanned was "table1_pkey" with the index key columns (rowid) and the values (?)

I've been unable to reproduce this on any version so far, but I'l keep trying.

[mgartner]

I'm unable to reproduce. Closing.