-
Notifications
You must be signed in to change notification settings - Fork 4.1k
roachtest: disable usage of decimals in costfuzz and unoptimized query oracle #88547
Copy link
Copy link
Closed
Closed
Copy link
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.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-release-22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2
Milestone
Description
roachtest.costfuzz failed with artifacts on release-22.2 @ c037b5e5ce491a4a2b6e33401b00a05c2b117c73:
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.(*queryComparisonHelper).makeError
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:349
| [...repeated from below...]
Wraps: (2) . 1134 statements run
Wraps: (3) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runCostFuzzQuery
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/costfuzz.go:104
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runOneRoundQueryComparison
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/query_comparison_util.go:240
| 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.runCostFuzz
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/costfuzz.go:43
| main.(*testRunner).runTest.func2
| main/pkg/cmd/roachtest/test_runner.go:908
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1594
Wraps: (4) expected unperturbed and perturbed results to be equal
| []string{
| ... // 43 identical elements
| "à,2d00:87e1:bfc9:fb23:def3:92e1:51dd:ec53/30,0101000060E6100000"...,
| "à,32.238.17.224/6,0101000060E6100000BA7F5BBF348C5FC01E34D9CC3C5"...,
| strings.Join({
| "à,37.58.240.75/28,0101000060E6100000BA7F5BBF348C5FC01E34D9CC3C5",
| "B53C0ACDD67AD5829FE41,0,-175289.52976654449696392",
| - "00",
| }, ""),
| "à,3c:4d:4d:3c:4d:3c:3c:4d/0,0101000060E6100000BA7F5BBF348C5FC01"...,
| "à,3e79:89d1:c31b:9d01:f9eb:a795:bb2a:2b7d/65,0101000060E6100000"...,
| ... // 247 identical elements
| }
| sql: SELECT
| e'\u00E0':::STRING AS col_524,
| tab_163.col3_5 AS col_525,
| '0101000060E6100000BA7F5BBF348C5FC01E34D9CC3C5B53C0ACDD67AD5829FE41':::GEOGRAPHY AS col_526,
| 0:::OID AS col_527,
| tab_163.col3_6 AS col_528
| FROM
| defaultdb.public.table3@[0] AS tab_163
| WHERE
| '{"cars": [{"make": "Volkswagen", "model": "Rabbit", "trim": "S", "year": "2009"}, {"make": "Toyota", "model": "Camry", "trim": "LE", "year": "2002"}, {"make": "Ford", "model": "Focus", "trim": "SE", "year": "2011"}, {"make": "Buick", "model": "Grand National", "trim": "T-Type", "year": "1987"}, {"make": "Buick", "model": "Skylark", "trim": "Gran Sport", "year": "1966"}, {"make": "Porsche", "model": "911", "trim": "Turbo S", "year": "2022"}, {"make": "Chevrolet", "model": "Corvette", "trim": "C8", "year": "2022"}]}':::JSONB::JSONB
| NOT IN (
| SELECT
| e'{"/}Y.85>``M_": [[], [1.259780290319466]], "_I8\'aQ/*@])": ["baz"], "a": [[{"bar": false}, {"a": 0.5474650006122201}, 1.1777375094074776]], "baz": {}, "oYl}O\\"R5(<~": []}':::JSONB::JSONB
| AS col_523
| )
| ORDER BY
| tab_163.col3_6
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.leafError
Parameters: ROACHTEST_cloud=gce
, ROACHTEST_cpu=4
, ROACHTEST_ssd=0
Same failure on other branches
- 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-19874
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.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-release-22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2
Type
Projects
Status
Done