-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest.unoptimized-query-oracle/disable-rules=half failed due to extra precision decimals #86790
Copy link
Copy link
Closed
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).T-sql-queriesSQL Queries TeamSQL Queries Teamsync-me
Description
roachtest.unoptimized-query-oracle/disable-rules=half failed with artifacts on master @ 80c274877a917580af62be6eb0cd48c8c7ae9c08:
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/run_1
query_comparison_util.go:237,query_comparison_util.go:69,unoptimized_query_oracle.go:51,test_runner.go:896: . 17242 statements run: expected unoptimized and optimized results to be equal
(1) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.(*queryComparisonHelper).makeError
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:345
| [...repeated from below...]
Wraps: (2) . 17242 statements run
Wraps: (3) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runUnoptimizedQueryOracleImpl
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:160
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1.1
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:54
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runOneRoundQueryComparison
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:236
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runQueryComparison
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:69
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:51
| main.(*testRunner).runTest.func2
| main/pkg/cmd/roachtest/test_runner.go:896
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1571
Wraps: (4) expected unoptimized and optimized results to be equal
| []string{
| strings.Join({
| "-9.8,0,0,104,0,1661263847326383409.0",
| + "000000000",
| }, ""),
| strings.Join({
| "-9.8,104,0,104,0,1661263847077927364.0",
| + "000000000",
| }, ""),
| }
| sql: SELECT
| (-9.8):::DECIMAL AS col_37722,
| tab_21236.col1_0 AS col_37723,
| 0:::OID AS col_37724,
| tab_21236.tableoid AS col_37725,
| 0:::OID AS col_37726,
| (tab_21236.crdb_internal_mvcc_timestamp::DECIMAL / 1:::DECIMAL::DECIMAL)::DECIMAL AS col_37727
| FROM
| defaultdb.public.table1@[0] AS tab_21236
| JOIN defaultdb.public.table1@[0] AS tab_21237 ON
| (tab_21236.crdb_internal_mvcc_timestamp) = (tab_21237.crdb_internal_mvcc_timestamp)
| ORDER BY
| tab_21236.tableoid ASC
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError
Parameters: ROACHTEST_cloud=gce
, ROACHTEST_cpu=4
, ROACHTEST_ssd=0
This test on roachdash | Improve this report!
Originally posted by @cockroach-teamcity in #86308 (comment)
Jira issue: CRDB-18936
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).T-sql-queriesSQL Queries TeamSQL Queries Teamsync-me
Type
Projects
Status
Done