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

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ b21379bb56dd206e6f63cc7d07ca72e85db7a4c4:

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-mutations/run_1
(sqlsmith.go:238).func3: error: pq: internal error: interface conversion: tree.Datum is tree.dNull, not *tree.DTSVector
stmt:
WITH
	"wi\vth5187" ("col'31001") AS (SELECT * FROM (VALUES ('jnbj':::rand_typ_0)) AS "ta b12696" ("col'31001")),
	with5188 (col31002)
		AS (
			SELECT
				*
			FROM
				(
					VALUES
						(3786009717:::OID),
						(3310275310:::OID),
						(1051938391:::OID),
						(1158282869:::OID),
						(1802237034:::OID),
						(2783536949:::OID)
				)
					AS tab12697 (col31002)
		)
SELECT
	'05:52:32.070559+12:49:00':::TIMETZ AS col31003,
	(('30.106.162.35/16':::INET::INET + crdb_internal.num_inverted_index_entries(NULL::TSVECTOR, (-2667264659334504276):::INT8::INT8)::INT8::INT8)::INET::INET || "tAb😷12698".col1_7::STRING)::STRING
		AS c😦ol31004,
	e'fe9 ~\bv.\t':::STRING AS "c oL31005"
FROM
	defaultdb.public.table1@[0] AS "tAb😷12698"
	JOIN defaultdb.public.table1@[0] AS "t'ab12699" ON ("tAb😷12698".col1_9) = ("t'ab12699".col1_11)
LIMIT
	39:::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-23659

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ b21379bb56dd206e6f63cc7d07ca72e85db7a4c4:

	tab😻7031.col1_6 AS "c*ol15346",
	'21:34:44.275045':::TIME AS col15347,
	tab7032.col1_9 AS col15348,
	ARRAY[B'1011001111111011110111010001000011000110010',B'1101000000111111110110000001111011011101100']
		AS "col%v15349",
	'''zGsGMJJ'' <-> ''ZeJ'' | ''WbLzBJmRV'' | ''dYCeXJa'' & ''nfIwztPSN''':::TSQUERY AS col15350,
	tab😻7031.col1_3 AS "coL15351"
FROM
	(
		WITH
			"with\\xe92894" (col15340)
				AS (
					SELECT
						*
					FROM
						(
							VALUES
								((2147483647:::INT8::INT8 | 8896731334925525962:::INT8::INT8)::INT8),
								(NULL),
								(
									crdb_internal.num_inverted_index_entries(NULL::TSVECTOR, 3161162295634490841:::INT8::INT8)::INT8
								)
						)
							AS "ta b7028" (col15340)
				),
			with2895 (col15341)
				AS (
					SELECT
						st_pointfromwkb(NULL::BYTES, "cte_ref""788".col15340::INT8)::GEOMETRY AS col15341
					FROM
						"with\\xe92894" AS "cte_ref""788"
					WHERE
						false
				)
		SELECT
			uuid_generate_v1()::UUID AS co😤l15342, now():::DATE::DATE AS col15343
		FROM
			defaultdb.public.table3@table3_pkey AS tab😬7029
		LIMIT
			22:::INT8
	)
		AS "t ab7030" ("co*l15344", col15345),
	defaultdb.public.table1@[0] AS tab😻7031,
	defaultdb.public.table1@[0] AS tab7032
WHERE
	tab😻7031.col1_0
ORDER BY
	tab😻7031.col1_12 DESC NULLS LAST
LIMIT
	58:::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!

[msirek]

dup of #95671