Skip to content

sql/tests: TestRandomSyntaxSQLSmith failed #64511

@cockroach-teamcity

Description

@cockroach-teamcity

sql/tests.TestRandomSyntaxSQLSmith failed with artifacts on master @ 684e753c15f3fc58df79b6ea70e7b6715eae4835:

        		SET CLUSTER SETTING sql.stats.automatic_collection.enabled = false;
        		SET CLUSTER SETTING sql.stats.histogram_collection.enabled = false;
        		SET CLUSTER SETTING sql.defaults.interleaved_tables.enabled = true;
        	CREATE TABLE table1 (col1_0 "char"[], col1_1 BOX2D NOT NULL, col1_2 OID NULL, col1_3 BOX2D NOT NULL, col1_4 STRING NULL AS (lower(CAST(col1_2 AS STRING))) VIRTUAL, col1_5 STRING NULL AS (lower(CAST(col1_2 AS STRING))) VIRTUAL);
        CREATE TABLE table2 (col2_0 REGPROC NOT NULL, col2_1 BIT(33) NOT NULL, col2_2 REGPROCEDURE NOT NULL, col2_3 BIT(21) NOT NULL, col2_4 TIMESTAMP NOT NULL, col2_5 FLOAT4 NOT NULL, col2_6 TIME NOT NULL, col2_7 BYTES NOT NULL, col2_8 TIMESTAMPTZ NOT NULL, col2_9 TIMESTAMP NOT NULL, col2_10 REGTYPE NOT NULL, PRIMARY KEY (col2_2 DESC, col2_0 ASC, col2_7 ASC, col2_5, col2_10, col2_3, col2_4 ASC, col2_8, col2_9 DESC, col2_1, col2_6), col2_11 FLOAT4 NOT NULL AS (col2_5 + 0.49931877851486206:::FLOAT8) STORED, col2_12 STRING NOT NULL AS (lower(CAST(col2_6 AS STRING))) VIRTUAL, col2_13 STRING NOT NULL AS (lower(CAST(col2_6 AS STRING))) VIRTUAL, INDEX (col2_2 DESC, col2_7 DESC, col2_0, col2_6 DESC, col2_10, col2_13) WHERE ((((((((table2.col2_8 >= '294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ) AND (table2.col2_9 <= '3000-01-01 00:00:00':::TIMESTAMP)) AND (table2.col2_4 > '294276-12-31 23:59:59.999999':::TIMESTAMP)) OR (table2.col2_5 < 0.0:::FLOAT8)) OR (table2.col2_12 > e'\x00':::STRING)) AND (table2.col2_11 != 'NaN':::FLOAT8)) AND (table2.col2_13 != '"':::STRING)) OR (table2.col2_6 <= '24:00:00':::TIME)) OR (table2.col2_7 = '\x00':::BYTES), INDEX (col2_3 ASC), INDEX (col2_8, col2_12 ASC, col2_1 DESC, col2_6, col2_7 DESC, col2_11 DESC, col2_9 ASC, col2_2 DESC, col2_0 DESC, col2_13 ASC, col2_5 ASC), INDEX (col2_1, col2_4 ASC, col2_13 ASC, col2_8 ASC, col2_7 DESC, col2_11 DESC, col2_6, col2_0, col2_10 ASC, col2_3) WHERE ((((((((table2.col2_4 >= '-2000-01-01 00:00:00':::TIMESTAMP) OR (table2.col2_12 < '"':::STRING)) OR (table2.col2_13 >= '':::STRING)) OR (table2.col2_8 <= '-2000-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table2.col2_5 >= 0.0:::FLOAT8)) AND (table2.col2_6 < '24:00:00':::TIME)) OR (table2.col2_7 = '\x27':::BYTES)) OR (table2.col2_9 = '-4713-11-24 00:00:00':::TIMESTAMP)) AND (table2.col2_11 = 0.0:::FLOAT8), UNIQUE (col2_3 ASC, col2_0 DESC, col2_7), INDEX (col2_11), INDEX (col2_11, col2_13 ASC, col2_4 ASC, col2_5 DESC, col2_8 ASC, col2_9 ASC, col2_0 ASC, col2_1, col2_7, col2_10, col2_12 DESC, col2_6, col2_2 DESC) WHERE ((((((((table2.col2_6 = '00:00:00':::TIME) OR (table2.col2_9 > '0001-01-01 00:00:00':::TIMESTAMP)) OR (table2.col2_12 >= e'\x00':::STRING)) OR (table2.col2_8 < '294276-12-31 23:59:59.999999+00:00':::TIMESTAMPTZ)) AND (table2.col2_13 > e'\'':::STRING)) AND (table2.col2_4 >= '-4713-11-24 00:00:00':::TIMESTAMP)) OR (table2.col2_7 < '\x58':::BYTES)) OR (table2.col2_11 != (-1.0):::FLOAT8)) OR (table2.col2_5 <= (-1.0):::FLOAT8));
        CREATE TABLE table3 (col3_0 INT2 NOT NULL, col3_1 OID NOT NULL, col3_2 TIMESTAMP NOT NULL, col3_3 GEOGRAPHY NOT NULL, col3_4 REGTYPE NULL, col3_5 CHAR NULL, col3_6 NAME, col3_7 BOOL NULL, col3_8 DECIMAL NOT NULL, col3_9 INT8 NULL, col3_10 TIMETZ, col3_11 DECIMAL NOT NULL, col3_12 BOOL, PRIMARY KEY (col3_1 DESC, col3_11 DESC), col3_13 INT8 NULL AS (col3_9 + col3_0) VIRTUAL, col3_14 INT2 NULL AS (col3_0 + col3_9) STORED, col3_15 STRING NOT NULL AS (lower(CAST(col3_3 AS STRING))) STORED, col3_16 INT8 NULL AS (col3_9 + (-128):::INT8) STORED, col3_17 INT2 NULL AS (col3_0 + col3_9) STORED, col3_18 DECIMAL AS (col3_11 + col3_8) STORED, INDEX (col3_7, col3_18 ASC, col3_1, col3_15, col3_9 DESC, col3_4 DESC, col3_14, col3_13 ASC) STORING (col3_0, col3_5, col3_12, col3_16, col3_17), UNIQUE (col3_7 DESC, col3_10 ASC, col3_1 ASC, col3_12 ASC, col3_2 DESC, col3_16 ASC, col3_5, col3_15 ASC, col3_13, col3_18 ASC, col3_11 ASC, col3_6 ASC, col3_17, col3_0 DESC, col3_8 DESC, col3_4 DESC) STORING (col3_3, col3_14) WHERE (((((((((((((((table3.col3_14 != 1:::INT8) OR table3.col3_12) OR (table3.col3_0 >= 1:::INT8)) AND (table3.col3_16 != (-1):::INT8)) OR (NOT table3.col3_7)) AND (table3.col3_5 = e'\U00002603':::STRING)) AND (table3.col3_18 >= (-1.234E+401):::DECIMAL)) AND (table3.col3_8 = 1:::DECIMAL)) OR (table3.col3_9 <= 9223372036854775807:::INT8)) OR (table3.col3_17 >= 0:::INT8)) OR (table3.col3_2 != '0001-01-01 00:00:00':::TIMESTAMP)) OR (table3.col3_11 = 0:::DECIMAL)) AND (table3.col3_13 <= 9223372036854775807:::INT8)) AND (table3.col3_6 = 'X':::STRING)) OR (table3.col3_10 <= '24:00:00-15:59:00':::TIMETZ)) OR (table3.col3_15 < 'X':::STRING), INDEX (col3_11 ASC, col3_9) STORING (col3_2, col3_3, col3_4, col3_8, col3_15) WHERE (((((((((table3.col3_2 < '-2000-01-01 00:00:00':::TIMESTAMP) AND (table3.col3_6 = '':::STRING)) OR (table3.col3_9 != 2147483647:::INT8)) AND (table3.col3_16 < (-9223372036854775807):::INT8)) AND (table3.col3_0 <= (-1):::INT8)) AND (table3.col3_8 > (-1.234E+401):::DECIMAL)) AND (table3.col3_17 != (-1):::INT8)) OR (table3.col3_15 < e'\'':::STRING)) AND (table3.col3_18 < 'Infinity':::DECIMAL)) AND (table3.col3_5 > e'\'':::STRING), UNIQUE (col3_0 DESC, col3_15, col3_11 DESC, col3_13 DESC, col3_16, col3_2 ASC, col3_17 ASC, col3_8 ASC) STORING (col3_3, col3_6, col3_10, col3_18), INVERTED INDEX (col3_17, col3_3 ASC), FAMILY (col3_6), FAMILY (col3_16, col3_0, col3_15), FAMILY (col3_3, col3_8), FAMILY (col3_4), FAMILY (col3_12), FAMILY (col3_10), FAMILY (col3_18, col3_7, col3_2), FAMILY (col3_14), FAMILY (col3_1), FAMILY (col3_17, col3_11), FAMILY (col3_9), FAMILY (col3_5));
        CREATE TABLE table4 (col2_2 REGPROCEDURE NOT NULL, col2_0 REGPROC NOT NULL, col2_7 BYTES NOT NULL, col2_5 FLOAT4 NOT NULL, col2_10 REGTYPE NOT NULL, col2_3 BIT(21) NOT NULL, col2_4 TIMESTAMP NOT NULL, col2_8 TIMESTAMPTZ NOT NULL, col2_9 TIMESTAMP NOT NULL, col2_1 BIT(33) NOT NULL, col2_6 TIME NOT NULL, col4_11 REGNAMESPACE NOT NULL, col4_12 UUID NOT NULL, col4_13 TIMETZ NOT NULL, col4_14 REGTYPE, col4_15 INET, col4_16 VARCHAR NOT NULL, col4_17 TIMETZ NOT NULL, col4_18 TIME, col4_19 BOOL NOT NULL, col4_20 BOX2D, col4_21 BYTES NOT NULL, col4_22 REGTYPE, col4_23 BYTES, PRIMARY KEY (col2_2 DESC, col2_0 ASC, col2_7 ASC, col2_5, col2_10, col2_3, col2_4 ASC, col2_8, col2_9 DESC, col2_1, col2_6, col4_14 DESC, col4_11 ASC, col4_20 ASC), UNIQUE (col4_17, col4_18 ASC, col2_10 ASC, col2_6 ASC, col4_20 ASC, col4_21 ASC, col4_11 DESC, col4_16 DESC, col4_13 ASC, col2_4 DESC, col4_12, col2_1 DESC) STORING (col4_15, col4_19) WHERE table4.col4_16 < e'\x00':::STRING, INDEX (col2_4 DESC, col4_11, col4_17 DESC, col4_18 ASC, col4_12 ASC, col4_19 DESC, col2_7, col2_5, col2_9, col4_20, col2_10 DESC, col4_14 ASC, col4_16 ASC, col2_8 DESC, col2_6 ASC, col4_15 DESC, col2_1, col4_13 ASC, col2_0 ASC, col4_21 ASC, col2_3 ASC, col2_2 ASC, col4_22 DESC, col4_23 DESC), UNIQUE (col4_23 ASC, col4_13 DESC, col2_7 DESC, col4_22 DESC, col2_5 ASC, col2_1 ASC, col2_8, col4_17, col2_9 DESC, col4_16 ASC) STORING (col4_18) WHERE ((((((((((((table4.col2_5 < '+Inf':::FLOAT8) AND (table4.col2_9 <= '-2000-01-01 00:00:00':::TIMESTAMP)) OR (table4.col2_7 < '\x00':::BYTES)) AND (table4.col4_23 != '\xe29883':::BYTES)) AND (table4.col2_4 = '-4713-11-24 00:00:00':::TIMESTAMP)) OR (table4.col2_8 >= '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) AND (NOT table4.col4_19)) OR (table4.col4_21 < '\xff':::BYTES)) AND (table4.col4_18 < '24:00:00':::TIME)) AND (table4.col4_16 >= e'\U00002603':::STRING)) OR (table4.col2_6 > '24:00:00':::TIME)) AND (table4.col4_17 < '24:00:00-15:59:00':::TIMETZ)) OR (table4.col4_13 < '00:00:00+15:59:00':::TIMETZ), FAMILY (col4_20), FAMILY (col4_16), FAMILY (col4_19), FAMILY (col2_0, col4_18, col2_8), FAMILY (col4_15, col2_9), FAMILY (col2_10), FAMILY (col4_12), FAMILY (col4_21), FAMILY (col2_2), FAMILY (col4_22, col4_17), FAMILY (col4_13), FAMILY (col2_5, col2_4), FAMILY (col2_7, col4_23, col2_3, col4_11, col2_6, col4_14, col2_1)) INTERLEAVE IN PARENT table2 (col2_2, col2_0, col2_7, col2_5, col2_10, col2_3, col2_4, col2_8, col2_9, col2_1, col2_6);
        CREATE TABLE table5 (col5_0 FLOAT4 NOT NULL, col5_1 REGCLASS, col5_2 OID NOT NULL, col5_3 NAME NOT NULL, col5_4 REGPROCEDURE NOT NULL, col5_5 GEOMETRY NULL, col5_6 TIMESTAMPTZ NOT NULL, col5_7 TIMESTAMPTZ NOT NULL, col5_8 BIT(34) NULL, PRIMARY KEY (col5_2 DESC, col5_0 ASC, col5_7 ASC, col5_6 ASC), col5_9 FLOAT4 NOT NULL AS (col5_0 + 0.6271438598632812:::FLOAT8) STORED, col5_10 STRING AS (lower(CAST(col5_1 AS STRING))) STORED, col5_11 STRING NOT NULL AS (lower(CAST(col5_2 AS STRING))) VIRTUAL, col5_12 STRING NULL AS (lower(CAST(col5_8 AS STRING))) VIRTUAL, col5_13 FLOAT4 NOT NULL AS (col5_0 + 1.4535945653915405:::FLOAT8) STORED, col5_14 STRING NULL AS (lower(CAST(col5_5 AS STRING))) VIRTUAL, col5_15 STRING NULL AS (lower(CAST(col5_8 AS STRING))) STORED, col5_16 STRING NOT NULL AS (lower(CAST(col5_4 AS STRING))) STORED, UNIQUE (col5_16 DESC, col5_2, col5_13 DESC, col5_11 DESC) STORING (col5_4, col5_5, col5_9, col5_10, col5_15) WHERE (((((table5.col5_9 = '+Inf':::FLOAT8) OR (table5.col5_6 < '0001-01-01 00:00:00+00:00':::TIMESTAMPTZ)) AND (table5.col5_3 < e'\'':::STRING)) AND (table5.col5_14 >= '"':::STRING)) OR (table5.col5_16 = 'X':::STRING)) OR (table5.col5_7 < '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ));
        ALTER TABLE table1 INJECT STATISTICS '[{"columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4420518712899717460, "histo_col_type": "", "name": "__auto__", "null_count": 3500089775775923302, "row_count": 7996542350471596421}, {"columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5558033345463008238, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7996542350471596421}, {"columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2523528596659102884, "histo_col_type": "", "name": "__auto__", "null_count": 7195310867991598589, "row_count": 7996542350471596421}, {"columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5522051343944540653, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 7996542350471596421}, {"columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3050671152584093476, "histo_col_type": "", "name": "__auto__", "null_count": 1250154390275265519, "row_count": 7996542350471596421}, {"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5869329114030772351, "histo_col_type": "", "name": "__auto__", "null_count": 1925143020396266304, "row_count": 7996542350471596421}]':::JSONB;
        ALTER TABLE table2 INJECT STATISTICS '[{"columns": ["col2_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4848183618121587335, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2493728957986511869, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3553149474764468381, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3290118771560298650, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2794444090456877612, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 832553341523855972, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4504116791772129747, "histo_buckets": [{"distinct_range": 0, "num_eq": 600, "num_range": 0, "upper_bound": "1980-08-10 02:26:59.000573+00:00"}, {"distinct_range": 5903575897705128000, "num_eq": 1512633485456553150, "num_range": 5903575897705127551, "upper_bound": "1990-08-21 12:24:11.000584+00:00"}, {"distinct_range": 0, "num_eq": 2462490662485236729, "num_range": 4810331167958242231, "upper_bound": "1999-11-20 17:24:39.0003+00:00"}, {"distinct_range": 8178758815055997000, "num_eq": 50000000000, "num_range": 9092626343994031323, "upper_bound": "2000-11-01 07:40:05.000338+00:00"}, {"distinct_range": 0, "num_eq": 4733576938186432975, "num_range": 80000, "upper_bound": "2018-08-16 15:11:24.000987+00:00"}, {"distinct_range": 0, "num_eq": 90000000000, "num_range": 6000, "upper_bound": "2020-01-12 13:24:53.000156+00:00"}], "histo_col_type": "TIMESTAMPTZ", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4335233223617802632, "histo_buckets": [{"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": "3243850779"}, {"distinct_range": 324672949047671700, "num_eq": 90000, "num_range": 324672949047671662, "upper_bound": "3598494984"}], "histo_col_type": "REGPROCEDURE", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3544751809660815279, "histo_col_type": "BIT(21)", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5051560202340653939, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1033218147172847292, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2441297504998152821, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5979734390771417437, "histo_buckets": [{"distinct_range": 0, "num_eq": 2702195452600263522, "num_range": 0, "upper_bound": "-1.7666362524032593"}, {"distinct_range": 1428654901536618200, "num_eq": 30, "num_range": 7683216929502947521, "upper_bound": "-1.5756860971450806"}, {"distinct_range": 0, "num_eq": 70, "num_range": 60000, "upper_bound": "-1.177482008934021"}, {"distinct_range": 6000000000, "num_eq": 9000, "num_range": 6000000000, "upper_bound": "-0.572706937789917"}, {"distinct_range": 800000, "num_eq": 5000, "num_range": 800000, "upper_bound": "0.00098385289311409"}, {"distinct_range": 0, "num_eq": 5078953857235167217, "num_range": 3000000000, "upper_bound": "0.055069610476493835"}, {"distinct_range": 40000, "num_eq": 6000000000, "num_range": 40000, "upper_bound": "0.15588146448135376"}, {"distinct_range": 3680454296367747600, "num_eq": 3000, "num_range": 3813781326147352642, "upper_bound": "0.22373081743717194"}], "histo_col_type": "FLOAT4", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}, {"columns": ["col2_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4121571816406655619, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 6910795679214870087}]':::JSONB;
        ALTER TABLE table3 INJECT STATISTICS '[{"columns": ["col3_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2399771721812348517, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5686227716393790671, "histo_col_type": "", "name": "__auto__", "null_count": 515791639598254214, "row_count": 5869123410075685046}, {"columns": ["col3_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2124870956817743128, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2721014253399383501, "histo_col_type": "", "name": "__auto__", "null_count": 3309401777372839673, "row_count": 5869123410075685046}, {"columns": ["col3_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2804779820938526562, "histo_buckets": [{"distinct_range": 0, "num_eq": 50000000, "num_range": 0, "upper_bound": "-Infinity"}, {"distinct_range": 0, "num_eq": 4166678256434386649, "num_range": 0, "upper_bound": "-8.916594048465046923E+28"}, {"distinct_range": 0, "num_eq": 1000000000, "num_range": 397894393265146496, "upper_bound": "-9.16112776306306806E+24"}, {"distinct_range": 1437605171565982000, "num_eq": 332951474609953944, "num_range": 1437605171565982015, "upper_bound": "-4602146630.962424601"}, {"distinct_range": 1357093499563502300, "num_eq": 200000000, "num_range": 2692918766692268530, "upper_bound": "-50057912.08973759385"}, {"distinct_range": 4633101327086111000, "num_eq": 7863545876959439969, "num_range": 5574204180135603566, "upper_bound": "71116808165801.60489"}, {"distinct_range": 0, "num_eq": 1229520989534524927, "num_range": 500000000, "upper_bound": "814166544278283879"}, {"distinct_range": 7475591671.797859, "num_eq": 5630689242159617892, "num_range": 20000000000, "upper_bound": "2.860919513672654427E+25"}, {"distinct_range": 40, "num_eq": 6436595499955188032, "num_range": 40, "upper_bound": "6.650205504902699083E+27"}], "histo_col_type": "DECIMAL", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2504544223469770688, "histo_col_type": "", "name": "__auto__", "null_count": 658729570236900269, "row_count": 5869123410075685046}, {"columns": ["col3_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2384444851227210270, "histo_col_type": "", "name": "__auto__", "null_count": 5849639059630433321, "row_count": 5869123410075685046}, {"columns": ["col3_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 752750304316947929, "histo_col_type": "", "name": "__auto__", "null_count": 5253184999468413740, "row_count": 5869123410075685046}, {"columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 653264180319850405, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4610764568508693225, "histo_col_type": "", "name": "__auto__", "null_count": 3040352191303601343, "row_count": 5869123410075685046}, {"columns": ["col3_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 590934702915285617, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4262090568137664286, "histo_col_type": "", "name": "__auto__", "null_count": 477969278896721970, "row_count": 5869123410075685046}, {"columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3913534290834393968, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5118374365824886478, "histo_col_type": "", "name": "__auto__", "null_count": 999977324681769578, "row_count": 5869123410075685046}, {"columns": ["col3_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 828864195313305059, "histo_col_type": "", "name": "__auto__", "null_count": 2454080311115539616, "row_count": 5869123410075685046}, {"columns": ["col3_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3889537722148945482, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5869123410075685046}, {"columns": ["col3_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5764851958295263537, "histo_buckets": [{"distinct_range": 0, "num_eq": 7086607834942271060, "num_range": 0, "upper_bound": "false"}, {"distinct_range": 272752792.13229465, "num_eq": 80000, "num_range": 300000000, "upper_bound": "true"}], "histo_col_type": "BOOL", "name": "__auto__", "null_count": 1531031388261000998, "row_count": 5869123410075685046}, {"columns": ["col3_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1687189893837529385, "histo_col_type": "", "name": "__auto__", "null_count": 1491698463891788034, "row_count": 5869123410075685046}, {"columns": ["col3_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4281097698288658698, "histo_col_type": "", "name": "__auto__", "null_count": 4267006386064204728, "row_count": 5869123410075685046}]':::JSONB;
        ALTER TABLE table4 INJECT STATISTICS e'[{"columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 74, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 59, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 46, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 26, "histo_col_type": "", "name": "__auto__", "null_count": 8, "row_count": 100}, {"columns": ["col4_22"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1, "histo_col_type": "", "name": "__auto__", "null_count": 89, "row_count": 100}, {"columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 69, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 98, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 56, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 49, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 65, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6, "histo_col_type": "", "name": "__auto__", "null_count": 79, "row_count": 100}, {"columns": ["col4_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 58, "histo_buckets": [{"distinct_range": 0, "num_eq": 40978660124469693, "num_range": 0, "upper_bound": "15:11:48.192583+12:43:00"}, {"distinct_range": 0, "num_eq": 6687550772635275149, "num_range": 8617787309837245983, "upper_bound": "23:15:50.350627+11:10:00"}, {"distinct_range": 0, "num_eq": 70000000000, "num_range": 3618371900561775992, "upper_bound": "24:00:00-15:59:00"}], "histo_col_type": "TIMETZ", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 64, "histo_col_type": "", "name": "__auto__", "null_count": 48, "row_count": 100}, {"columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 35, "histo_buckets": [{"distinct_range": 0, "num_eq": 8233115015717381059, "num_range": 0, "upper_bound": "531155078"}, {"distinct_range": 109596.13408274698, "num_eq": 1000, "num_range": 200000, "upper_bound": "1489438768"}, {"distinct_range": 0, "num_eq": 9000000, "num_range": 100000000000, "upper_bound": "2101424183"}, {"distinct_range": 0, "num_eq": 8097111900873131590, "num_range": 6706992877690366475, "upper_bound": "2485333579"}, {"distinct_range": 619.4915761942669, "num_eq": 7421426861589939756, "num_range": 700, "upper_bound": "2670448850"}], "histo_col_type": "REGPROCEDURE", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_23"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 88, "histo_buckets": [{"distinct_range": 0, "num_eq": 7228061879168588220, "num_range": 0, "upper_bound": "\\\\x"}, {"distinct_range": 1574754460862970600, "num_eq": 1000000000, "num_range": 2340289203244752434, "upper_bound": "\\\\x22"}, {"distinct_range": 0, "num_eq": 1000, "num_range": 1382173514392163654, "upper_bound": "\\\\x2529f2d77c731c"}, {"distinct_range": 2900904715913657000, "num_eq": 407689655739993578, "num_range": 5132560067875705010, "upper_bound": "\\\\x58"}, {"distinct_range": 20, "num_eq": 8167131270356664209, "num_range": 20, "upper_bound": "\\\\x9e8caeb292a130ab"}, {"distinct_range": 0, "num_eq": 100000000, "num_range": 3036443582805536152, "upper_bound": "\\\\xa6b16ad010"}, {"distinct_range": 1823.7005759578287, "num_eq": 60000, "num_range": 2000, "upper_bound": "\\\\xc08f55ca23"}, {"distinct_range": 0, "num_eq": 0, "num_range": 8794912376694137401, "upper_bound": "\\\\xf6e40bbf289de99c73"}], "histo_col_type": "BYTES", "name": "__auto__", "null_count": 3, "row_count": 100}, {"columns": ["col4_20"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 15, "histo_col_type": "", "name": "__auto__", "null_count": 24, "row_count": 100}, {"columns": ["col2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 95, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 62, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 72, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_19"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 90, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col4_21"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 78, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}, {"columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 44, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 100}]':::JSONB;
        ALTER TABLE table5 INJECT STATISTICS '[{"columns": ["col5_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 293338, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 431138, "histo_col_type": "", "name": "__auto__", "null_count": 187149, "row_count": 500000}, {"columns": ["col5_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 24364, "histo_col_type": "", "name": "__auto__", "null_count": 361459, "row_count": 500000}, {"columns": ["col5_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 304061, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 122999, "histo_col_type": "", "name": "__auto__", "null_count": 412953, "row_count": 500000}, {"columns": ["col5_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 465253, "histo_col_type": "", "name": "__auto__", "null_count": 346913, "row_count": 500000}, {"columns": ["col5_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 243558, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 159820, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 26008, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 430088, "histo_col_type": "", "name": "__auto__", "null_count": 48458, "row_count": 500000}, {"columns": ["col5_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 9935, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 339342, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 369687, "histo_col_type": "", "name": "__auto__", "null_count": 9230, "row_count": 500000}, {"columns": ["col5_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 323615, "histo_buckets": [{"distinct_range": 0, "num_eq": 80, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 0, "num_eq": 7564787649659531052, "num_range": 100000000, "upper_bound": "535502444"}, {"distinct_range": 0, "num_eq": 5973344642055351394, "num_range": 467686792872881190, "upper_bound": "626643937"}, {"distinct_range": 60000, "num_eq": 1183471798051987983, "num_range": 60000, "upper_bound": "1308558457"}, {"distinct_range": 350509368028168000, "num_eq": 3000000000, "num_range": 350509368028167970, "upper_bound": "1320931779"}, {"distinct_range": 0, "num_eq": 2000000000, "num_range": 1000000, "upper_bound": "1408587793"}, {"distinct_range": 591210.7076927794, "num_eq": 70000000000, "num_range": 600000, "upper_bound": "1691512712"}, {"distinct_range": 0, "num_eq": 777148707276709339, "num_range": 0, "upper_bound": "1970520625"}, {"distinct_range": 315494559007757060, "num_eq": 10000, "num_range": 7955851099281383827, "upper_bound": "3284112267"}], "histo_col_type": "OID", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 380358, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}, {"columns": ["col5_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 490733, "histo_col_type": "", "name": "__auto__", "null_count": 422325, "row_count": 500000}, {"columns": ["col5_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 421971, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500000}]':::JSONB;
        CREATE TYPE rand_typ_0 AS ENUM ('v');
        ;
    rsg_test.go:577: 
        SET CLUSTER SETTING sql.defaults.drop_enum_value.enabled = true;
        SET enable_drop_enum_value = true;
        
        CREATE TYPE greeting AS ENUM ('hello', 'howdy', 'hi', 'good day', 'morning');
        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;
        
        INSERT INTO seed DEFAULT VALUES;
        CREATE INDEX on seed (_int8, _float8, _date);
        CREATE INVERTED INDEX on seed (_jsonb);
        ;
    rsg_test.go:579: 
    rsg_test.go:580: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxSQLSmith531604020
--- FAIL: TestRandomSyntaxSQLSmith (300.83s)
Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxSQLSmith PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-queries @rafiss

This test on roachdash | Improve this report!

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.branch-masterFailures and bugs on the master branch.

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions