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

[cockroach-teamcity]

roachtest.sqlsmith/setup=seed/setting=no-mutations failed with artifacts on master @ a2c2c060a423ee410b57868e657df644f2619cb3:

(sqlsmith.go:258).func3: error: pq: internal error: building declarative schema change targets for CREATE FUNCTION: runtime error: index out of range [2] with length 2
stmt:
CREATE FUNCTION "Func153"(IN p0 GEOMETRY, IN p1 greeting, IN p2 BIT(44), IN p3 OID, IN p4 TSVECTOR, IN p5 OID, IN p6 INT4, IN p7 NAME, IN p8 TIMESTAMPTZ)
	RETURNS SETOF BYTES
	RETURNS NULL ON NULL INPUT
	LANGUAGE SQL
	AS $funcbody$SELECT p7 AS ",c ol11638", '010600008007000000010300008001000000060000006B1078EB687CFBC14E475A766E7BF2C19301852397BFFAC1E0A638046CC1DB41FC8A32CB032BE8C16C8157DE2CBBFE418EAD84B04ED2F8416DB0E5226082FFC1F4487FD5AE8AF0C124C2262E92EE0042F095124BB7C5F54108D858937242F641EC1E05C39799E341825D8691268EE1C1C83F632FF67F02426B1078EB687CFBC14E475A766E7BF2C19301852397BFFAC101030000800100000005000000C096205CAC74A141CCC0589FF5A0E841CCE1512CDA7DEDC1E0E7502392E2B7417CBF1DAC3A8FE64111C166331649F8C1045235600CB9FD41564B7C9D4354F341779B629389DAFDC100B3547540BCBD417C3475F9C8A8F741924918BFFBB0EBC1C096205CAC74A141CCC0589FF5A0E841CCE1512CDA7DEDC1010300008001000000050000003AF14EE1044700C2F20BEB2FCA4600C22510B48ABF2CF3C1888049688071E04169FE4C5EEB2CFEC1D7BE706DC19201C2FA7AA3D1D21BF34180E13F2B2053BEC16805C57C6ABBE1C104E8B64637C4F2C14C138EDCBC08F4410F55B2F96937FFC13AF14EE1044700C2F20BEB2FCA4600C22510B48ABF2CF3C101030000800100000004000000149D5E58494DDBC1240E16BF23CCD7C150C6240C339BC4C164C573031F28F7419A38093593E5F0419CE9F41F25130242D803CF19EFF0F7C1BEF10E9C894DF3415B40DEF0A58E02C2149D5E58494DDBC1240E16BF23CCD7C150C6240C339BC4C101030000800100000004000000C9953BBE048401C250F527BBC69CCFC1FA02BB6873CBF1C1B8C5895292B5E64120E78CD36340C9418DB6C35EB931F7C160940B1E878CC1C1DEA23DCA9652004278AB0B978160E8C1C9953BBE048401C250F527BBC69CCFC1FA02BB6873CBF1C1010300008001000000090000006A5A844BAD75E9C1D01DD9859765E0C174A3BE315E76EF41D74865DD0F7401C2A809E98C3B06F6C18C338707E90BFB410050A48BB97902C242F927C47C5BF8C1D810A724884AD4414CCC5A436CFAE34173F658FFB74000C2E8AEA19F0E47FB41889EFFB85CD0FB4106DE6B82DD1FF7C1CA1C0558C40FF8414C0BA4534831EF411853586B3428D9416CDFBD89F3E60042D4B6E82B946CEF41ECB1F9784BFCFE419811A3A7C863F0C10934CEED8809F3C1ECFE23B71D14FC41A2696EC53382F6C16A5A844BAD75E9C1D01DD9859765E0C174A3BE315E76EF410103000080010000000C000000A8BAF2EE2339FAC12EBE0385C3A2E4C1D00535D120A3EE4104E7B409C455D9C1A81E0264E56DDEC10ED53A4956E9FBC1EEB701C0CA1FE6C142BFDF5CCA9EF0C198188472B326FDC14011348E4A2CE8C1F9A22656CC5AFCC160C29FAE47E1B34170CAC4023B86C341F2D7864BFDE3EBC1200F0D3FD613CC41E0D9A6B8551FE341B606D0F4E7F3E4C1487F149208B900C2824E10D5822D00422ADF7DDF1C30F2C1F41E17056AB7E7C15ED36FFAA65C014290BE8234DD12F041292674409944FAC17448EF44EF430042148C234030DF0142FF1165F0463201C2C14ED7E0C40AF0C1DCD8584966A6EF411AF1707C400900C20468F88AFB7201C22AB1E45D5D3CF2417EFC87F46E86E1C1A8BAF2EE2339FAC12EBE0385C3A2E4C1D00535D120A3EE41':::GEOMETRY AS 😫col11639, p8 AS col11640, p3 AS col11641, p5 AS col😙11642 LIMIT 4:::INT8;
SELECT '2002-09-21 07:18:45.000216+00':::TIMESTAMPTZ AS col11643, "ta""b4468"._enum AS col11644, p5 AS col11645 FROM defaultdb.public.seed@seed__int8__float8__date_idx AS "ta""b4468" WHERE "ta""b4468"._bool ORDER BY "ta""b4468"._bool NULLS FIRST LIMIT 45:::INT8;
SELECT p5 AS col11646, '{"Wo1p64": false, "foobar": null, "yjWf": "c"}':::JSONB AS "cOl 11647", p0 AS col11648, p7 AS col̒11649, 0:::OID AS col11650, p6 AS "c%po😑l11651", tab4470._jsonb AS col11652 FROM defaultdb.public.seed AS tab4469 JOIN defaultdb.public.seed AS tab4470 ON (tab4469._jsonb) = (tab4470._jsonb) WHERE false;
SELECT count(*) AS col😏11653 FROM defaultdb.public.seed@seed__int8__float8__date_idx AS "ta b4471" GROUP BY "ta b4471"._int8, "ta b4471"._date HAVING bool_and(false::BOOL)::BOOL;
SELECT bool_or(tab4472._bool::BOOL)::BOOL AS col11654, tab4472._float4 AS " col😁11655", NULL AS "\\x10c%vol\\U0000ADA511656", regr_count(NULL::DECIMAL, tab4472._int8::INT8) OVER (PARTITION BY tab4472._float4 ORDER BY tab4472._int8 DESC NULLS LAST, tab4472._timestamp ASC NULLS LAST RANGE BETWEEN CURRENT ROW AND CURRENT ROW)::INT8 AS "col 11657" FROM defaultdb.public.seed@[0] AS tab4472, defaultdb.public.seed AS tab4473 JOIN defaultdb.public.seed AS "ta%pb4474" ON (tab4473._jsonb) = ("ta%pb4474"._jsonb) JOIN defaultdb.public.seed AS tab̀4475 JOIN defaultdb.public.seed AS tab4476 ON (tab̀4475._jsonb) = (tab4476._jsonb) ON ("ta%pb4474"._jsonb) = (tab̀4475._jsonb) GROUP BY tab4472._bool, tab4472._float4, tab4472._timestamp, tab4472._int8 HAVING every(tab4472._bool::BOOL)::BOOL ORDER BY tab4472._bool ASC NULLS FIRST, tab4472._timestamp NULLS LAST LIMIT 94:::INT8;
SELECT (-7820.639698624863350):::DECIMAL AS col11658, tab4478._int8 AS col11659, tab4477._decimal AS "cO%qlͅ%q11660", tab4478._timestamptz AS col11661, tab4478.tableoid AS col11662, tab4478._float4 AS "col\g11663" FROM defaultdb.public.seed@[0] AS tab4477 JOIN defaultdb.public.seed@[0] AS tab4478 ON (tab4477._inet) = (tab4478._inet) ORDER BY tab4477._int2 ASC NULLS FIRST;
SELECT "t\gab4479"._int4 AS "%pcol11664" FROM defaultdb.public.seed@seed__int8__float8__date_idx AS "t\gab4479" GROUP BY "t\gab4479"._int4 ORDER BY "t\gab4479"._int4 DESC NULLS LAST, "t\gab4479"._int4, "t\gab4479"._int4 NULLS LAST, "t\gab4479"._int4 DESC, "t\gab4479"._int4 DESC, "t\gab4479"._int4 DESC, "t\gab4479"._int4 NULLS FIRST, "t\gab4479"._int4 NULLS FIRST, "t\gab4479"._int4 DESC, "t\gab4479"._int4 DESC NULLS LAST, "t\gab4479"._int4 ASC NULLS FIRST, "t\gab4479"._int4 ASC NULLS LAST LIMIT 41:::INT8;
SELECT "tab""4481"._timestamptz AS col11666 FROM defaultdb.public.seed@seed__int8__float8__date_idx AS "'t\\x0eab4480" LEFT JOIN defaultdb.public.seed@seed__int8__float8__date_idx AS "tab""4481" ON "'t\\x0eab4480"._enum::greeting IN (SELECT "'t\\x0eab4480"._enum::greeting AS col11665 FROM defaultdb.public.seed@[0] AS "taB4482" WHERE "taB4482"._bool ORDER BY "taB4482".crdb_internal_mvcc_timestamp ASC NULLS FIRST, "taB4482"._inet DESC) WHERE false ORDER BY "'t\\x0eab4480"._decimal ASC NULLS LAST, "'t\\x0eab4480"._float8 NULLS FIRST, "tab""4481"._interval ASC, "tab""4481"._int8 LIMIT 41:::INT8;
SELECT '\x28d3d587':::BYTES AS "c)ol11667" FROM defaultdb.public.seed@[0] AS "ta%pb""4483" ORDER BY "ta%pb""4483"._timestamptz DESC NULLS LAST, "ta%pb""4483"._decimal ASC NULLS FIRST LIMIT 26:::INT8$funcbody$;
test artifacts and logs in: /artifacts/sqlsmith/setup=seed/setting=no-mutations/run_1

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

[mgartner]

Duplicate of #104242.