Skip to content

roachtest/costfuzz: join reordering issue #88659

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.costfuzz failed with artifacts on master @ 89f4ad907a1756551bd6864c3e8516eeff6b0e0a:

		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runOneRoundQueryComparison
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:233
		  | 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.runCostFuzz
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/costfuzz.go:41
		  | main.(*testRunner).runTest.func2
		  | 	main/pkg/cmd/roachtest/test_runner.go:928
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1594
		Wraps: (4) expected unperturbed and perturbed results to be equal
		  |   []string{
		  |   	... // 3 identical elements
		  |   	"104,1.2345678901234568e-31,1664008168391878756.0000000000,1.2345"...,
		  |   	"104,1.2345678901234568e-31,1664008168391878756.0000000000,1.2345"...,
		  | + 	"104,1.2345678901234568e-31,1664008168391878756.0000000000,1.2345678901234563e-07,1.2345678901234566e-20,1.2345678901234566e-20,1.7976931348623157e+308,1.2345678901234566e-20,6.596932228060170625E+37",
		  |   	"104,1.2345678901234568e-31,1664008168391878756.0000000000,1.2345"...,
		  |   }
		  | sql: SELECT
		  | 	tab_27925.tableoid AS col_61799,
		  | 	1.2345678901234568e-31:::FLOAT8 AS col_61800,
		  | 	tab_27923.crdb_internal_mvcc_timestamp AS col_61801,
		  | 	1.2345678901234563e-07:::FLOAT8 AS col_61802,
		  | 	tab_27926.col1_1 AS col_61803,
		  | 	tab_27924.col1_1 AS col_61804,
		  | 	tab_27922.col1_0 AS col_61805,
		  | 	tab_27924.col1_1 AS col_61806,
		  | 	6.596932228060170625E+37:::DECIMAL AS col_61807
		  | FROM
		  | 	defaultdb.public.table1@[0] AS tab_27922
		  | 	RIGHT JOIN defaultdb.public.table1@[0] AS tab_27923 ON
		  | 			(tab_27922.col1_1) = (tab_27923.col1_1)
		  | 			AND (tab_27922.crdb_internal_mvcc_timestamp) >= (tab_27923.crdb_internal_mvcc_timestamp)
		  | 			AND (tab_27922.col1_1) = (tab_27923.col1_0)
		  | 	JOIN defaultdb.public.table1@[0] AS tab_27924 ON
		  | 			(tab_27923.col1_0) = (tab_27924.col1_0) AND (tab_27923.col1_1) = (tab_27924.col1_0)
		  | 	JOIN defaultdb.public.table1@[0] AS tab_27925 ON
		  | 			(tab_27923.col1_0) = (tab_27925.col1_0)
		  | 			AND (tab_27924.crdb_internal_mvcc_timestamp) = (tab_27925.crdb_internal_mvcc_timestamp)
		  | 			AND (tab_27922.col1_1) = (tab_27925.col1_0)
		  | 			AND (tab_27922.crdb_internal_mvcc_timestamp) = (tab_27925.crdb_internal_mvcc_timestamp)
		  | 			AND (tab_27924.col1_0) = (tab_27925.col1_0)
		  | 			AND (tab_27924.col1_1) = (tab_27925.col1_1)
		  | 	JOIN defaultdb.public.table1@[0] AS tab_27926 ON
		  | 			(tab_27925.col1_0) = (tab_27926.col1_1)
		  | 			AND (tab_27924.col1_1) = (tab_27926.col1_0)
		  | 			AND (tab_27924.col1_0) = (tab_27926.col1_0)
		  | ORDER BY
		  | 	tab_27924.crdb_internal_mvcc_timestamp
		Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-19846

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.S-0-visible-logical-errorDatabase stores inconsistent data in some cases, or queries return invalid results silently.S-3-erroneous-edge-caseDatabase produces or stores erroneous data without visible error/warning, in rare edge cases.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.

Type

No type

Projects

Status

Done

Relationships

None yet

Development

No branches or pull requests

Issue actions