Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql/tests: TestRandomSyntaxSQLSmith failed #143040

Open
cockroach-teamcity opened this issue Mar 18, 2025 · 0 comments
Open

sql/tests: TestRandomSyntaxSQLSmith failed #143040

cockroach-teamcity opened this issue Mar 18, 2025 · 0 comments
Labels
branch-release-24.1.15-rc C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone
24.1

Comments

@cockroach-teamcity
Copy link
Member

sql/tests.TestRandomSyntaxSQLSmith failed with artifacts on release-24.1.15-rc @ eae6f674a9e6a0547822fdb1d9e92d1682deee55:

Random syntax error:

    rsg_test.go:962: Crash detected: server panic: pq: internal error: input set contains unknown columns

Query:

        SELECT
        	tab😩_527324._float8 AS "&col_1258822",
        	2687638987:::OID AS col_1258823,
        	tab😩_527324._decimal AS "c😶o
        l_1258824",
        	tab😩_527324._decimal AS c😑ol_1258825,
        	tab😩_527324._string AS col_1258826,
        	tab😩_527324._bytes::BYTES
        	NOT IN (
        			WITH
        				"w%a7i th_213493" (col_1258827)
        					AS (
        						SELECT
        							'0104000020E610000000000000':::GEOGRAPHY AS col_1258827
        						FROM
        							defaultdb.public.table_5@table_5_col5_12_idx AS tab_527325
        						WHERE
        							tab_527325.col5_3
        						UNION ALL
        							SELECT
        								*
        							FROM
        								(
        									VALUES
        										(
        											'0104000060E610000005000000010100004088911942CADF53C0E20068337F8E4DC05E52CA77D80101C201010000401ADE0F2A64814DC0ECCF015D6DEF3E406E084B4043A1FA410101000040555F0543C00563C0007B021B2EFD46C0A008290C7664C84101010000409BD088676C3F66C0A83F8ABCB5702F40B0E9D85F5C41E64101010000409828BCF0754562C03EDAAA04E7B74FC0404278E4B5C9CAC1':::GEOGRAPHY
        										),
        										(
        											(
        												WITH
        													"wIth_213492" (col_1258828)
        														AS (
        															SELECT
        																*
        															FROM
        																(
        																	VALUES
        																		('2017-04-02 18:19:59.000155+00':::TIMESTAMPTZ),
        																		('4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ),
        																		('1988-06-19 18:53:52.000622+00':::TIMESTAMPTZ),
        																		('2028-08-21 19:27:06.0007+00':::TIMESTAMPTZ),
        																		(
        																			to_timestamp(0.15489388113892555:::FLOAT8::FLOAT8)::TIMESTAMPTZ
        																		)
        																)
        																	AS "'t͛ab_527326" (col_1258828)
        														)
        												SELECT
        													'01030000E0E61000000100000009000000C2EA21E7979F63C0E0F42516842D15C074B1CC60F7E2FAC1B8619E2DC7FFFC416C22B9B7B2F658C07B66F428CCF840C08AA778EBDF0BF941B61B78905236F741F5C5DECE003054C05C962F5843703BC000928BBDA52CF64150F99FDDD07FE7C1C42E5C3559E06340003B59E91C26FD3F70A5C5C74BE8CA41C80CA7A4A0AB00C2EE4347F6A60A4CC048CD7EA9B74625405CDFC78A6966E241EED97F1518D1F441A8585AD4FA4B5140AC53CCDEA3773940FE362CA0C116FEC1969DAD5C2433FFC1A258546D5DAD61C0FC09648A9A495640D46E84F04EADFE41C6853B98278DF94125C7C68E5CC664C080A1739F995A38400CC15E59C2F3F9C1C02D33A600A6D341C2EA21E7979F63C0E0F42516842D15C074B1CC60F7E2FAC1B8619E2DC7FFFC41':::GEOGRAPHY
        														AS col_1258829
        												FROM
        													defaultdb.public.table_5@"table_5_col5_3_
col5_0_col5_12_col""5_1_col5_2_col5_13_co%ql5_4_idx"
        														AS "tab%q_527327"
        												WHERE
        													false
        												ORDER BY
        													"tab%q_527327".col5_5 NULLS LAST, "tab%q_527327"."co%ql5_4"
        												LIMIT
        													1:::INT8
        											)
        										),
        										(
        											'01030000E0E61000000100000005000000F8A52B0005F03EC0C9F965C4CD5F42C040279C74973BC84134A0DD83E081FF4100E079FE67B520C0E09E272FCF400AC0D05CCACE2246CFC1FDE307597492F3C1F4533B20769A584080309DE59784E23F36FD783C64BEEDC18116BBB949E0F7C1DF8C241593B35BC014CFF2057EB04F4038349AA88F3E0242603F1C0955CADCC1F8A52B0005F03EC0C9F965C4CD5F42C040279C74973BC84134A0DD83E081FF41':::GEOGRAPHY
        										),
        										(st_geographyfromtext(e'PW$\x1ba':::STRING::STRING)::GEOGRAPHY)
        								)
        									AS tab_527328 ("co%vl _1258830")
        						UNION ALL
        							SELECT
        								*
        							FROM
        								(
        									VALUES
        										(
        											'01020000E0E61000000600000000F6B24CA20CF23F704D2A85EB9B26C0C82005658956E541EC4763CCE902F44168EE9ED3E85D3E40E775DEB95A0155C090B5685E7AC7FFC11EAD655D8A41F24142192CE36313634066F2B484425F5340FCCD7B5E758AE94192E71CF0B032F3416420CBCDA9C75E40F03A77C9E8F65340E685D12F87EBEBC1B009AAFF07A2FC41F4DDB42E02814A40F08B10519BF84740288D4074C533D7411C2E38F830BEF54118EFB9E4D10E3F40DC23256198AC51409CC23E24765FEFC1546A91135999FBC1':::GEOGRAPHY
        										),
        										(
        											'01040000A0E6100000050000000101000080B0DB836B205C2240EC8F2E5102273440C0897CD923EEF2410101000080B0B50C64B3B6304096AFC1650C07554068F78BE75845FA410101000080BB0E6D7B811560C0C09F1C10A9AC53408AD7F047A64AFA41010100008070F9D75B858264C0207EF4F79A332AC02A071A4C0D24FA41010100008046D5F09F50E864C07037BE289D6E4A4074F2CD04655EE4C1':::GEOGRAPHY
        										),
        										(
        											'0103000060E6100000010000000B0000005E5DABA0067A57C036871FDAB8DC4DC0BCDE9F0DD526E141AABC48E0451A52400665AFD5108840C086843EF27CE2F041A8B1A9E1804D404040EE1B9DE754F63F04B76F25594EF341FC8512480C4C5A403ED84F07007347C0685F64A5CFF0D441E88641B810616640B7617E1220B845C0A043CCAEF2B9D4C1680092A9587D5340087C747DD0B42B40AC58432CE624F7C1500DDB0E4E8C65402871BB73D686524090D8D7D2DF36CEC1184F1CDEE90D5140C4D31A040BA34740ACA45D6473C0F1C1CB2F79AD2ADE63C09495B35944F3464038F5CD201E33ECC13C9B032DC5C663C0A290F574A666424098771B548AFED2415E5DABA0067A57C036871FDAB8DC4DC0BCDE9F0DD526E141':::GEOGRAPHY
        										),
        										(
        											st_s2covering('01010000E0E6100000000000000000F87F000000000000F87F000000000000F87F000000000000F87F':::GEOGRAPHY::GEOGRAPHY, postgis_version()::STRING::STRING)::GEOGRAPHY
        										),
        										(
        											'01030000E0E61000000100000007000000DAEE07AA9D895AC052F5368309D654C01C3436DD6A0FD7C1B6BD1E6CA72DE2C1DCBC2F7141334A4056476003AFFD52C0CED508851173E7C1D768E808A9A9F4C14AA196AD7DC150405A59860B9EBE50C0AC5E5F9D9DA6E441A0D73D513D05F641464249947C306240B8353FEAA7354AC0387823B87D9DFE4122033EE5D999FDC138F73A55068254404073ADB5C44D49400AB4B88953F8F841A659EC5260F2ECC1A631B8C9152152C0E4A7F94A135F424012FAFDFCECA0F1417AEC9707AFF90142DAEE07AA9D895AC052F5368309D654C01C3436DD6A0FD7C1B6BD1E6CA72DE2C1':::GEOGRAPHY
        										)
        								)
        									AS tab_527329 (" col_1258831")
        					)
        			SELECT
        				tab😩_527324._bytes::BYTES AS "c ol_1258832"
        			FROM
        				"w%a7i th_213493" AS cte_ref_61627
        			WHERE
        				_st_coveredby(cte_ref_61627.col_1258827::GEOGRAPHY, '01010000A0E6100000000000000000F87F000000000000F87F000000000000F87F':::GEOGRAPHY::GEOGRAPHY)::BOOL
        			LIMIT
        				28:::INT8
        		)

Schema:

    rsg_test.go:765: To reproduce, use schema:
    rsg_test.go:767: SET sql_safe_updates = false;;
    rsg_test.go:767: SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;;
    rsg_test.go:767: SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;;
    rsg_test.go:767: CREATE TABLE table_1 ("col
1_0" PG_LSN, c😳ol1_1 INT4 NOT NULL, col1_2 TIMESTAMP NOT NULL, "
col!1_3" BPCHAR NOT NULL, "
        co%pl1_4" BIT(15) NOT NULL, col1_5 PG_LSN NOT NULL, col1_6 TSVECTOR NOT NULL, col1_7 STRING COLLATE en_US NULL, c͊ol1_8 STRING COLLATE de_DE NOT NULL, col1_9 TIMESTAMPTZ NOT NULL, "co{l1_10" BPCHAR NOT NULL, col1_11 BPCHAR NULL, col1_12 TIMETZ NOT NULL, col1_13 INT2 NOT NULL, "co 
        l1_14" INT8 NOT NULL AS (c😳ol1_1 + col1_13) VIRTUAL, col1_15 INT8 NOT NULL AS (c😳ol1_1 + col1_13) VIRTUAL, "co%ecl1_16" INT8 NOT NULL AS (col1_13 + c😳ol1_1) STORED, "cŏl1%v_17" STRING NOT NULL AS (lower("co{l1_10")) VIRTUAL, c̝ol1_18 INT8 NOT NULL AS (col1_13 + c😳ol1_1) STORED, PRIMARY KEY (col1_13), UNIQUE (col1_5 DESC, c̝ol1_18 DESC) STORING (c😳ol1_1, col1_2, "
col!1_3", col1_7, "co{l1_10"), INDEX (col1_7 ASC) PARTITION BY LIST (col1_7) (PARTITION table_1_part_0 VALUES IN ((e'\U0003B232\U000A25B6\U000C4FAE\U00009BED\U000CE500\U0003EAEB\U00099071' COLLATE en_US,), (e'\U0005DBD3\U000692AC' COLLATE en_US,), (e'\U0005E81B\U000488F0' COLLATE en_US,), (e'\U0003051D\U000C7515\U000DE491\U000CD7EE\U000ED8C7\U0002F44F' COLLATE en_US,), (e'\U0004FAEA' COLLATE en_US,), (e'\U000525C2' COLLATE en_US,)), PARTITION "table_1%v_part_1" VALUES IN ((e'\U0007DF05\U0009DBDA\U00074F23\U000CDCF9\U00070CBD\U00050679' COLLATE en_US,), (e'\U0000D155' COLLATE en_US,), (e'\U0007EF1B\U0009B530\U000890C6\U000E7069\U000014F6\U000B94BF' COLLATE en_US,), (e'\U00050A18\U000684A9\U000C0C45\U0007A230' COLLATE en_US,), (e'\U000A83A5\U00029B00\U0007BCB3\U00068C6A\U0009D9FA\U0009B3EB\U00064E18' COLLATE en_US,), (e'\U000E323F\U0006A560\U00006475\U000436B4\U00070E40\U000DA589\U00028314\U00006849' COLLATE en_US,)), PARTITION table_1_part_2 VALUES IN ((e'\U0007261E\U00032021\U000A80BC\U000BD203\U000BEE7B\U000C4614\U0003FC27\U000A2772' COLLATE en_US,), (e'\U0001F821' COLLATE en_US,), (e'\U000879B8\U000555A5\U000CDDE2\U0001063A\U0000608E\U0009BCA4' COLLATE en_US,), (e'\U0009FB97\U000253F1\U00019CC1' COLLATE en_US,), (e'\U000CBE15\U00030C31\U00063F5D\U0008AF2F\U0006073E\U000D53FE\U00056BB3\U000DBBB0\U000781EB' COLLATE en_US,), ('' COLLATE en_US,)), PARTITION " table_1_part_3" VALUES IN ((e'\U0009FDE2\U000CDB81\U000B6DE4\U000B16B6\U00043792\U00025FF8\u04BC\U0009761E\U000C510D' COLLATE en_US,), (e'\U00078D86' COLLATE en_US,), (e'\U0007D3AF\U00059D02\U0004AEE3\U000BB61D\U0005C049' COLLATE en_US,), (e'\U00036291\U000DC128\U0002B72A\U00001ABF\U0007E8CC\U000B4A54\U0008CB4E\U000DC1A0\U00010099' COLLATE en_US,), (e'\U00073362\U000087DB\U0003941F\U00034D4A\U0004A204\U00066FE0' COLLATE en_US,)), PARTITION "tabl e_1_part_4" VALUES IN ((e'\U000D95CC\U000C21F6\U000EF520\U00027AD5\U000257A6' COLLATE en_US,), (e'\U00070437\U0007B14C\U000B356B\U0003BF00' COLLATE en_US,), (e'\U000A7311\U0007B9B7\U000B96FB\U0000ADB2\U000B29D4\U000E9EF5\U0001B285\U000DF731\U00017F31' COLLATE en_US,), (e'\U000EE5BF\U0009A87C\U0000CA11\U00091B54' COLLATE en_US,), (e'\U0005860D\U000DCBF3\U0005772D\U0001CFDF' COLLATE en_US,), (e'\U000AE0DE' COLLATE en_US,)), PARTITION "t-able_1_part_5" VALUES IN ((e'\U000B79F8\U000E5A9A' COLLATE en_US,), (e'\U0001F320' COLLATE en_US,), (e'\U00069739\U00059661' COLLATE en_US,), (e'\U000267A0\U00094588\U000D98A0\U000588EB\U000177E5\U000C6DA9' COLLATE en_US,)), PARTITION table_1_part_6 VALUES IN ((e'\U00063AC6\U0005E7E1\U00081753' COLLATE en_US,), (e'\U0003AACF\U0002171E\U0009E1E7\U000ACFEF\U000B2B44\U00002CBA\U0004932C' COLLATE en_US,), (e'\U000D45AB\U0001CCD2\U000349B8\U0002D619\U0001DA0A\U00083409' COLLATE en_US,), (e'\U000CF51C' COLLATE en_US,), (e'\U000852AC\U000C0A0D\U000AB176\U000E6221\U00072856' COLLATE en_US,), (e'\U000E907C\U0002B2A0\U000A104A\U00028DD7\U00059623\U000D8E42\U00015FB6\U000E641C' COLLATE en_US,)), PARTITION "ta\\u8640ble_1_part_7" VALUES IN ((e'\U00092C13\U00079DD8\U0005ED4A\U00028B0A\U0000229F\U0002C7DB\U000CFBAD\U000C8F83' COLLATE en_US,), (e'\U0002BE65\U0001DB37\U0002606C\U00047F94\U00077837' COLLATE en_US,), (e'\U0000B32A\U000BF2E0\U000C2D71\U0005FDDD' COLLATE en_US,), (e'\U000AB0BB\U00004CCE\U0006C993\U0005BEE4\U00099B62\U000A2121' COLLATE en_US,), (e'\U0005DBF0\U00032D9A\U000272B5\U000DD7FA' COLLATE en_US,), (e'\U000EFE76\U0004CCBF\U000997A6\U0006992E\U0003C3F7' COLLATE en_US,)), PARTITION table_1_part_8 VALUES IN ((e'\U000DFAEB\U0008FCD9\U0009AA3B\U00061623\U000204B5\U00025128\U000BAAB9\U000BDD75' COLLATE en_US,), (e'\U00088AFF' COLLATE en_US,), (e'\U0009ED15\U000C3C42\U000464CA' COLLATE en_US,), (e'\U000B5749\U000E67CE\U000BBEC8\U000CE954\U000B37A0\U000E19CD\U0001F9D4' COLLATE en_US,), (e'\U000086A4\U0002B8A8\U000E5DC1' COLLATE en_US,), (e'\U000929AA\U000D1F26\U0004A500\U0003C570\U00031996\U00096485\U0009677B\U0002329C\U00092812' COLLATE en_US,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))), INDEX (c😳ol1_1 DESC) STORING ("
        co%pl1_4", col1_5, col1_7, col1_9, "co{l1_10", c̝ol1_18) PARTITION BY LIST (c😳ol1_1) (PARTITION "table_1_'pa'rt_0" VALUES IN ((926473712:::INT8,))), INDEX ("
col!1_3" ASC) WHERE ((((((table_1."cŏl1%v_17" >= '':::STRING) OR (table_1.col1_15 = (-128):::INT8)) OR (table_1.c😳ol1_1 != (-128):::INT8)) OR (table_1.col1_13 != (-128):::INT8)) AND (table_1."co{l1_10" < '"':::STRING)) AND (table_1."co%ecl1_16" > 32767:::INT8)) OR (table_1.c̝ol1_18 != 2147483647:::INT8), INVERTED INDEX (col1_6 ASC) VISIBILITY 0.45);
    rsg_test.go:767: CREATE TABLE table_2 ("c ol2_0" REGROLE NULL, " col2_1" TIME NOT NULL, col2_2 BIT(49), "co l2_3" TSVECTOR NOT NULL, col2_4 REGCLASS, col😴2_5 STRING AS (CASE WHEN col2_4 IS NULL THEN e':23\x19\x0bX\x18':::STRING ELSE '_':::STRING END) VIRTUAL, col2_6 STRING NOT NULL AS (lower(CAST("co l2_3" AS STRING))) STORED, "cOl2	_7" STRING NULL AS (CASE WHEN "c ol2_0" IS NULL THEN e'u[s\x06D':::STRING ELSE '[5bL{1#}':::STRING END) VIRTUAL, co😏l2_8 STRING NULL AS (CASE WHEN "c ol2_0" IS NULL THEN 'n2':::STRING ELSE e'XcS\x17':::STRING END) VIRTUAL, INDEX (col2_4 ASC), UNIQUE ((CASE WHEN "c ol2_0" IS NULL THEN e'i;8:T\x17+\x12(':::STRING ELSE '':::STRING END) ASC, "c ol2_0", col2_2 DESC) WHERE ((((table_2." col2_1" = '24:00:00':::TIME) AND (table_2.co😏l2_8 < e'\U00002603':::STRING)) OR (table_2."cOl2	_7" < e'\'':::STRING)) AND (table_2.col😴2_5 > e'\x00':::STRING)) AND (table_2.col2_6 = '':::STRING), UNIQUE (co😏l2_8 DESC, "cOl2	_7") WHERE ((table_2." col2_1" = '24:00:00':::TIME) OR (table_2."cOl2	_7" < e'\x00':::STRING)) AND (table_2.co😏l2_8 >= e'\U00002603':::STRING), INDEX ("c ol2_0") STORING (" col2_1", col2_4, col2_6) WHERE ((((table_2.col2_6 > e'\U00002603':::STRING) OR (table_2.co😏l2_8 != '"':::STRING)) AND (table_2." col2_1" = '24:00:00':::TIME)) OR (table_2.col😴2_5 < '"':::STRING)) AND (table_2."cOl2	_7" > '"':::STRING) NOT VISIBLE, FAMILY (col2_4), FAMILY ("co l2_3"), FAMILY (" col2_1"), FAMILY (col2_2), FAMILY (col2_6, "c ol2_0"));
    rsg_test.go:767: CREATE TABLE "?tabl e_3" (col3_0 BPCHAR, 😙col3_1 PG_LSN NOT NULL, col3_2 TSVECTOR NOT NULL, col3_3 DATE NOT NULL, "cOl3_4" "char" NOT NULL, col3_5 UUID NOT NULL, "c😎oL3_6" UUID, "c}ol3_7" BIT NOT NULL, col3_8 TIMETZ NOT NULL, "c\\xe7ol3_9" INT8 NOT NULL, ".col3_10" GEOGRAPHY NULL, "co
L3_11" STRING NULL AS (lower(CAST(".col3_10" AS STRING))) VIRTUAL, UNIQUE (col3_3 ASC) STORING (col3_0, 😙col3_1, "cOl3_4", "c}ol3_7", col3_8, "c\\xe7ol3_9", ".col3_10") PARTITION BY LIST (col3_3) (PARTITION "?tabl e_3_part_0" VALUES IN (('1972-09-30':::DATE,)), PARTITION "?tabl %05e_3_part_1" VALUES IN (('1971-01-26':::DATE,)), PARTITION "?tabl e_3_part_2" VALUES IN (('1984-09-06':::DATE,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE ((((("?tabl e_3".col3_0 != e'\x00':::STRING) AND ("?tabl e_3".col3_3 <= 'infinity':::DATE)) OR ("?tabl e_3"."co
L3_11" < 'X':::STRING)) AND ("?tabl e_3"."cOl3_4" != e'\U00002603':::STRING)) AND ("?tabl e_3"."c\\xe7ol3_9" = 32767:::INT8)) AND ("?tabl e_3".col3_8 > '00:00:00+15:59':::TIMETZ), INDEX (abs("c\\xe7ol3_9") DESC) STORING (😙col3_1, col3_2, col3_5, ".col3_10"));
    rsg_test.go:767: CREATE TABLE """table_4" (col4_0 INTERVAL NOT NULL, """col4_1" DATE NOT NULL, "col4'_2" REGCLASS NOT NULL, col4_3 INT2 NOT NULL, col4_4 INTERVAL NOT NULL, col4_5 STRING COLLATE de_DE NULL, col4_6 TSQUERY, "\fcol̬4_7" STRING NULL AS (lower(CAST(col4_5 AS STRING))) VIRTUAL, col4_8 STRING NOT NULL AS (CASE WHEN col4_0 IS NULL THEN e'4\t\x1a)':::STRING ELSE e'\x07q':::STRING END) STORED, "cOl4_9" STRING NOT NULL AS (CASE WHEN col4_0 IS NULL THEN e'p-UYIZ\x14Y':::STRING ELSE '``T':::STRING END) VIRTUAL, col4_10 STRING NULL AS (lower(CAST(col4_5 AS STRING))) VIRTUAL, PRIMARY KEY ("col4'_2" DESC), INDEX (col4_5, col4_3 DESC));
    rsg_test.go:767: CREATE TABLE table_5 ("
col5_0" BIT(27) NOT NULL, "col""5_1" DECIMAL NOT NULL, col5_2 REGROLE, col5_3 BOOL NOT NULL, "co%ql5_4" JSONB, col5_5 DECIMAL NULL, "col5{_6" STRING NOT NULL, col5_7 REFCURSOR NOT NULL, col5_8 GEOMETRY NOT NULL, col5_9 DATE, col5_10 TIMETZ, col5_11 "char" NOT NULL, col5_12 TIME NOT NULL, col5_13 REGTYPE NULL, PRIMARY KEY (col5_3 DESC, "
col5_0" ASC), UNIQUE (abs("col""5_1"), col5_5 DESC) WHERE (((((((table_5.col5_9 < '4714-11-24 BC':::DATE) AND table_5.col5_3) OR (table_5."col""5_1" <= 0:::DECIMAL)) AND (table_5."col5{_6" > '':::STRING)) OR (table_5.col5_11 <= e'\x00':::STRING)) OR (table_5.col5_10 >= '00:00:00+15:59':::TIMETZ)) AND (table_5.col5_5 >= 1:::DECIMAL)) AND (table_5.col5_12 != '24:00:00':::TIME), INDEX (col5_12 ASC) STORING (col5_2, col5_7, col5_8, col5_9, col5_10) WHERE (((((table_5.col5_9 >= 'infinity':::DATE) AND (table_5.col5_12 != '24:00:00':::TIME)) OR (table_5."col5{_6" > e'\U00002603':::STRING)) AND table_5.col5_3) OR (table_5.col5_10 <= '00:00:00+15:59':::TIMETZ)) AND (table_5."col""5_1" < 0:::DECIMAL), INDEX (col5_3, "
col5_0" DESC, col5_12 ASC, "col""5_1", col5_2, col5_13 ASC, "co%ql5_4") WHERE ((table_5."col""5_1" > 'NaN':::DECIMAL) AND (table_5.col5_5 >= '-Infinity':::DECIMAL)) AND table_5.col5_3, FAMILY ("
col5_0", col5_9, col5_11), FAMILY ("co%ql5_4", col5_3, "col""5_1", col5_5, col5_13), FAMILY (col5_8), FAMILY (col5_2), FAMILY (col5_12), FAMILY (col5_10, col5_7), FAMILY ("col5{_6"), UNIQUE (col5_12, "
col5_0"));
    rsg_test.go:767: ALTER TABLE table_1 INJECT STATISTICS e'[{"avg_size": 22, "columns": ["\\"\\nco%pl1_4\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 47, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 14, "columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 25, "histo_buckets": [{"distinct_range": 0, "num_eq": 842079974613277082, "num_range": 0, "upper_bound": "\\\\x126f0001"}, {"distinct_range": 549.949299177074, "num_eq": 600, "num_range": 800, "upper_bound": "\\\\x12780001"}, {"distinct_range": 0, "num_eq": 3534937100702363930, "num_range": 600000, "upper_bound": "\\\\x1241450001"}, {"distinct_range": 16.76028029178816, "num_eq": 4531885971842052010, "num_range": 20, "upper_bound": "\\\\x1248430001"}, {"distinct_range": 1158249486249012700, "num_eq": 50000000000, "num_range": 2050162414874853155, "upper_bound": "\\\\x1257560001"}, {"distinct_range": 843948802332710700, "num_eq": 700000000, "num_range": 7310039130726711533, "upper_bound": "\\\\x1262630001"}, {"distinct_range": 6563894674286924000, "num_eq": 1225735639989053407, "num_range": 7700026669452990882, "upper_bound": "\\\\x1243557a0001"}, {"distinct_range": 0, "num_eq": 50000000, "num_range": 500000, "upper_bound": "\\\\x124c726e0001"}, {"distinct_range": 0, "num_eq": 7131043072712294830, "num_range": 8866549659610845334, "upper_bound": "\\\\x126276490001"}, {"distinct_range": 50, "num_eq": 5750741432379296446, "num_range": 50, "upper_bound": "\\\\x1265624b0001"}, {"distinct_range": 580.2849108351114, "num_eq": 50000, "num_range": 800, "upper_bound": "\\\\x126a76550001"}, {"distinct_range": 2137127566.2502959, "num_eq": 7000000, "num_range": 5000000000, "upper_bound": "\\\\x126b6e710001"}, {"distinct_range": 220996331958245900, "num_eq": 8812817513389523052, "num_range": 220996331958245891, "upper_bound": "\\\\x12585852730001"}, {"distinct_range": 0, "num_eq": 4866193407580240170, "num_range": 10, "upper_bound": "\\\\x125a4744470001"}, {"distinct_range": 100000, "num_eq": 5000, "num_range": 100000, "upper_bound": "\\\\x125a6e52630001"}, {"distinct_range": 200000, "num_eq": 6000000000, "num_range": 200000, "upper_bound": "\\\\x126270634a0001"}, {"distinct_range": 0, "num_eq": 600000, "num_range": 5000000000, "upper_bound": "\\\\x126373526b0001"}, {"distinct_range": 1000000000, "num_eq": 80, "num_range": 1000000000, "upper_bound": "\\\\x126c75446c0001"}, {"distinct_range": 4700173836424976000, "num_eq": 489350356236267637, "num_range": 4700173836424976554, "upper_bound": "\\\\x12714855710001"}, {"distinct_range": 0, "num_eq": 7626129782667319478, "num_range": 0, "upper_bound": "\\\\x12756466750001"}, {"distinct_range": 3133509848218449000, "num_eq": 30000, "num_range": 8536936525305471083, "upper_bound": "\\\\x12795955680001"}, {"distinct_range": 4193945965416545300, "num_eq": 20000000, "num_range": 4846998684163415091, "upper_bound": "\\\\x1249467841540001"}, {"distinct_range": 0, "num_eq": 6000000000, "num_range": 10000, "upper_bound": "\\\\x1264475568700001"}, {"distinct_range": 5197340572531149000, "num_eq": 1174157621506296647, "num_range": 7335426880033753115, "upper_bound": "\\\\x126d6155486e6e0001"}, {"distinct_range": 573794326486476500, "num_eq": 7668134031323401813, "num_range": 573794326486476453, "upper_bound": "\\\\x12716c6e446f470001"}, {"distinct_range": 0, "num_eq": 3407791490344682736, "num_range": 2359318393543887709, "upper_bound": "\\\\x12747577627a660001"}, {"distinct_range": 0, "num_eq": 1936738373052283116, "num_range": 3343551177871946736, "upper_bound": "\\\\x12765570576e650001"}, {"distinct_range": 1429391181422726100, "num_eq": 60000000000, "num_range": 1429391181422726034, "upper_bound": "\\\\x12495a547341437a0001"}, {"distinct_range": 0, "num_eq": 30, "num_range": 8568774642767851441, "upper_bound": "\\\\x124a53724a6b76560001"}, {"distinct_range": 361031076994626000, "num_eq": 80000000000, "num_range": 1157340467855090733, "upper_bound": "\\\\x1261647a76706c4d0001"}, {"distinct_range": 56340968401.138725, "num_eq": 6498251524804013070, "num_range": 70000000000, "upper_bound": "\\\\x126558584e49456c0001"}, {"distinct_range": 83309167835.61845, "num_eq": 10000000, "num_range": 100000000000, "upper_bound": "\\\\x12684c77537554540001"}, {"distinct_range": 1000000000, "num_eq": 8589705132079414542, "num_range": 1000000000, "upper_bound": "\\\\x127258586f6b745a0001"}, {"distinct_range": 0, "num_eq": 6000000, "num_range": 4756418511876794922, "upper_bound": "\\\\x12726958594561720001"}, {"distinct_range": 6000, "num_eq": 2662349427506685401, "num_range": 6000, "upper_bound": "\\\\x127768644d5262660001"}, {"distinct_range": 9000, "num_eq": 70, "num_range": 9000, "upper_bound": "\\\\x12545264576173746c0001"}, {"distinct_range": 7000, "num_eq": 5140787571760635676, "num_range": 7000, "upper_bound": "\\\\x126248504c414f68790001"}, {"distinct_range": 0, "num_eq": 4220469688424461614, "num_range": 20000, "upper_bound": "\\\\x126c5871746f4e416f0001"}, {"distinct_range": 1582371386883984000, "num_eq": 800000000, "num_range": 7523568211969885785, "upper_bound": "\\\\x12786b65536848566c0001"}, {"distinct_range": 1241.7647389181639, "num_eq": 700000000, "num_range": 8000, "upper_bound": "\\\\x12457a7864704753794e0001"}, {"distinct_range": 0, "num_eq": 2999151932159602948, "num_range": 7430218394126850626, "upper_bound": "\\\\x1249426972505666755a0001"}, {"distinct_range": 21583.788683509225, "num_eq": 100000, "num_range": 1000000, "upper_bound": "\\\\x12474561446e6a754441540001"}, {"distinct_range": 0, "num_eq": 80000000000, "num_range": 0, "upper_bound": "\\\\x124b5148666c51646549500001"}, {"distinct_range": 38.48535731645168, "num_eq": 2037624031596893463, "num_range": 50, "upper_bound": "\\\\x12624d4a6f6e416374754b0001"}, {"distinct_range": 2308907231553130000, "num_eq": 8000, "num_range": 2308907231553130175, "upper_bound": "\\\\x126c7a6c74515576744f520001"}, {"distinct_range": 0, "num_eq": 4954801723393117496, "num_range": 4000000000, "upper_bound": "\\\\x126d665559614f7a4675760001"}], "histo_col_type": "BYTES", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 16, "columns": ["col1_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 35, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 24, "columns": ["c\u031Dol1_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 50, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 31, "columns": ["col1_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 36, "histo_buckets": [{"distinct_range": 0, "num_eq": 20000000000, "num_range": 0, "upper_bound": "-11141"}, {"distinct_range": 0, "num_eq": 3719328569325880784, "num_range": 2951532095777113891, "upper_bound": "-25096"}, {"distinct_range": 0, "num_eq": 2711250400002729746, "num_range": 9155870128171547567, "upper_bound": "-20810"}, {"distinct_range": 3140192881219564500, "num_eq": 0, "num_range": 3156823307777737763, "upper_bound": "-32211"}, {"distinct_range": 7349879716541922000, "num_eq": 1000000, "num_range": 7349879716541922212, "upper_bound": "3293"}, {"distinct_range": 0, "num_eq": 60000000, "num_range": 200000000, "upper_bound": "30558"}, {"distinct_range": 0, "num_eq": 1064503571968818258, "num_range": 0, "upper_bound": "-27617"}], "histo_col_type": "INT2", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 16, "columns": ["col1_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 50, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 15, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 79, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 19, "columns": ["\\"\\rcol!1_3\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 71, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 20, "columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 50, "histo_buckets": [{"distinct_range": 0, "num_eq": 20000000000, "num_range": 0, "upper_bound": "e\'\\\\U0006766B\' COLLATE en_US"}, {"distinct_range": 296886955544030100, "num_eq": 60000000000, "num_range": 296886955544030110, "upper_bound": "e\'\\\\U000D74A8\\\\U000AF195\\\\U00066C06\' COLLATE en_US"}, {"distinct_range": 62768.95510896835, "num_eq": 908829847484103422, "num_range": 70000, "upper_bound": "e\'\\\\U000DDC7E\\\\U000EEBD0\\\\U00055E96\' COLLATE en_US"}, {"distinct_range": 0, "num_eq": 2000000, "num_range": 0, "upper_bound": "e\'\\\\U000E1A41\\\\U000B7F96\\\\U0005C014\' COLLATE en_US"}, {"distinct_range": 2051016402756941800, "num_eq": 1503293373600577244, "num_range": 6968177967450092297, "upper_bound": "e\'\\\\U0009F171\\\\U0001BD11\\\\U0003F0B0\\\\U0005FEE2\\\\U000E0164\\\\U00036E4B\' COLLATE en_US"}, {"distinct_range": 43805552.90014074, "num_eq": 800, "num_range": 60000000, "upper_bound": "e\'\\\\U000AD68F\\\\U0008D285\\\\U0009F3B5\\\\U000DD993\\\\U000E6F0C\\\\U00044AF0\\\\U00030429\\\\U0005259B\' COLLATE en_US"}], "histo_col_type": "STRING COLLATE en_US", "histo_version": 3, "name": "__auto__", "null_count": 84, "row_count": 100}, {"avg_size": 5, "columns": ["c\u034Aol1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 84, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 5, "columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 29, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 27, "columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 15, "histo_col_type": "", "name": "__auto__", "null_count": 15, "row_count": 100}, {"avg_size": 0, "columns": ["\\"co%ecl1_16\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 17, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 30, "columns": ["c\U0001F633ol1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 97, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 0, "columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 86, "histo_buckets": [{"distinct_range": 0, "num_eq": 7567182170853590853, "num_range": 0, "upper_bound": "A5F24657/82C29EBD"}, {"distinct_range": 3261473310910589000, "num_eq": 5000000, "num_range": 3261473310910588815, "upper_bound": "3498A8E7/65C8A289"}, {"distinct_range": 0, "num_eq": 1887102711843344374, "num_range": 8000000000, "upper_bound": "34FBD383/532F1711"}, {"distinct_range": 0, "num_eq": 6000000, "num_range": 10000000, "upper_bound": "20C09141/A5743758"}, {"distinct_range": 50000, "num_eq": 9108965186682164413, "num_range": 50000, "upper_bound": "F4DE4316/42AC354D"}], "histo_col_type": "PG_LSN", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 29, "columns": ["\\"co{l1_10\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 69, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 28, "columns": ["\\"co \\nl1_14\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 63, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"avg_size": 6, "columns": ["\\"col\\r1_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 64, "histo_col_type": "", "name": "__auto__", "null_count": 94, "row_count": 100}, {"avg_size": 29, "columns": ["\\"c\u014Fl1%v_17\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 69, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}]':::JSONB;
    rsg_test.go:767: ALTER TABLE table_2 INJECT STATISTICS e'[{"avg_size": 15, "columns": ["\\"co l2_3\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3078272291348709558, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4141683934941317688}, {"avg_size": 6, "columns": ["col\U0001F6342_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 424882314489866630, "histo_col_type": "", "name": "__auto__", "null_count": 2226316473934121230, "row_count": 4141683934941317688}, {"avg_size": 16, "columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1918804066736561365, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4141683934941317688}, {"avg_size": 9, "columns": ["\\"c ol2_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 83820508071445085, "histo_buckets": [{"distinct_range": 0, "num_eq": 9006269505909690061, "num_range": 0, "upper_bound": "3009999105"}, {"distinct_range": 1885456387850930700, "num_eq": 3000, "num_range": 9190561406667552842, "upper_bound": "155517446"}], "histo_col_type": "REGROLE", "histo_version": 3, "name": "__auto__", "null_count": 3549320993536285054, "row_count": 4141683934941317688}, {"avg_size": 16, "columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 901323009488831771, "histo_col_type": "", "name": "__auto__", "null_count": 96174062114859885, "row_count": 4141683934941317688}, {"avg_size": 26, "columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2419096737532132501, "histo_buckets": [{"distinct_range": 0, "num_eq": 7255810428389853698, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 0, "num_eq": 0, "num_range": 9000000000, "upper_bound": "1428328016"}, {"distinct_range": 600, "num_eq": 400000, "num_range": 600, "upper_bound": "3294362390"}, {"distinct_range": 195.45650167750344, "num_eq": 10000, "num_range": 600, "upper_bound": "301903070"}, {"distinct_range": 1537239526423999500, "num_eq": 9000000000, "num_range": 1537239526423999459, "upper_bound": "3534499678"}, {"distinct_range": 0, "num_eq": 400000, "num_range": 20000, "upper_bound": "3559514848"}, {"distinct_range": 4849100231617772000, "num_eq": 3499273814076031337, "num_range": 5145180777136647075, "upper_bound": "2149268069"}, {"distinct_range": 5043250568635501000, "num_eq": 8655127860992980983, "num_range": 5043250568635500711, "upper_bound": "4081146687"}], "histo_col_type": "REGCLASS", "histo_version": 3, "name": "__auto__", "null_count": 867534151912524139, "row_count": 4141683934941317688}, {"avg_size": 18, "columns": ["\\"cOl2\\t_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3925580427335652207, "histo_col_type": "", "name": "__auto__", "null_count": 2143869207725035048, "row_count": 4141683934941317688}, {"avg_size": 12, "columns": ["co\U0001F60Fl2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1640802181803008913, "histo_col_type": "", "name": "__auto__", "null_count": 3721396849410738401, "row_count": 4141683934941317688}, {"avg_size": 29, "columns": ["\\" col2_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2250934370414621012, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 4141683934941317688}]':::JSONB;
    rsg_test.go:767: ALTER TABLE "?tabl e_3" INJECT STATISTICS e'[{"avg_size": 26, "columns": ["\\"cOl3_4\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 187746594, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 16, "columns": ["\\"c\U0001F60EoL3_6\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 413085445, "histo_col_type": "", "name": "__auto__", "null_count": 700787919, "row_count": 800000000}, {"avg_size": 16, "columns": ["col3_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 517141504, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 30, "columns": ["\\"c\\\\\\\\xe7ol3_9\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 709976794, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 26, "columns": ["\\".col3_10\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 521745201, "histo_col_type": "", "name": "__auto__", "null_count": 699713874, "row_count": 800000000}, {"avg_size": 9, "columns": ["\U0001F619col3_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 727131665, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 12, "columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 515072135, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 29, "columns": ["col3_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 73967895, "histo_buckets": [{"distinct_range": 0, "num_eq": 7161199565743917636, "num_range": 0, "upper_bound": "1975-01-31"}, {"distinct_range": 0, "num_eq": 8526090139412102459, "num_range": 5496816608634776899, "upper_bound": "1970-03-07"}, {"distinct_range": 0, "num_eq": 10000, "num_range": 0, "upper_bound": "1984-01-16"}, {"distinct_range": 0, "num_eq": 230251736843068596, "num_range": 10000000000, "upper_bound": "4714-11-24 BC"}, {"distinct_range": 0, "num_eq": 6415110278160511339, "num_range": 70000000, "upper_bound": "1977-05-30"}, {"distinct_range": 1000000, "num_eq": 50000000, "num_range": 1000000, "upper_bound": "5874897-12-31"}, {"distinct_range": 233.6287840719756, "num_eq": 6000, "num_range": 300, "upper_bound": "1980-06-13"}, {"distinct_range": 6835813146759840000, "num_eq": 1795958152857280821, "num_range": 7888678660126212523, "upper_bound": "1986-06-17"}, {"distinct_range": 700000000, "num_eq": 50000000, "num_range": 700000000, "upper_bound": "1991-07-20"}], "histo_col_type": "DATE", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 21, "columns": ["\\"co\\rL3_11\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 775642623, "histo_col_type": "", "name": "__auto__", "null_count": 92684916, "row_count": 800000000}, {"avg_size": 25, "columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 773762184, "histo_col_type": "", "name": "__auto__", "null_count": 40892155, "row_count": 800000000}, {"avg_size": 1, "columns": ["col3_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 653978199, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 28, "columns": ["\\"c}ol3_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 106743157, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}]':::JSONB;
    rsg_test.go:767: ALTER TABLE """table_4" INJECT STATISTICS e'[{"avg_size": 20, "columns": ["\\"cOl4_9\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7214795412577848176, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}, {"avg_size": 8, "columns": ["col4_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1367966987955720053, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}, {"avg_size": 9, "columns": ["col4_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6107092889583874912, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}, {"avg_size": 5, "columns": ["col4_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 961030135548674981, "histo_col_type": "", "name": "__auto__", "null_count": 2306448639204685883, "row_count": 7524923467665015306}, {"avg_size": 4, "columns": ["col4_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4175362649664671213, "histo_buckets": [{"distinct_range": 0, "num_eq": 6411991550927935982, "num_range": 0, "upper_bound": "e\'\\\\U0006B589\' COLLATE de_DE"}], "histo_col_type": "STRING COLLATE de_DE", "histo_version": 3, "name": "__auto__", "null_count": 7023398836172389360, "row_count": 7524923467665015306}, {"avg_size": 9, "columns": ["\\"\\\\fcol\u032C4_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6261493104243115925, "histo_col_type": "", "name": "__auto__", "null_count": 6409600387428213165, "row_count": 7524923467665015306}, {"avg_size": 28, "columns": ["col4_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5198780479676890089, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}, {"avg_size": 24, "columns": ["col4_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6888149602001096487, "histo_col_type": "", "name": "__auto__", "null_count": 6455983439790412753, "row_count": 7524923467665015306}, {"avg_size": 21, "columns": ["col4_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5862178527834750001, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}, {"avg_size": 12, "columns": ["\\"\\"\\"col4_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4848485668092087656, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}, {"avg_size": 26, "columns": ["\\"col4\'_2\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6310954065870963195, "histo_buckets": [{"distinct_range": 0, "num_eq": 669146741778546255, "num_range": 0, "upper_bound": "356425166"}], "histo_col_type": "REGCLASS", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 7524923467665015306}]':::JSONB;
    rsg_test.go:767: ALTER TABLE table_5 INJECT STATISTICS e'[{"avg_size": 5, "columns": ["col5_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 338256, "histo_col_type": "", "name": "__auto__", "null_count": 107802, "row_count": 600000}, {"avg_size": 3, "columns": ["col5_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 104102, "histo_col_type": "", "name": "__auto__", "null_count": 123814, "row_count": 600000}, {"avg_size": 14, "columns": ["col5_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 104673, "histo_col_type": "", "name": "__auto__", "null_count": 91656, "row_count": 600000}, {"avg_size": 7, "columns": ["\\"\\rcol5_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 560791, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 14, "columns": ["col5_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 153958, "histo_col_type": "", "name": "__auto__", "null_count": 435014, "row_count": 600000}, {"avg_size": 12, "columns": ["col5_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 335452, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 27, "columns": ["\\"col\\"\\"5_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1443, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 19, "columns": ["\\"co%ql5_4\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 31597, "histo_col_type": "", "name": "__auto__", "null_count": 383929, "row_count": 600000}, {"avg_size": 4, "columns": ["\\"col5{_6\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 571764, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 4, "columns": ["col5_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 492942, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 14, "columns": ["col5_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 474707, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 0, "columns": ["col5_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 133514, "histo_col_type": "", "name": "__auto__", "null_count": 228106, "row_count": 600000}, {"avg_size": 22, "columns": ["col5_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 187080, "histo_buckets": [{"distinct_range": 0, "num_eq": 7000000000, "num_range": 0, "upper_bound": "true"}, {"distinct_range": 0, "num_eq": 1000000, "num_range": 9000, "upper_bound": "false"}], "histo_col_type": "BOOL", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 600000}, {"avg_size": 21, "columns": ["col5_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 202307, "histo_buckets": [{"distinct_range": 0, "num_eq": 90, "num_range": 0, "upper_bound": "14:54:08.510738"}, {"distinct_range": 2422439453071336400, "num_eq": 5208613237132972599, "num_range": 2422439453071336695, "upper_bound": "19:07:34.518483"}, {"distinct_range": 4862972569975564000, "num_eq": 50000000000, "num_range": 7068715405157698767, "upper_bound": "03:06:55.959897"}, {"distinct_range": 3207366172.844625, "num_eq": 20000000, "num_range": 4000000000, "upper_bound": "01:01:34.503652"}, {"distinct_range": 4673349920681928000, "num_eq": 600000, "num_range": 5237876783202528869, "upper_bound": "18:54:16.867109"}, {"distinct_range": 6125933366492398000, "num_eq": 10, "num_range": 6125933366492397232, "upper_bound": "07:51:01.67492"}, {"distinct_range": 335359322889357950, "num_eq": 1817352763097579484, "num_range": 410565656456782013, "upper_bound": "13:45:36.837426"}], "histo_col_type": "TIME", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 600000}]':::JSONB;
    rsg_test.go:767: ALTER TABLE table_2 ADD FOREIGN KEY (" col2_1", col2_2) REFERENCES table_5 (col5_12, "
col5_0") ON DELETE RESTRICT ON UPDATE RESTRICT;
    rsg_test.go:767: CREATE TYPE rand_typ_0 AS ENUM ('k', 'ccbhb');
    rsg_test.go:767: CREATE TYPE rand_typ_1 AS ENUM ('zdwb', 'tctiuq', 'hdkyj', 'gespt', 'hngbt');
    rsg_test.go:767: SET sql_safe_updates = false;;
    rsg_test.go:767: 
        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:767: ALTER TABLE seed SPLIT AT VALUES (3431135574263052643);
    rsg_test.go:767: ALTER TABLE seed SPLIT AT VALUES (5989328690027846377);
    rsg_test.go:767: ALTER TABLE seed SPLIT AT VALUES (6182090931752229686);
    rsg_test.go:767: ALTER TABLE seed SPLIT AT VALUES (6397987439414538794);
    rsg_test.go:767: ALTER TABLE seed SCATTER;
    rsg_test.go:769: 
    rsg_test.go:770: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/d437d2c847dfedbc4972f231c3331c8e/logTestRandomSyntaxSQLSmith3932782963
--- FAIL: TestRandomSyntaxSQLSmith (301.24s)
Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!
@cockroach-teamcity cockroach-teamcity added C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) branch-release-24.1.15-rc labels Mar 18, 2025
@cockroach-teamcity cockroach-teamcity added this to the 24.1 milestone Mar 18, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-release-24.1.15-rc C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
24.1
Development

No branches or pull requests
1 participant
@cockroach-teamcity