Skip to content

roachtest: disable usage of decimals in costfuzz and unoptimized query oracle #88547

@cockroach-teamcity

Description

@cockroach-teamcity

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

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-19874

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-release-22.2Used to mark GA and release blockers, technical advisories, and bugs for 22.2

Type

No type

Projects

Status

Done

Relationships

None yet

Development

No branches or pull requests

Issue actions