-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: internal error: in-between filters didn't yield a constraint #80820
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.
Description
roachtest.sqlsmith/setup=rand-tables/setting=no-mutations failed with artifacts on master @ a2e1910f51593bd2ef72e1d7c615e08f95791186:
The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-mutations/run_1
sqlsmith.go:265,sqlsmith.go:305,test_runner.go:876: error: pq: internal error: in-between filters didn't yield a constraint
stmt:
WITH
with_60848 (col_348252)
AS (
SELECT
*
FROM
(VALUES ('hviat':::rand_typ_0), ('ymlez':::rand_typ_0), ('pzlue':::rand_typ_0), ('ivkys':::rand_typ_0))
AS tab_152645 (col_348252)
)
SELECT
NULL AS col_348253,
tab_152646.col1_3 AS col_348254,
tab_152646.col1_6 AS col_348255,
tab_152646.col1_8 AS col_348256,
23871:::INT8 AS col_348257,
'\x5c91d7a0d2edd6fc0f':::BYTES AS col_348258,
tab_152646.col1_5 AS col_348259,
e'F\x01W[\x12':::STRING AS col_348260,
(-6.335565852276255591E+29):::DECIMAL AS col_348261,
tab_152646.col1_4 AS col_348262,
NULL AS col_348263
FROM
defaultdb.public.table1@[0] AS tab_152646
WHERE
(7679919245303374124:::INT8 < tab_152646.col1_2)
ORDER BY
tab_152646.tableoid DESC;
This test on roachdash | Improve this report!
Jira issue: CRDB-15503
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.
Type
Projects
Status
Done