test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/run_1
query_comparison_util.go:237,query_comparison_util.go:66,unoptimized_query_oracle.go:51,test_runner.go:917: . 16874 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) . 16874 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:165
| 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:66
| 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:917
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1594
Wraps: (4) expected unoptimized and optimized results to be equal
| []string{
| - "1662817887234077610,NULL",
| + "1662817887234077610.0000000000,NULL",
| - "1662817887234077610,NULL",
| + "1662817887234077610.0000000000,NULL",
| - "1662817887234077610,NULL",
| + "1662817887234077610.0000000000,NULL",
| - "1662817887234077610,NULL",
| + "1662817887234077610.0000000000,NULL",
| - "1662817887234077610,NULL",
| + "1662817887234077610.0000000000,NULL",
| - "1662817889296694821,NULL",
| + "1662817889296694821.0000000000,NULL",
| - "1662817889898018542,NULL",
| + "1662817889898018542.0000000000,NULL",
| - "1662817890312351563,NULL",
| + "1662817890312351563.0000000000,NULL",
| - "1662817891619097933,NULL",
| + "1662817891619097933.0000000000,NULL",
| }
| sql: SELECT
| (tab_22380.crdb_internal_mvcc_timestamp::DECIMAL // 1:::DECIMAL::DECIMAL)::DECIMAL AS col_77105, NULL AS col_77106
| FROM
| defaultdb.public.table1@[0] AS tab_22380
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError
roachtest.unoptimized-query-oracle/disable-rules=half failed with artifacts on master @ 389661e823c19f318fa07ec2278336262531692d:
Parameters:
ROACHTEST_cloud=gce,ROACHTEST_cpu=4,ROACHTEST_ssd=0Help
See: roachtest README
See: How To Investigate (internal)
Same failure on other branches
This test on roachdash | Improve this report!
Jira issue: CRDB-19529