test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/run_1
query_comparison_util.go:237,query_comparison_util.go:66,unoptimized_query_oracle.go:54,test_runner.go:930: . 21551 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) . 21551 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:168
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.registerUnoptimizedQueryOracle.func1.1
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/unoptimized_query_oracle.go:57
| 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:54
| main.(*testRunner).runTest.func2
| main/pkg/cmd/roachtest/test_runner.go:930
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1594
Wraps: (4) expected unoptimized and optimized results to be equal
| []string{
| "0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,0000000"...,
| "0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,1110101"...,
| "0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,NULL,NU"...,
| - ``0,105,0.5054834485054016,1970-04-11 00:08:20 +0000 +0000,NULL,NULL,0,"``,
| }
| sql: SELECT
| 0:::OID AS col_88556,
| tab_27011.tableoid AS col_88557,
| 0.5054834485054016:::FLOAT8 AS col_88558,
| '1970-04-11 00:08:20':::TIMESTAMP AS col_88559,
| tab_27011.col2_14 AS col_88560,
| tab_27011.col2_9 AS col_88561,
| 0:::OID AS col_88562,
| tab_27011.col2_15 AS col_88563
| FROM
| defaultdb.public.table2@[0] AS tab_27011
| WHERE
| (EXISTS (SELECT ARRAY[32297:::INT8,15358:::INT8] AS col_88555 FROM defaultdb.public.table2@[0] AS tab_27012) AND ('00:01:40.01+09:00:00':::TIMETZ < (tab_27011.col2_8::TIMETZ + '-83 years -1 mons -38 days -10:32:23.707137':::INTERVAL::INTERVAL)::TIMETZ))
| ORDER BY
| tab_27011.col2_10, tab_27011.col2_1, tab_27011.col2_0, tab_27011.col2_5 DESC
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError
roachtest.unoptimized-query-oracle/disable-rules=all failed with artifacts on release-22.2 @ 5bbbb4fefe2cca87aa8dd34c007702bb2faa20ef:
Parameters:
ROACHTEST_cloud=gce,ROACHTEST_cpu=4,ROACHTEST_encrypted=false,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-20572