sql/tests: TestRandomSyntaxSQLSmith failed #158489
Description
sql/tests.TestRandomSyntaxSQLSmith failed with artifacts on master @ 0f2bc7b8fb79175f32fe44754a872845cd01e038:
rsg_test.go:802: To reproduce, use schema:
rsg_test.go:804: SET sql_safe_updates = false;;
rsg_test.go:804: SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;;
rsg_test.go:804: SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;;
rsg_test.go:804: SET CLUSTER SETTING sql.stats.forecasts.enabled = false;;
rsg_test.go:804: CREATE TABLE "tab""%vle_1" ("c
ol1_0" JSONB NOT NULL, " col1_1" REGCLASS NULL, col1_2 VARCHAR NULL, "col 1_3" JSONB NOT NULL, "�col1_4" TSQUERY, col1_5 INET NULL, col1̭_6 STRING NOT NULL AS (lower(CAST("c
ol1_0" AS STRING))) STORED, col1_7 STRING AS (lower(CAST("�col1_4" AS STRING))) STORED, col1_8 STRING NOT NULL AS (lower(col1_2)) VIRTUAL, "col\\U0003EE191_9" STRING NULL AS (lower(CAST("col 1_3" AS STRING))) STORED, PRIMARY KEY ("col 1_3" DESC, col1_8 DESC), INDEX (" col1_1" ASC) PARTITION BY LIST (" col1_1") (PARTITION "tab""%vle_1_part_0" VALUES IN ((3373403031:::REGCLASS,), (2933516634:::REGCLASS,), (2261144072:::REGCLASS,), (0:::REGCLASS,), (3647396511:::REGCLASS,), (2355242128:::REGCLASS,), (108239889:::REGCLASS,), (195220208:::REGCLASS,), (165557946:::REGCLASS,), (637544929:::REGCLASS,)), PARTITION "tab""%q%)vl e_1_part_1" VALUES IN ((114254125:::REGCLASS,), (1044044291:::REGCLASS,), (1805514096:::REGCLASS,), (2666744709:::REGCLASS,), (1694303647:::REGCLASS,), (3599009539:::REGCLASS,), (556458712:::REGCLASS,), (1361284581:::REGCLASS,)), PARTITION "tab""%vle_1_part_2" VALUES IN ((3476836084:::REGCLASS,), (3183866811:::REGCLASS,), (1270854734:::REGCLASS,), (389598214:::REGCLASS,), (777490107:::REGCLASS,), (96715366:::REGCLASS,), (1758666472:::REGCLASS,), (1530118242:::REGCLASS,)), PARTITION "tab""%vle_1😚_part_3" VALUES IN ((1150610203:::REGCLASS,), (2594832066:::REGCLASS,), (3694264966:::REGCLASS,), (1362241417:::REGCLASS,), (859574463:::REGCLASS,), (3358721934:::REGCLASS,), (2106874706:::REGCLASS,), (2584943960:::REGCLASS,), (2521974828:::REGCLASS,)), PARTITION "tab""%vl""e_.1_part_4" VALUES IN ((2541984109:::REGCLASS,), (1034689860:::REGCLASS,), (4251413697:::REGCLASS,), (4214298545:::REGCLASS,), (2403728913:::REGCLASS,)), PARTITION "tab""%vle_1_part_5" VALUES IN ((905022166:::REGCLASS,), (906096688:::REGCLASS,), (3957302115:::REGCLASS,), (1937061353:::REGCLASS,), (2982041025:::REGCLASS,), (1286497077:::REGCLASS,), (2481628314:::REGCLASS,), (2991833617:::REGCLASS,))) WHERE "tab""%vle_1".col1_8 = e'\'':::STRING, UNIQUE ("c
ol1_0" ASC, lower(CAST("�col1_4" AS STRING)), col1̭_6) STORING (col1_5, "col\\U0003EE191_9") WHERE ((("tab""%vle_1".col1̭_6 = e'\'':::STRING) AND ("tab""%vle_1".col1_2 >= e'\'':::STRING)) AND ("tab""%vle_1"."col\\U0003EE191_9" <= 'X':::STRING)) AND ("tab""%vle_1".col1_8 = e'\U00002603':::STRING), INDEX (lower(CAST("�col1_4" AS STRING)) ASC) STORING ("c
ol1_0", col1_2, col1_7) NOT VISIBLE, INVERTED INDEX (" col1_1" ASC, col1̭_6, col1_7 DESC, "col 1_3", "c
ol1_0" ASC) WHERE (("tab""%vle_1".col1_7 >= e'\x00':::STRING) AND ("tab""%vle_1".col1̭_6 != e'\'':::STRING)) AND ("tab""%vle_1".col1_8 < e'\x00':::STRING), UNIQUE (" col1_1"), INDEX ("c
ol1_0", lower(CAST("col 1_3" AS STRING)), col1_5 ASC) STORING (" col1_1", "�col1_4", col1̭_6, col1_7, "col\\U0003EE191_9") WHERE (((("tab""%vle_1"."col\\U0003EE191_9" > e'\x00':::STRING) OR ("tab""%vle_1".col1_2 != '"':::STRING)) AND ("tab""%vle_1".col1̭_6 < 'X':::STRING)) AND ("tab""%vle_1".col1_8 >= e'\'':::STRING)) AND ("tab""%vle_1".col1_7 > '"':::STRING), INDEX (" col1_1" ASC) STORING ("c
ol1_0", col1_2, "�col1_4", col1_5, col1̭_6, col1_7) WHERE (((("tab""%vle_1".col1_2 != '':::STRING) AND ("tab""%vle_1".col1_7 < '':::STRING)) OR ("tab""%vle_1".col1̭_6 = '':::STRING)) OR ("tab""%vle_1"."col\\U0003EE191_9" >= '"':::STRING)) AND ("tab""%vle_1".col1_8 != '"':::STRING) NOT VISIBLE);
rsg_test.go:804: CREATE TABLE "\\U0002A0A5ta😇b͍l e_2" (col2_0 LTREE NOT NULL, "\\uD642col2_1" INTERVAL NULL, col2_2 TSVECTOR NOT NULL, col2_3 REGTYPE NULL, "co%vl2😡_4" INT2 NOT NULL, col2_5 JSONB NOT NULL, col2_6 INT8 NOT NULL, col͟2_7 TIMESTAMPTZ, col2_8 INT8 NOT NULL AS ("co%vl2😡_4" + col2_6) VIRTUAL, col2_9 STRING NOT NULL AS (lower(CAST(col2_0 AS STRING))) STORED, "co'l2_10" STRING NULL AS (lower(CAST(col2_5 AS STRING))) STORED, PRIMARY KEY (col2_5 DESC), INDEX (col2_6 DESC), UNIQUE ((CASE WHEN col͟2_7 IS NULL THEN e'\t':::STRING ELSE '':::STRING END) DESC, col͟2_7 ASC), INDEX (col2_9 DESC) STORING (col2_0, col2_2, "co%vl2😡_4", col2_6, "co'l2_10"), INDEX (col2_9 ASC, "co%vl2😡_4" DESC) PARTITION BY LIST (col2_9, "co%vl2😡_4") (PARTITION "%p\\U0002A0A5ta😇😡b͍l e_2_part_0" VALUES IN (('X':::STRING, 1:::INT8), ('5':::STRING, 1:::INT8), (e',1(\x1d\x1f':::STRING, 32767:::INT8)), PARTITION "\""\U0002\\U000ED10FA0A5ta😇b%ca͍l e_2_part_1" VALUES IN (('':::STRING, 6646:::INT8), (e'C\x02``|Ul\\}':::STRING, (-21825):::INT8), (e'\x15S\\4':::STRING, (-16632):::INT8)), PARTITION "\\U0002A0A5ta😇b͍l e_2_part_2" VALUES IN ((e'Iu!R\x13}\\!\x06':::STRING, 127:::INT8), (e'C;T-Q\x18\t':::STRING, (-1):::INT8), (e'\r,\t^-\x04':::STRING, (-26780):::INT8)), PARTITION "\\U000%ff2A0A5ta😇b͍l e_2_part_3" VALUES IN ((e'1\x0e':::STRING, 2415:::INT8), (e'Ek\x16J\x03``':::STRING, (-22407):::INT8), (e'G\x1co\x02\x19N6.>':::STRING, (-20423):::INT8)), PARTITION "\\U0002A0A5ta😇b͍l e_2_part_4" VALUES IN ((e'$O_\'A\x10~K':::STRING, 23678:::INT8), (e'\x12':::STRING, 6729:::INT8), (e'\x1c~)]t;':::STRING, (-6311):::INT8)), PARTITION "\\U0002A0A5ta😇b͍l e_2_part_5" VALUES IN (('':::STRING, 29504:::INT8), ('':::STRING, 7013:::INT8), ('}!':::STRING, 7923:::INT8)), PARTITION "\\U0002A0A5ta😇b͍l e_2_part_6" VALUES IN ((e'|\x01\x0f\x15\x03*.l':::STRING, (-16992):::INT8), (e'BIv"\x1c':::STRING, 16822:::INT8), (e'nD\x05rIs':::STRING, 31841:::INT8))) WHERE ((((("\\U0002A0A5ta😇b͍l e_2".col2_9 < e'\'':::STRING) OR ("\\U0002A0A5ta😇b͍l e_2".col2_8 > 1:::INT8)) AND ("\\U0002A0A5ta😇b͍l e_2".col2_6 < 1:::INT8)) AND ("\\U0002A0A5ta😇b͍l e_2"."co%vl2😡_4" > 0:::INT8)) OR ("\\U0002A0A5ta😇b͍l e_2".col͟2_7 > '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ)) OR ("\\U0002A0A5ta😇b͍l e_2"."co'l2_10" < '':::STRING) NOT VISIBLE, UNIQUE (col2_9 ASC), UNIQUE (col2_8, col2_0 DESC) WHERE "\\U0002A0A5ta😇b͍l e_2".col2_6 <= (-128):::INT8, UNIQUE (col2_3 ASC) STORING ("\\uD642col2_1", col͟2_7, col2_9), FAMILY (col2_0), FAMILY (col2_2), FAMILY (col͟2_7, "co'l2_10", "\\uD642col2_1", col2_5, "co%vl2😡_4", col2_9, col2_3, col2_6));
rsg_test.go:804: ALTER TABLE "tab""%vle_1" INJECT STATISTICS e'[{"avg_size": 2, "columns": ["\\"c\\rol1_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1161409742742780672, "histo_buckets": [{"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": "null"}, {"distinct_range": 6263797917574050000, "num_eq": 6111251417801999360, "num_range": 8456108142806168576, "upper_bound": "{\\"test\\": \\"json\\"}"}, {"distinct_range": 894.1432053178041, "num_eq": 5000, "num_range": 900, "upper_bound": "{\\"PT\\": \\"baz\\", \\"bar\\": null, \\"baz\\": [null]}"}, {"distinct_range": 7492299213962061000, "num_eq": 3297794050767484928, "num_range": 7492299213962060800, "upper_bound": "[{\\"DwN\\": [[\\"SFPDeXs9\\"], \\"baz\\"], \\"KxUkc6TsQ\\": \\"bar\\", \\"foo\\": false}, [false, true, false], {\\"b\\": null}, 2.90487186680474, true, false]"}, {"distinct_range": 1924466210222122200, "num_eq": 2716247456203506688, "num_range": 3947516379247985152, "upper_bound": "{\\"8ypu5Bui\\": \\"b\\", \\"9c\\": [{\\"DgoXPxymm\\": 0.21800247120901478}, null, false], \\"a\\": [0.20677090707039078, true], \\"bar\\": {\\"GkX\\": \\"c\\", \\"foobar\\": false}, \\"c\\": null, \\"dwHjZgonj\\": true}"}, {"distinct_range": 5291.237108682748, "num_eq": 900, "num_range": 10000, "upper_bound": "{\\"50AgYnOH\\": null, \\"a\\": {\\"5HRTX\\": {\\"rSvhB\\": null}, \\"79zayawH\\": \\"foo\\", \\"XoAEjB\\": {\\"baz\\": 2.481291352583815}, \\"baz\\": \\"foobar\\", \\"foobar\\": {\\"A9c\\": 1.261254783269899, \\"KBB9s\\": false, \\"SNc6bGUH\\": true}, \\"uQ\\": [\\"a\\"]}, \\"hYJaj\\": 1.3289681648077194}"}], "histo_col_type": "JSONB", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 1924551365382542682}, {"avg_size": 6, "columns": ["\\" col1_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 26080661851804744, "histo_buckets": [{"distinct_range": 0, "num_eq": 20000000000, "num_range": 0, "upper_bound": "1770965400"}, {"distinct_range": 0, "num_eq": 3629742190296564224, "num_range": 8580910409143847936, "upper_bound": "858616920"}, {"distinct_range": 0, "num_eq": 400, "num_range": 6764665635315831808, "upper_bound": "4181040055"}], "histo_col_type": "REGCLASS", "histo_version": 3, "name": "__auto__", "null_count": 1383834269709034907, "row_count": 1924551365382542682}, {"avg_size": 29, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 633905439800503553, "histo_col_type": "", "name": "__auto__", "null_count": 910222632569500702, "row_count": 1924551365382542682}, {"avg_size": 23, "columns": ["\\"col 1_3\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 903500766088585216, "histo_buckets": [{"distinct_range": 0, "num_eq": 6172541730213159936, "num_range": 0, "upper_bound": "{}"}, {"distinct_range": 25019979.243378602, "num_eq": 600, "num_range": 30000000, "upper_bound": "[true]"}, {"distinct_range": 4000000000, "num_eq": 3443852751902139392, "num_range": 4000000000, "upper_bound": "1"}, {"distinct_range": 1000000, "num_eq": 5092757809150849024, "num_range": 1000000, "upper_bound": "[true, null, false]"}, {"distinct_range": 8785318757224506000, "num_eq": 400000000, "num_range": 8785318757224506368, "upper_bound": "{\\"c\\": \\"CLLV\\", \\"foo\\": 1.4885053585924264}"}, {"distinct_range": 198577.37444778904, "num_eq": 5241529214462412800, "num_range": 200000, "upper_bound": "[{\\"fY\\": 5.838774423146595, \\"foobar\\": \\"bar\\"}, false, \\"zaVmwSBi\\"]"}, {"distinct_range": 0, "num_eq": 2891774487258304512, "num_range": 6910113965074298880, "upper_bound": "{\\"UZ3\\": null, \\"a\\": 0.5329756741412938, \\"b\\": false, \\"sndt5P\\": [null], \\"tMIEWUa\\": null, \\"uz\\": false}"}, {"distinct_range": 0, "num_eq": 236450016564410016, "num_range": 70000, "upper_bound": "{\\"a\\": \\"hpW\\", \\"foo\\": {\\"Ssch1V7vL\\": 0.4290950382840436, \\"a\\": [false, true], \\"xh4iyn\\": true}}"}, {"distinct_range": 0, "num_eq": 100, "num_range": 50000000, "upper_bound": "[[0.264013944728246, {\\"WFbLWK8m\\": null, \\"foobar\\": true}, null, null], {\\"GUM9\\": {\\"baz\\": null}, \\"foobar\\": true}, [{\\"XUH2x\\": true}, 0.04431491658662384, true], null, \\"kRD\\", null]"}], "histo_col_type": "JSONB", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 1924551365382542682}, {"avg_size": 10, "columns": ["\\"\\u000ccol1_4\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 670357067489939137, "histo_col_type": "", "name": "__auto__", "null_count": 1112803317230423698, "row_count": 1924551365382542682}, {"avg_size": 6, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1616458235004000125, "histo_col_type": "", "name": "__auto__", "null_count": 1440241000642181152, "row_count": 1924551365382542682}, {"avg_size": 4, "columns": ["col1\u032D_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 466743895116101388, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1924551365382542682}, {"avg_size": 23, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 216359703230216910, "histo_col_type": "", "name": "__auto__", "null_count": 274034135589531347, "row_count": 1924551365382542682}, {"avg_size": 21, "columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 509809883787505224, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1924551365382542682}, {"avg_size": 19, "columns": ["\\"col\\\\\\\\U0003EE191_9\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 18580399464284951, "histo_col_type": "", "name": "__auto__", "null_count": 164055547357531675, "row_count": 1924551365382542682}]':::JSONB;
rsg_test.go:804: ALTER TABLE "\\U0002A0A5ta😇b͍l e_2" INJECT STATISTICS e'[{"avg_size": 1, "columns": ["col2_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3016697055351463382, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 0, "columns": ["\\"\\\\\\\\uD642col2_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1872109261854724498, "histo_col_type": "", "name": "__auto__", "null_count": 522701366473544003, "row_count": 5522979408722141990}, {"avg_size": 29, "columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3861843209760711103, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 26, "columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1009051439691765888, "histo_buckets": [{"distinct_range": 0, "num_eq": 200000, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 6454011305374118000, "num_eq": 50000, "num_range": 8223782908616357888, "upper_bound": "2181340506"}, {"distinct_range": 59641846571.289825, "num_eq": 50000, "num_range": 90000000000, "upper_bound": "356943674"}, {"distinct_range": 100000000, "num_eq": 900000000, "num_range": 100000000, "upper_bound": "303850047"}], "histo_col_type": "REGTYPE", "histo_version": 3, "name": "__auto__", "null_count": 4933858377062360881, "row_count": 5522979408722141990}, {"avg_size": 1, "columns": ["\\"co%vl2\U0001F621_4\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4565494403657791801, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 6, "columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3474290483401774592, "histo_buckets": [{"distinct_range": 0, "num_eq": 6832031321528651776, "num_range": 0, "upper_bound": "[[0.9605301641118806, null], null, null, true, true, \\"baz\\"]"}, {"distinct_range": 0, "num_eq": 100000, "num_range": 1838199106576275200, "upper_bound": "{\\"b\\": true, \\"baz\\": true, \\"yEnO\\": [true, \\"iNOOdUUhA\\", \\"c\\"]}"}, {"distinct_range": 9000000000, "num_eq": 8000, "num_range": 9000000000, "upper_bound": "{\\"2hYwPi9\\": null, \\"Mo6SoU2u\\": [0.7436866110407697, false], \\"Yo4J97\\": 0.7661298818904272, \\"yNL6p\\": 0.0010062576026392822}"}, {"distinct_range": 2430882517101157000, "num_eq": 1883640232830572800, "num_range": 5352355018445729792, "upper_bound": "{\\"285tftoRl\\": \\"HtEK8Lv3\\", \\"9L\\": true, \\"C7HHM7\\": [\\"czj1Yfm\\", false], \\"foo\\": {\\"BCTJL8wb\\": 0.2486945748898568, \\"foobar\\": false, \\"qrwijp4W\\": [\\"Oob2lor\\"]}, \\"meZKkJ\\": null, \\"zHvX\\": [{\\"xL4vTMUn\\": 0.10340429109842453}, null, {\\"GOpRvgY\\": 1.1003116759297713, \\"baz\\": [true]}, \\"a\\", false]}"}], "histo_col_type": "JSONB", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 9, "columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 767543834171836690, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 16, "columns": ["col\u035F2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2588902963872673651, "histo_col_type": "", "name": "__auto__", "null_count": 667248907787902479, "row_count": 5522979408722141990}, {"avg_size": 18, "columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 763304073674072576, "histo_buckets": [{"distinct_range": 0, "num_eq": 3366671263237335040, "num_range": 0, "upper_bound": "1"}, {"distinct_range": 24.210525403815705, "num_eq": 10000, "num_range": 30, "upper_bound": "6755491685767866371"}, {"distinct_range": 18151.92365161355, "num_eq": 5507667898485919744, "num_range": 60000, "upper_bound": "-2642565899359579972"}, {"distinct_range": 5206679746586054000, "num_eq": 4765771405780699136, "num_range": 5206679746586053632, "upper_bound": "-9092078247032579915"}, {"distinct_range": 235111624712014050, "num_eq": 0, "num_range": 2497595077471435776, "upper_bound": "-7323551646588190476"}, {"distinct_range": 1505793744220161300, "num_eq": 3355107924330038784, "num_range": 8467776036536201216, "upper_bound": "2055330945183369250"}, {"distinct_range": 0, "num_eq": 0, "num_range": 2000000, "upper_bound": "-8043207575295040550"}, {"distinct_range": 0, "num_eq": 10000000000, "num_range": 9000000, "upper_bound": "-2147483648"}], "histo_col_type": "INT8", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 20, "columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5103938882276057088, "histo_buckets": [{"distinct_range": 0, "num_eq": 8821748393731115008, "num_range": 0, "upper_bound": "\\u0004D^\\n5l"}, {"distinct_range": 0, "num_eq": 8517548106818235392, "num_range": 9148764421119165440, "upper_bound": "|yBN$\\u0012"}], "histo_col_type": "STRING", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 5522979408722141990}, {"avg_size": 16, "columns": ["\\"co\'l2_10\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 460349466511297178, "histo_col_type": "", "name": "__auto__", "null_count": 3595534471657288395, "row_count": 5522979408722141990}]':::JSONB;
rsg_test.go:804: CREATE TYPE rand_typ_0 AS (epmhg OID);
rsg_test.go:804: CREATE TYPE rand_typ_1 AS ENUM ('ies', 'kyuxpo', 'wxibvr', 'xbuakl', 'qllxh');
rsg_test.go:804: CREATE TYPE rand_typ_2 AS ENUM ('xgxyn');
rsg_test.go:804: SET sql_safe_updates = false;;
rsg_test.go:804:
BEGIN; CREATE TYPE greeting AS ENUM ('hello', 'howdy', 'hi', 'good day', 'morning'); COMMIT;
BEGIN;
CREATE TABLE IF NOT EXISTS seed AS
SELECT
g::INT2 AS _int2,
g::INT4 AS _int4,
g::INT8 AS _int8,
g::FLOAT4 AS _float4,
g::FLOAT8 AS _float8,
'2001-01-01'::DATE + g AS _date,
'2001-01-01'::TIMESTAMP + g * '1 day'::INTERVAL AS _timestamp,
'2001-01-01'::TIMESTAMPTZ + g * '1 day'::INTERVAL AS _timestamptz,
g * '1 day'::INTERVAL AS _interval,
g % 2 = 1 AS _bool,
g::DECIMAL AS _decimal,
g::STRING AS _string,
g::STRING::BYTES AS _bytes,
substring('00000000-0000-0000-0000-' || g::STRING || '00000000000', 1, 36)::UUID AS _uuid,
'0.0.0.0'::INET + g AS _inet,
g::STRING::JSONB AS _jsonb,
enum_range('hello'::greeting)[g] as _enum
FROM
generate_series(1, 5) AS g;
COMMIT;
INSERT INTO seed DEFAULT VALUES;
CREATE INDEX on seed (_int8, _float8, _date);
CREATE INVERTED INDEX on seed (_jsonb);
;
rsg_test.go:804: ALTER TABLE seed SPLIT AT VALUES (5329207693660597018);
rsg_test.go:804: ALTER TABLE seed SPLIT AT VALUES (5189555944591013416);
rsg_test.go:804: ALTER TABLE seed SCATTER;
rsg_test.go:806:
rsg_test.go:807: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxSQLSmith1628544952
--- FAIL: TestRandomSyntaxSQLSmith (302.24s)
This test on roachdash | Improve this report!
Jira issue: CRDB-57334