-
Notifications
You must be signed in to change notification settings - Fork 4k
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.O-rsgRandom Syntax GeneratorRandom Syntax GeneratorP-2Issues/test failures with a fix SLA of 3 monthsIssues/test failures with a fix SLA of 3 monthsT-sql-queriesSQL Queries TeamSQL Queries Teambranch-release-25.1target-release-25.4.0v25.4.0-prerelease
Description
roachtest.unoptimized-query-oracle/disable-rules=half/seed-multi-region failed with artifacts on release-25.1 @ 1797174e32d9cd3419c332bf3f8fb9c59e2bf2f5:
"NULL,-90,0,-1,NULL",
- "NULL,-90,0,-13567561,200 years 8 days 00:00:10",
- "NULL,-90,0,-1849683824,NULL",
- "NULL,-90,0,17,NULL",
"NULL,-90,0,32,NULL",
"NULL,-90,0,32767,62 years 10 mons 749 days 03:29:27.260172",
- "NULL,-90,0,NULL,NULL",
- "NULL,-90,0,NULL,NULL",
"NULL,-90,0,NULL,NULL",
}
sql: SELECT
tab_50._timestamp AS col_259,
(-90):::INT8 AS col_260,
0:::OID AS col_261,
tab_50._int4 AS col_262,
tab_50._interval AS col_263
FROM
defaultdb.public.seed AS tab_50
WHERE
tab_50._uuid::UUID IN (SELECT tab_50._uuid::UUID AS col_258 FROM defaultdb.public.seed AS tab_51)
ORDER BY
tab_50._int8 DESC NULLS LAST,
tab_50._timestamp ASC,
tab_50._int4 NULLS LAST,
tab_50._string ASC,
tab_50.crdb_internal_origin_timestamp DESC NULLS LAST,
tab_50._int2 DESC NULLS FIRST,
tab_50._bool DESC NULLS FIRST,
col_262 NULLS LAST,
tab_50.tableoid NULLS FIRST,
tab_50._interval NULLS LAST,
tab_50.crdb_internal_mvcc_timestamp DESC NULLS LAST,
tab_50._float4 ASC NULLS LAST,
tab_50._timestamptz DESC,
tab_50._decimal ASC,
tab_50._inet ASC,
tab_50._bytes DESC NULLS FIRST,
tab_50._jsonb ASC NULLS FIRST,
col_259,
tab_50.crdb_internal_origin_id ASC NULLS LAST,
col_260 ASC,
col_261 ASC NULLS FIRST,
tab_50._uuid NULLS LAST,
tab_50._enum ASC NULLS FIRST,
tab_50._float8 ASC NULLS LAST,
tab_50._date DESC NULLS FIRST,
col_263 NULLS FIRST
LIMIT
12:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/seed-multi-region/run_1
Parameters:
arch=amd64
cloud=gce
coverageBuild=false
cpu=4
encrypted=false
runtimeAssertionsBuild=false
ssd=0
This test on roachdash | Improve this report!
Jira issue: CRDB-50559
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.O-rsgRandom Syntax GeneratorRandom Syntax GeneratorP-2Issues/test failures with a fix SLA of 3 monthsIssues/test failures with a fix SLA of 3 monthsT-sql-queriesSQL Queries TeamSQL Queries Teambranch-release-25.1target-release-25.4.0v25.4.0-prerelease
Type
Projects
Status
Done