cockroachdb / cockroachdb/cockroach

geo: VoronoiDiagram doesn't respect context cancellation

Open
#139,845 2 comments 0 reactions 0 assignees View on GitHub
A-geometry-builtins branch-master branch-release-21.1 branch-release-21.2 branch-release-22.1 branch-release-22.2 branch-release-23.1 branch-release-23.2 branch-release-24.1 branch-release-24.2 branch-release-24.3 branch-release-25.1 O-robot T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

sql/tests.TestRandomSyntaxSQLSmith [failed](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/18618811?buildTab=log) with [artifacts](https://teamcity.cockroachdb.com/buildConfiguration/Cockroach_Nightlies_RandomSyntaxTestsBazel/18618811?buildTab=artifacts#/) on release-24.3.4-rc @ [2e8d8e7f91b39e3e4148571f4495e5f0c9a4bd77](https://github.com/cockroachdb/cockroach/commits/2e8d8e7f91b39e3e4148571f4495e5f0c9a4bd77):

Random syntax error:

```
rsg_test.go:964: Crash detected: server panic: statement exec timeout
```
Query:

```
WITH
with_74561 ("c\\x20ol} _412854", co͇l_412855)
AS (
SELECT
*
FROM
(
VALUES
(NULL, hostmask('c29c:e634:5ae1:4a3c:dda6:dd17:ccae:6416/31':::INET::INET)::INET),
(NULL, '246.10.250.120/31':::INET),
('2490970B/71F02EF8':::PG_LSN, '0.0.0.0/0':::INET),
(
'5BAB1835/A76A434A':::PG_LSN,
(
WITH
"wit%q😭h_74557" (col_412845)
AS (
SELECT
*
FROM
(
VALUES
((-84.46625845357199002):::DECIMAL),
(8.721054236437390030E+36:::DECIMAL),
((-230364514.5841370775):::DECIMAL),
(6.160411327635506110E+27:::DECIMAL)
)
AS tab_183875 (col_412845)
),
"w'ith_74560" (😢c̰ol_412850, co͙l_412851, c̷ol_412852)
AS (
SELECT
*
FROM
(
VALUES
(
(-1.0):::FLOAT8,
NULL,
'''BHBSr'' ''FHDXzM'' ''OntloF'' ''RFBqXk'':540C,612C,738A ''lbCjLxT'' ''lnKxtYrcnc'':420C,533C,942A ''wFxm''':::TSVECTOR
),
(
0.30567375078232734:::FLOAT8,
NULL,
'''QeLJYUFHzy'' ''dcVNmt'' ''eqrH'':364A,600C,773A,972C ''wg'':330A ''xzQykBXCfT'' ''zfwhAcNmIh''':::TSVECTOR
),
(
(-0.7320622798072097):::FLOAT8,
'af53:1c3a:1da7:ef57:d4c8:4f65:8cb0:63f1/21':::INET,
'''AMuRMtoH'' ''DpjoJf'':415B,986A ''JubA'' ''PedPeYHGI'':58C,539A,898C,917A,991A ''geHnNxSUU'':877C ''hnKPE'':429B':::TSVECTOR
),
(
(-0.11390332696351896):::FLOAT8,
(
WITH
"with _74558" (col_412846)
AS (
SELECT
*
FROM
(
VALUES
(
st_voronoilines(st_pointfromtext((NULL::STRING || '83d17ad3-28cb-4c9e-8dd5-46aa62e58d75':::UUID::UUID)::STRING::STRING, 5978734347072637333:::INT8::INT8)::GEOMETRY::GEOMETRY, 1.0235128915526313:::FLOAT8::FLOAT8)::GEOMETRY
),
(
'0105000000020000000102000000030000003807F463D40E01C2000CD62065C4A5416B15B4CB43B5F1C1D6670B58FE83F0C128343D46D796D241640D25EE79DDF6C1010200000002000000D8EB2B518650DB411C9F70CEB9B6E44104BBEEC9BA58E64130B4220CDFEDED41':::GEOMETRY
),
(
'010100008080112362826AEE41865C4F6F519402C29C70F8CA2FACFA41':::GEOMETRY
),
(NULL),
(
st_voronoipolygons(st_minimumboundingcircle('01070000000300000001010000000000000000004440000000000000244001020000000300000000000000000024400000000000002440000000000000344000000000000034400000000000002440000000000000444001030000000100000004000000000000000000444000000000000044400000000000003440000000000080464000000000008046400000000000003E4000000000000044400000000000004440':::GEOMETRY::GEOMETRY, 32767:::INT8::INT8)::GEOMETRY::GEOMETRY, (-0.6992445977015473):::FLOAT8::FLOAT8, '01060000000500000001030000000100000005000000908E8A0A17CBF9C14C749089CC19EDC1F6EB5764860CF641B62D03A902C300C2FA82BD98AC6F01420662BBE7EAFAFEC15E480693CCDF0042C4A6B4D0FE12FE41908E8A0A17CBF9C14C749089CC19EDC101030000000100000009000000190D286BA5D9F2C18C48AF87CB7000C26665CB619F00F0417098DAB09783C541AA9DBCF3A5F10142202D0B2E64C5C9C1DAEC9D96FA96F041EC5ABD13F19CE5411452B4AC593AF5418854C09AD2F700420C69B4F722BFE94118B12BFF3C14FE4100585920A521D841006248A2F701F541CB0D770C26F0F0C19472461B71E2EE41190D286BA5D9F2C18C48AF87CB7000C201030000000100000008000000102F1ADCED53CAC1C0D4DADAF3F3D2C1F169B61269BD00C21642812D1C4BFBC104438FD7F131F2414B456D2B4817F4C19C717B075C12F8410002C2449E7EA5C1481C35E9CF78FA4188E079F5347FDE41A65BA77FD51EF9413EFDA743CEC6F74110F18D55E9B1EAC1F8AD525E9A8DEE41102F1ADCED53CAC1C0D4DADAF3F3D2C10103000000010000000A000000A6AC0DB7C99CE9C1FA0DF798AA7CF9C100A616D71C28F7412074D41473D801C268940BCBCF78EF41821778702748FAC116BDFB1E8B98F64174216A0D786CFCC104A53CE6634EFF4174A003E0A45600C264B5B1BE3B35FB413E1759D0BF1AFAC1BEA02DC5F48BE0C14C4BEDB88C7EED410B1F147AF86502C2AC33DE1D0514F54139A21C5D5E0301C2302B6E0CEB1DC9C1A6AC0DB7C99CE9C1FA0DF798AA7CF9C10103000000010000000D0000009822513D8DF5F7C1772FDA693E8002C2BC6376B5D19EE241618E5A0AEA60F1C10A5A10E72B1F01426A34A6A7D914FDC1CC2F1FC45EB1FB414CEAA2BAEFA0EAC1E041155FDBACFD41F0CB735B000EDAC1708BF46BB90CF541A0F2D6C826E5D0C1F244B1C7A20BF9410875FDA96188F44114A8E5FCE5C4DAC1A454061F6905FC4140FC52FAA2D0E6C1D0843323E72FE441813BD66E7B40FBC12406079EF37EEA41D334E539BE50FBC1FCD89D2C67C0E441BEF6F9907879E3C1705FC3A3C086CA419822513D8DF5F7C1772FDA693E8002C2':::GEOMETRY::GEOMETRY)::GEOMETRY
)
)
AS tab_183876 (col_412846)
),
wi😵th_74559 ("c}ol_412847")
AS (
SELECT
*
FROM
(
VALUES
(1747880949:::REGPROC),
(507172124:::REGPROC),
(2275344169:::REGPROC),
(
regproc(8509620759151385353:::INT8::INT8)::REGPROC
),
(2090499636:::REGPROC)
)
AS 😾tab_183877 ("c}ol_412847")
)
SELECT
'35c3:9013:17d4:ec05:3213:81e:8ffd:14d4/112':::INET
AS "%vc😔ol_412848"
FROM
defaultdb.public.table_2 AS "t ab_183878"
```
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: SET CLUSTER SETTING sql.stats.forecasts.enabled = false;;
rsg_test.go:767: CREATE TABLE table_1 (col1_0 INT2, col1_1 REFCURSOR NOT NULL, col1_2 STRING NOT NULL AS (lower(CAST(col1_1 AS STRING))) STORED, UNIQUE (col1_0 ASC) STORING (col1_1), INDEX (col1_0 ASC) PARTITION BY LIST (col1_0) (PARTITION table_1_p̏art_0 VALUES IN ((2615:::INT8,), ((-25591):::INT8,), ((-2387):::INT8,), ((-13785):::INT8,), ((-17565):::INT8,), ((-4812):::INT8,), (32767:::INT8,), ((-30121):::INT8,), (5222:::INT8,)), PARTITION "table_͜1
_part_1" VALUES IN (((-23375):::INT8,), ((-11806):::INT8,), (26194:::INT8,), (3990:::INT8,), (19099:::INT8,), (16653:::INT8,), ((-24633):::INT8,), (18062:::INT8,), ((-5574):::INT8,)), PARTITION "table_1_part'_2" VALUES IN (((-1734):::INT8,), ((-19545):::INT8,), (16478:::INT8,), (10192:::INT8,), (32259:::INT8,), (11165:::INT8,), (12248:::INT8,), ((-4492):::INT8,), ((-26034):::INT8,)), PARTITION "%vtable_1_part_3" VALUES IN ((10495:::INT8,), ((-23333):::INT8,), (11841:::INT8,), (28784:::INT8,), ((-29682):::INT8,), ((-25754):::INT8,), ((-2109):::INT8,), (22394:::INT8,)), PARTITION "t able_1_par̅t_4" VALUES IN ((2306:::INT8,), ((-22163):::INT8,), ((-6189):::INT8,), (15770:::INT8,), ((-6616):::INT8,), (15007:::INT8,), ((-26330):::INT8,), ((-15310):::INT8,), (9790:::INT8,)), PARTITION table_1_part_5 VALUES IN (((-1049):::INT8,), (0:::INT8,), ((-23269):::INT8,), ((-12921):::INT8,), ((-20399):::INT8,), ((-12711):::INT8,), ((-2516):::INT8,), (21071:::INT8,), ((-15550):::INT8,)), PARTITION table_1_part_6 VALUES IN ((31707:::INT8,), (15299:::INT8,), (6745:::INT8,), ((-23971):::INT8,), ((-10646):::INT8,), ((-19811):::INT8,), ((-28286):::INT8,), (7465:::INT8,), ((-25763):::INT8,)), PARTITION "ta bLe_1_part_7" VALUES IN ((17036:::INT8,), (27456:::INT8,), ((-26700):::INT8,), (30229:::INT8,), (22159:::INT8,), (7672:::INT8,), (1:::INT8,), (10002:::INT8,), ((-1757):::INT8,)), PARTITION "table_1_pa rt_8" VALUES IN (((-22577):::INT8,), ((-8794):::INT8,), (28080:::INT8,), (11031:::INT8,), (22306:::INT8,), (16728:::INT8,))), UNIQUE (abs(col1_0) ASC, col1_2) WHERE (table_1.col1_0 = 1:::INT8) AND (table_1.col1_2 < '"':::STRING));
rsg_test.go:767: CREATE TABLE table_2 ("�col2_0" REGROLE, col2_1 GEOGRAPHY NOT NULL, col2_2 BIT(41) NOT NULL, col2_3 BYTES NOT NULL, col2_4 INT4[] NOT NULL, col2_5 VECTOR NULL, c😘ol2_6 STRING NOT NULL AS (CASE WHEN col2_3 IS NULL THEN e'3C\x1eA\x1d\x14\tj':::STRING ELSE '^.+':::STRING END) STORED, "col2�_7" STRING NOT NULL AS (lower(CAST(col2_2 AS STRING))) VIRTUAL, "col2 _8" STRING NOT NULL AS (CASE WHEN col2_4 IS NULL THEN ':d!(.':::STRING ELSE e':j7Ll\x19n>':::STRING END) VIRTUAL, INVERTED INDEX (col2_1 ASC), UNIQUE (lower(CAST(col2_1 AS STRING))) STORING (col2_2, col2_3, col2_5, c😘ol2_6) WHERE ((table_2.c😘ol2_6 < e'\'':::STRING) AND (table_2."col2�_7" = 'X':::STRING)) AND (table_2."col2 _8" >= e'\U00002603':::STRING), INDEX (col2_4 DESC) STORING (col2_3, c😘ol2_6));
rsg_test.go:767: CREATE TABLE "%vtable_3" (col3_0 STRING NOT NULL, UNIQUE (col3_0) PARTITION BY LIST (col3_0) (PARTITION "%vt😜able_3_part_0" VALUES IN (('"':::STRING,)), PARTITION "%vta
ble_3_part_1" VALUES IN ((e'\x1brAL\x12 e'\'':::STRING, INVERTED INDEX (col3_0 gin_trgm_ops ASC) WHERE "%vtable_3".col3_0 > '"':::STRING, INDEX (col3_0 DESC) WHERE "%vtable_3".col3_0 != e'\x00':::STRING, UNIQUE (lower(col3_0) ASC));
rsg_test.go:767: CREATE TABLE table_4 ("co
l4_0" INT2 NOT NULL, "col4?_1" VARCHAR NOT NULL, col4_2 OID NULL, "co l
4_3" DECIMAL, col4_4 INT8 NOT NULL, "c%qol4_5" REGROLE, col4_6 DECIMAL AS (abs("co l
4_3")) STORED, PRIMARY KEY ("co
l4_0" ASC), INVERTED INDEX ("co
l4_0", col4_4 ASC, "col4?_1" gin_trgm_ops), INDEX ("col4?_1" ASC, col4_4 ASC, "c%qol4_5" DESC) WHERE ((table_4."col4?_1" = e'\'':::STRING) AND (table_4."co l
4_3" > 'Infinity':::DECIMAL)) AND (table_4.col4_6 = 1.0:::DECIMAL), INDEX (col4_4 ASC, "co
l4_0" DESC), INDEX (col4_6) STORING ("col4?_1", col4_4, "c%qol4_5") PARTITION BY LIST (col4_6) (PARTITION table_4_part_0 VALUES IN (((-5287895.281541877309):::DECIMAL,)), PARTITION "table_4̊_p%art_1" VALUES IN ((5.041420324550940981E+33:::DECIMAL,)), PARTITION "table_4_%ppart _2" VALUES IN (((-2753206392835052797):::DECIMAL,))) WHERE table_4.col4_4 != (-9223372036854775807):::INT8, UNIQUE ("co l
4_3" ASC, col4_6 ASC, "col4?_1", "c%qol4_5" ASC, col4_4, col4_2 ASC, "co
l4_0" DESC) WHERE (table_4.col4_6 <= 0:::DECIMAL) OR (table_4."col4?_1" <= e'\'':::STRING), INDEX ("c%qol4_5" DESC) STORING (col4_2) WHERE ((table_4."co l
4_3" >= 'Infinity':::DECIMAL) AND (table_4.col4_6 = (-1):::DECIMAL)) OR (table_4."col4?_1" >= '':::STRING), INVERTED INDEX ("co l
4_3" DESC, "col4?_1" gin_trgm_ops) PARTITION BY LIST ("co l
4_3") (PARTITION "\\uEA95table_4_part_0" VALUES IN (((-3.169609731829369319E+24):::DECIMAL,), ((-0.08963613223706887072):::DECIMAL,), (2.40093935992991447E+29:::DECIMAL,), ((-6.446778390909164158E+30):::DECIMAL,), (6.907000159823849517E+31:::DECIMAL,), ((-1.234E+401):::DECIMAL,)), PARTITION table_4_part_1 VALUES IN ((4.271093995017184145E+31:::DECIMAL,), ((-0.04774428801366288995):::DECIMAL,), ((-27021818141460.20974):::DECIMAL,), (5.653977615578953973E+28:::DECIMAL,), ((-7.382341827423543595E+36):::DECIMAL,), (1.115259658252366250E+32:::DECIMAL,)), PARTITION table_4_part_2 VALUES IN (((-724519701.0692502275):::DECIMAL,), (4.159746792180325386E+28:::DECIMAL,), (7257891.690639141817:::DECIMAL,), (8.679905186185333734E+21:::DECIMAL,), (8.926925450104812114E+37:::DECIMAL,), ((-359980824842256064.3):::DECIMAL,)), PARTITION table_4_part_3 VALUES IN (((-1.0):::DECIMAL,), (5.950437992327947148E+24:::DECIMAL,), (31.71595174064437191:::DECIMAL,), (65553614.75798939652:::DECIMAL,), (600632185.2290048345:::DECIMAL,), ((-9.021630633183610739E+32):::DECIMAL,)), PARTITION "table_4_part""_4" VALUES IN (((-61416315897591506.6):::DECIMAL,), (916299606525368.8963:::DECIMAL,), (8.080957999241525754E+26:::DECIMAL,), ((-4.467463138393472987E+24):::DECIMAL,), ((-15043336948.44558929):::DECIMAL,), ((-1593431.593645971031):::DECIMAL,)), PARTITION table_4_part_5 VALUES IN ((548178477900.875994:::DECIMAL,), (3534619305614.650135:::DECIMAL,), (64.36014522748473835:::DECIMAL,), (7.153945883431612320E+21:::DECIMAL,), ((-44.74925601544825057):::DECIMAL,), ((-6.223371428377902899E+24):::DECIMAL,)), PARTITION "ta-ble_4_part_6" VALUES IN ((5.043388348973266335E+33:::DECIMAL,), (8.987230410400915880E+20:::DECIMAL,), (0.00626515558536621560:::DECIMAL,), (401317867.0683357899:::DECIMAL,), ((-1345498097557287.386):::DECIMAL,), ((-160667983265120.4091):::DECIMAL,)), PARTITION tàble_4_part_7 VALUES IN (((-8074102466.497762485):::DECIMAL,), (0:::DECIMAL,), ((-4.044693855286981076E+37):::DECIMAL,), (81773908179.15901817:::DECIMAL,), (1:::DECIMAL,), (6614581412775416.180:::DECIMAL,)), PARTITION "tab́le_4_par t_8" VALUES IN (((-7.008075170898533384E+22):::DECIMAL,), ((-1461932663205153.273):::DECIMAL,), ((-1622389478259056422):::DECIMAL,), (407.9701613494128973:::DECIMAL,), ((-15057227128.32976049):::DECIMAL,), (5.475628710209353168E+19:::DECIMAL,)), PARTITION "DEFAULT" VALUES IN ((DEFAULT,))) WHERE ((((table_4.col4_6 >= 'Infinity':::DECIMAL) OR (table_4.col4_4 = 127:::INT8)) OR (table_4."co l
4_3" != 'NaN':::DECIMAL)) AND (table_4."co
l4_0" <= (-1):::INT8)) AND (table_4."col4?_1" != e'\U00002603':::STRING), INDEX ((col4_4 + "co
l4_0") ASC) STORING ("col4?_1", col4_2, "co l
4_3", col4_4, "c%qol4_5"), UNIQUE (col4_2 DESC, "co l
4_3" DESC) STORING ("col4?_1", col4_6));
rsg_test.go:767: ALTER TABLE table_1 INJECT STATISTICS '[{"avg_size": 5, "columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 744760774, "histo_buckets": [{"distinct_range": 0, "num_eq": 70000000, "num_range": 0, "upper_bound": "-9733"}, {"distinct_range": 7000, "num_eq": 900000, "num_range": 7000, "upper_bound": "-25518"}, {"distinct_range": 0, "num_eq": 20000, "num_range": 9056157021447918462, "upper_bound": "-14768"}], "histo_col_type": "INT2", "histo_version": 3, "name": "__auto__", "null_count": 512592458, "row_count": 800000000}, {"avg_size": 17, "columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 471100185, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"avg_size": 25, "columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 629578130, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}]':::JSONB;
rsg_test.go:767: ALTER TABLE table_2 INJECT STATISTICS e'[{"avg_size": 14, "columns": ["\\"\\u000bcol2_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 898813462575788460, "histo_col_type": "", "name": "__auto__", "null_count": 3569338308493865194, "row_count": 8402528069327038626}, {"avg_size": 25, "columns": ["col2_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4673569989725397143, "histo_buckets": [{"distinct_range": 0, "num_eq": 8628043716806622975, "num_range": 0, "upper_bound": "\\\\x42fda3e095bdb6345db901c0019c0e15cf26f3bfef69cbb416f539"}, {"distinct_range": 66368822.83968103, "num_eq": 276895624292045816, "num_range": 70000000, "upper_bound": "\\\\x42fd100000000000000000bff1f625813ac8d2bff7c3b923811c6f3ff11ef24307dc67bfa56879ab96688a"}, {"distinct_range": 900, "num_eq": 900000000, "num_range": 900, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bfefa1615600b4ba400921fb54442d183ff7a760fdf29a77"}, {"distinct_range": 0, "num_eq": 500000000, "num_range": 1885063847073483732, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bff794d94e05dd78400921fb54442d183ff7e3aab0e1ae6a"}, {"distinct_range": 3045339053077392400, "num_eq": 7850865732532375892, "num_range": 3045339053077392626, "upper_bound": "\\\\x42fd100000000000000000c00921fb54442d18bff91496b7681896400921fb54442d183ff8e072cceaad48"}, {"distinct_range": 0, "num_eq": 10000000000, "num_range": 6000000000, "upper_bound": "\\\\x42fd14b000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 0, "num_eq": 888527273159781255, "num_range": 1000000000, "upper_bound": "\\\\x42fd240000000000000000bff1f625813ac8d2bff7c3b923811c6f3ff11ef24307dc67bfa56879ab96688a"}, {"distinct_range": 780.8966524082862, "num_eq": 8636832173420622854, "num_range": 1000, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bfefa1615600b4ba400921fb54442d183ff7a760fdf29a77"}, {"distinct_range": 0, "num_eq": 600000, "num_range": 6000000000, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff794d94e05dd78400921fb54442d183ff7e3aab0e1ae6a"}, {"distinct_range": 4346141152179861500, "num_eq": 5120904178393052991, "num_range": 4346141152179861523, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 800, "num_eq": 204474167433243865, "num_range": 800, "upper_bound": "\\\\x42fd300000000000000000c00921fb54442d18bff91496b7681896400921fb54442d183ff8e072cceaad48"}, {"distinct_range": 2426189925232649000, "num_eq": 10000, "num_range": 2426189925232649353, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bfefa1615600b4ba400921fb54442d183ff7a760fdf29a77"}, {"distinct_range": 0, "num_eq": 9000, "num_range": 20, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff794d94e05dd78400921fb54442d183ff7e3aab0e1ae6a"}, {"distinct_range": 1268490188326480400, "num_eq": 400, "num_range": 1404005384480824533, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 3943042455098372600, "num_eq": 7894561370694230479, "num_range": 7512458923187752470, "upper_bound": "\\\\x42fd500000000000000000c00921fb54442d18bff91496b7681896400921fb54442d183ff8e072cceaad48"}, {"distinct_range": 0, "num_eq": 2078797452920614066, "num_range": 40000000000, "upper_bound": "\\\\x42fd700000000000000000c00921fb54442d18bfefa1615600b4ba400921fb54442d183ff7a760fdf29a77"}, {"distinct_range": 5898193537553145000, "num_eq": 700000, "num_range": 9083347159677479564, "upper_bound": "\\\\x42fd700000000000000000c00921fb54442d18bff794d94e05dd78400921fb54442d183ff7e3aab0e1ae6a"}, {"distinct_range": 8611961616195559000, "num_eq": 1546831043249809149, "num_range": 8611961616195559604, "upper_bound": "\\\\x42fd700000000000000000c00921fb54442d18bff91496b7681896400921fb54442d183ff8e072cceaad48"}, {"distinct_range": 4000000000, "num_eq": 100000000, "num_range": 4000000000, "upper_bound": "\\\\x42fd8c0000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 7955449652658967000, "num_eq": 3700318310315932346, "num_range": 7955449652658966204, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bfefa1615600b4ba400921fb54442d183ff7a760fdf29a77"}, {"distinct_range": 0, "num_eq": 3220118456463328436, "num_range": 7961005496161322462, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bff794d94e05dd78400921fb54442d183ff7e3aab0e1ae6a"}, {"distinct_range": 3565908745929464300, "num_eq": 600000, "num_range": 3565908745929464524, "upper_bound": "\\\\x42fd900000000000000000c00921fb54442d18bff91496b7681896400921fb54442d183ff8e072cceaad48"}, {"distinct_range": 1000, "num_eq": 8886479389960998059, "num_range": 1000, "upper_bound": "\\\\x42fd940000000000000000bff1f625813ac8d2bff7c3b923811c6f3ff11ef24307dc67bfa56879ab96688a"}, {"distinct_range": 279.8106825194229, "num_eq": 700000, "num_range": 900, "upper_bound": "\\\\x42fd940000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 300000000, "num_eq": 945884531095095022, "num_range": 300000000, "upper_bound": "\\\\x42fd990000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 7040087939151124000, "num_eq": 70000000, "num_range": 7040087939151124454, "upper_bound": "\\\\x42fd9a4000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 90000000, "num_eq": 1872015014630684567, "num_range": 90000000, "upper_bound": "\\\\x42fdb00000000000000000bff1f625813ac8d2bff7c3b923811c6f3ff11ef24307dc67bfa56879ab96688a"}, {"distinct_range": 0, "num_eq": 5736501696686707899, "num_range": 5638753314172032949, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bfefa1615600b4ba400921fb54442d183ff7a760fdf29a77"}, {"distinct_range": 100000000000, "num_eq": 444936976035868295, "num_range": 100000000000, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff794d94e05dd78400921fb54442d183ff7e3aab0e1ae6a"}, {"distinct_range": 0, "num_eq": 4000000000, "num_range": 5000000, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff8f870a9d29545400921fb54442d183ff5809a6547ac70"}, {"distinct_range": 1029279228337898900, "num_eq": 20, "num_range": 1029279228337898870, "upper_bound": "\\\\x42fdb00000000000000000c00921fb54442d18bff91496b7681896400921fb54442d183ff8e072cceaad48"}], "histo_col_type": "BYTES", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}, {"avg_size": 16, "columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8352340571485382693, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}, {"avg_size": 17, "columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2323583783993309537, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}, {"avg_size": 16, "columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 454432422544792780, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}, {"avg_size": 3, "columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5882669837298672570, "histo_col_type": "", "name": "__auto__", "null_count": 8039329032785789009, "row_count": 8402528069327038626}, {"avg_size": 31, "columns": ["c\U0001F618ol2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1439346576879838354, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}, {"avg_size": 27, "columns": ["\\"col2\\u000b_7\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6497025561974938746, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}, {"avg_size": 3, "columns": ["\\"col2 _8\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 7145278472599298487, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 8402528069327038626}]':::JSONB;
rsg_test.go:767: ALTER TABLE "%vtable_3" INJECT STATISTICS e'[{"avg_size": 13, "columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8911275, "histo_buckets": [{"distinct_range": 0, "num_eq": 70000000, "num_range": 0, "upper_bound": "@hs"}, {"distinct_range": 6571318497869042000, "num_eq": 8628962424648074794, "num_range": 7735943824376905034, "upper_bound": "m2Ap;^\\u0015u"}], "histo_col_type": "STRING", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 9000000}]':::JSONB;
rsg_test.go:767: ALTER TABLE table_4 INJECT STATISTICS e'[{"avg_size": 5, "columns": ["\\"co\\nl4_0\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5290525660, "histo_buckets": [{"distinct_range": 0, "num_eq": 2069401393175661185, "num_range": 0, "upper_bound": "-14544"}, {"distinct_range": 90000000000, "num_eq": 1000000000, "num_range": 90000000000, "upper_bound": "21154"}, {"distinct_range": 0, "num_eq": 0, "num_range": 4000, "upper_bound": "28268"}, {"distinct_range": 2896537238.0806146, "num_eq": 4683892200084777953, "num_range": 8000000000, "upper_bound": "-2865"}, {"distinct_range": 1709719750717832700, "num_eq": 5198564174046669444, "num_range": 5564982333426111342, "upper_bound": "27646"}, {"distinct_range": 30, "num_eq": 900000, "num_range": 30, "upper_bound": "32767"}], "histo_col_type": "INT2", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 20000000000}, {"avg_size": 7, "columns": ["\\"col4?_1\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 9410895663, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 20000000000}, {"avg_size": 8, "columns": ["col4_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 16858174698, "histo_col_type": "OID", "histo_version": 3, "name": "__auto__", "null_count": 7413317197, "row_count": 20000000000}, {"avg_size": 31, "columns": ["\\"co l\\r4_3\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2665542714, "histo_buckets": [{"distinct_range": 0, "num_eq": 2393601749437958556, "num_range": 0, "upper_bound": "0.5101228614473092102"}, {"distinct_range": 82088344232608510, "num_eq": 34133872375971312, "num_range": 82088344232608511, "upper_bound": "2.637478704971420661E+19"}], "histo_col_type": "DECIMAL", "histo_version": 3, "name": "__auto__", "null_count": 256146552, "row_count": 20000000000}, {"avg_size": 8, "columns": ["col4_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 15421899282, "histo_buckets": [{"distinct_range": 0, "num_eq": 5689511526920110626, "num_range": 0, "upper_bound": "-424385370405220822"}, {"distinct_range": 0, "num_eq": 90000000000, "num_range": 3000000000, "upper_bound": "-9152554849817293591"}, {"distinct_range": 5053768048657957000, "num_eq": 2395954956033641341, "num_range": 6967238249322829654, "upper_bound": "-6555175297836990753"}], "histo_col_type": "INT8", "histo_version": 3, "name": "__auto__", "null_count": 0, "row_count": 20000000000}, {"avg_size": 4, "columns": ["\\"c%qol4_5\\""], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 15965693705, "histo_buckets": [{"distinct_range": 0, "num_eq": 8089748189676864409, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 0, "num_eq": 80000, "num_range": 0, "upper_bound": "373477092"}, {"distinct_range": 0, "num_eq": 3928231975224615686, "num_range": 0, "upper_bound": "1918087209"}, {"distinct_range": 0, "num_eq": 10000000, "num_range": 9009720594282368976, "upper_bound": "931506225"}], "histo_col_type": "REGROLE", "histo_version": 3, "name": "__auto__", "null_count": 11737010329, "row_count": 20000000000}, {"avg_size": 14, "columns": ["col4_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4111926510, "histo_buckets": [{"distinct_range": 0, "num_eq": 6910063135098042649, "num_range": 0, "upper_bound": "-492847.8689867267098"}, {"distinct_range": 2490994962483465700, "num_eq": 70000000, "num_range": 2490994962483465508, "upper_bound": "-3.191568073036060852E+22"}, {"distinct_range": 0, "num_eq": 800000000, "num_range": 6547613845776314203, "upper_bound": "-8.074006620194808572E+29"}, {"distinct_range": 0, "num_eq": 7000000000, "num_range": 0, "upper_bound": "-6.872069961150032456E+33"}], "histo_col_type": "DECIMAL", "histo_version": 3, "name": "__auto__", "null_count": 16979887879, "row_count": 20000000000}]':::JSONB;
rsg_test.go:767: CREATE TYPE rand_typ_0 AS (wqmog BYTES, bqzl JSONB, bycl INT8, nngg DATE, j BOOL);
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 (4941982131041608987);
rsg_test.go:767: ALTER TABLE seed SPLIT AT VALUES (4829880746564442929);
rsg_test.go:767: ALTER TABLE seed SPLIT AT VALUES (4465511478809913420);
rsg_test.go:767: ALTER TABLE seed SPLIT AT VALUES (757772402609526414);
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/logTestRandomSyntaxSQLSmith3991709472
--- FAIL: TestRandomSyntaxSQLSmith (322.44s)
```
Help

See also: [How To Investigate a Go Test Failure \(internal\)](https://cockroachlabs.atlassian.net/l/c/HgfXfJgM)

/cc @cockroachdb/sql-foundations

[This test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestRandomSyntaxSQLSmith.*&sort=title+created&display=lastcommented+project) | [Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/bazci/githubpost/issues)

Jira issue: CRDB-46861

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.