(sqlsmith.go:258).func3: error: pq: internal error: building declarative schema change targets for CREATE FUNCTION: ReturnType called on TypedExpr with empty typeAnnotation. Was the underlying Expr type-checked before asserting a type of TypedExpr?
stmt:
CREATE FUNCTION func🙁428(IN p0 GEOGRAPHY, IN p1 REGCLASS, IN p2 BYTES, IN p3 rand_typ_1, IN p4 TIMESTAMP, IN p5 TSQUERY, IN p6 GEOGRAPHY, IN p7 OIDVECTOR, IN p8 DECIMAL)
RETURNS SETOF RECORD
RETURNS NULL ON NULL INPUT
VOLATILE
LANGUAGE SQL
AS $funcbody$SELECT 3026675214:::OID AS "co l28019", p2 AS "|col28020", "tab�😺11710"."col""3_4" AS col28021, "tab�😺11710".col3_0 AS col28022, "tab�😺11710"."cOl3_7" AS col28023 FROM defaultdb.public."tabl\\x96e3"@"tabl\\x96e3_col3_3_col""3_4_expr_col3_5_co%ql3_1_co"" l\g3_10_col3_2_key" AS "tab�😺11710" WHERE true ORDER BY "tab�😺11710".col3_0 DESC NULLS LAST, "tab�😺11710".col3_5 NULLS FIRST, "tab�😺11710"."co'l3_6" ASC NULLS LAST LIMIT 2:::INT8;
SELECT '1971-02-05 22:57:53.000533':::TIMESTAMP AS col😎28024, p7 AS "c ol28025", st_geogfromgeojson(e'\x01U':::STRING::STRING)::GEOGRAPHY AS "c%pol28026", p2 AS col28027, regclass(p1::OID)::REGCLASS AS "😅c%ol28028", '''yRyhokDfkg''':::TSQUERY AS "co""l28029", p0 AS "co'l28030";
SELECT 4.502830228560990032:::DECIMAL AS col28031, 0:::OID AS "col
28032", 970746649:::OID AS "cOl28033" FROM defaultdb.public.table1@table1_co̯l1_8_key AS tab11711, defaultdb.public."table 2"@"table 2_col2_1_.col2_0_idx" AS tab11712 JOIN defaultdb.public."tabl\\x96e3"@"tabl\\x96e3_col3_3_col""3_4_expr_col3_5_co%ql3_1_co"" l\g3_10_col3_2_key" AS tab11713 ON (tab11712.tableoid) = (tab11713."co%ql3_1") WHERE NULL LIMIT 30:::INT8;
SELECT p5 AS col28034 FROM defaultdb.public."table 2"@"table 2_expr_col2_1_idx" AS "t(a\\U0003910Cb😙11714" LIMIT 15:::INT8;
SELECT " ta\fb\\U000C6A3811715".col1_7 AS col28035, p3 AS "c""ol28036", md5(p2::BYTES)::STRING AS col28037, '01030000E0E6100000010000000C0000004A5DF8BFCDC161C09EB475EDC00B43C0EC903E207176E741C2D3BA46290601C2806078ED2BA43140700B08FBE69A3CC092C881C05E60F8C1F00FBCCB66CA0042C476A3E3020D55401997CA1C81D255C070737C24AE0FEE41FC514311E7F2E84184312C30482E524000B842E0729344C0C0E487AA3DF2E641F64EE57188FFE3C190B8DF05C9845D402A98F570DDD453C0F41C5F828038EA41E0D0898EB28AF041DC555FECDEF85640F8F03BE91CE837C00A3666A59401024228CE0304F255DC4196C4D1869C3F5140C0DADDD73CB807409C77C17770B4E341F0C5D1FD8DEAC2C18823A88CADD25940E057D8E0321D45400C7E5C0CAF1CE6C1753BD810EF9001C2E4F2CDBFD3DF5B405A0AF0075B8353408C0ABA8C073F02C2D0A5635B94F7CEC1CCC3534C70E243403C6F5F6A1ED64140AA22CA483075F7C1D272DE6ED691EAC1A7ADAC83672F66C0BC21F37D32894540B89928E0B2C9E841DA103C055E12EAC14A5DF8BFCDC161C09EB475EDC00B43C0EC903E207176E741C2D3BA46290601C2':::GEOGRAPHY AS col28038, p5 AS "Col28039", " ta\fb\\U000C6A3811715"."""col1_2" AS "col�28040" FROM defaultdb.public.table1@[0] AS " ta\fb\\U000C6A3811715" ORDER BY " ta\fb\\U000C6A3811715"."'co
l😶1_6" ASC NULLS FIRST;
SELECT '0102000020E61000000900000045601746204661C0C199104CA07D49C0E3DE781FAA875DC0CBDB682CF6F948C0C8BD1EF641EF38C04E7082AE1AD93FC000A8111949B23D402A62B99E1D5A52C0C264C25626F862402C4C9FE585C83FC0E09C7F0D735A59409C3BC58474634A400A7E1BBD15DF5040B6355AA997F84140C0C1BA0A4D052440DCF5A7C1B946504058B86881AD3B58C058343AC593D65040':::GEOGRAPHY AS col28041, 3994915626:::OID AS col28042, NULL AS col_28043, "t%qAb%q11716".😆col3_9 AS _col28044, p8 AS cͥol͢28045 FROM defaultdb.public."tabl\\x96e3"@"tabl\\x96e3_col3_2_expr_😆col3_9_col3_5_co"" l\g3_10_col3_8_col3_3_co'l3_6_co%ql3_1_cOl3_7_idx" AS "t%qAb%q11716" LIMIT 66:::INT8;
SELECT (NULL,) AS "c ol28047" FROM defaultdb.public."tabl\\x96e3"@"tabl\\x96e3_pkey" AS "tab\\x6d11717", defaultdb.public."table 2"@[0] AS tab11718 WHERE (SELECT 'mtyfv':::rand_typ_0 AS col28046 FROM defaultdb.public.table1@table1_co̯l1_8_key AS "ta&b11719" WHERE (NOT false) LIMIT 1:::INT8)::rand_typ_0 IN ('kcvlu':::rand_typ_0,)$funcbody$;
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-mutations/run_1
roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ 1eb628e8c8a7eb1cbf9bfa2bd6c31982c25cbba0:
Parameters:
ROACHTEST_arch=amd64,ROACHTEST_cloud=gce,ROACHTEST_cpu=4,ROACHTEST_encrypted=false,ROACHTEST_ssd=0Help
See: roachtest README
See: How To Investigate (internal)
This test on roachdash | Improve this report!
Jira issue: CRDB-28946