-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql/tests: TestRandomSyntaxSQLSmith failed #64592
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Team
Milestone
Description
sql/tests.TestRandomSyntaxSQLSmith failed with artifacts on release-21.1 @ f05a57facec0c2c3f623977b90506b76f94771df:
rsg_test.go:575: To reproduce, use schema:
rsg_test.go:577:
SET CLUSTER SETTING sql.defaults.drop_enum_value.enabled = true;
SET enable_drop_enum_value = true;
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 FLOAT8 NOT NULL, col1_1 BIT(24) NOT NULL, col1_2 REGNAMESPACE, PRIMARY KEY (col1_1 ASC, col1_0 ASC), col1_3 FLOAT8 NOT NULL AS (col1_0 + (-0.8447994200332785):::FLOAT8) VIRTUAL, INDEX (col1_3 ASC, col1_2, col1_1 DESC), FAMILY (col1_2, col1_0, col1_1));
ALTER TABLE table1 INJECT STATISTICS '[{"columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 346, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500}, {"columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 92, "histo_col_type": "", "name": "__auto__", "null_count": 172, "row_count": 500}, {"columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 68, "histo_buckets": [{"distinct_range": 0, "num_eq": 90000000, "num_range": 0, "upper_bound": "-0.30958886325040097"}, {"distinct_range": 63827489081.63343, "num_eq": 10, "num_range": 90000000000, "upper_bound": "-0.12023346864720708"}, {"distinct_range": 0, "num_eq": 0, "num_range": 90000000, "upper_bound": "-0.0033372841521017715"}, {"distinct_range": 10000000000, "num_eq": 7665243218565992837, "num_range": 10000000000, "upper_bound": "0.18460061949766904"}, {"distinct_range": 507334214608154300, "num_eq": 400000, "num_range": 507334214608154281, "upper_bound": "0.48217359015935757"}, {"distinct_range": 0, "num_eq": 8809704081348370070, "num_range": 1959486150583998733, "upper_bound": "0.5175615306009307"}, {"distinct_range": 0, "num_eq": 0, "num_range": 4340610631061397674, "upper_bound": "1.2573587523732055"}, {"distinct_range": 152.03810695254742, "num_eq": 30000, "num_range": 1000, "upper_bound": "3.4028234663852886e+38"}], "histo_col_type": "FLOAT8", "name": "__auto__", "null_count": 0, "row_count": 500}, {"columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 271, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 500}]':::JSONB;
CREATE TYPE rand_typ_0 AS ENUM ('rovo', 'mfell');
CREATE TYPE rand_typ_1 AS ENUM ('gqb', 'u', 'op');
CREATE TYPE rand_typ_2 AS ENUM ('xll', 'bw', 'cqmcvu', 'he', 'bacg');
CREATE TYPE rand_typ_3 AS ENUM ('wa', 'jabkji', 'h', 'kakmfq');
;
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/logTestRandomSyntaxSQLSmith287696541
--- FAIL: TestRandomSyntaxSQLSmith (302.16s)
Reproduce
To reproduce, try:
make stressrace TESTS=TestRandomSyntaxSQLSmith PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1Same failure on other branches
- sql/tests: TestRandomSyntaxSQLSmith failed #64511 sql/tests: TestRandomSyntaxSQLSmith failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @rafiss
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Done