-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest/costfuzz: join reordering issue #88659
Copy link
Copy link
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.S-0-visible-logical-errorDatabase stores inconsistent data in some cases, or queries return invalid results silently.Database 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.Database produces or stores erroneous data without visible error/warning, in rare edge cases.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.
Milestone
Description
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
Same failure on other branches
- roachtest: disable usage of decimals in costfuzz and unoptimized query oracle #88547 roachtest: costfuzz failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-22.2]
- roachtest.costfuzz failed due to scientific notation v. decimal notation #86796 roachtest.costfuzz failed due to scientific notation v. decimal notation [C-test-failure T-sql-queries]
This test on roachdash | Improve this report!
Jira issue: CRDB-19846
Reactions are currently unavailable
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.S-0-visible-logical-errorDatabase stores inconsistent data in some cases, or queries return invalid results silently.Database 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.Database produces or stores erroneous data without visible error/warning, in rare edge cases.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.
Type
Projects
Status
Done