Skip to content

roachtest: -0 is not converted to 0, causing spurious tlp failure #77279

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.tlp failed with artifacts on master @ e151a24dc1d495bf694e1e1c3ee8acb518c1424e:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	tlp.go:170,tlp.go:76,test_runner.go:779: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:243
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:268
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  | + 	"-0",
		  |   	"-0.08327121444050486",
		  |   	"-0.3325643758917869",
		  |   	... // 3 identical elements
		  |   	"-1.029317916464786",
		  |   	"-2.5910802100934904",
		  | - 	"0",
		  |   	"0.34983588080578065",
		  |   	"0.4833675094669227",
		  |   	... // 4 identical elements
		  |   }
		  | sql: SELECT DISTINCT tab_43377.col1_0 FROM defaultdb.public.table1 AS tab_43377
		  | (SELECT DISTINCT tab_43377.col1_0 FROM defaultdb.public.table1 AS tab_43377 WHERE (tab_43377.col1_2 <= tab_43377.col1_2)) UNION (SELECT DISTINCT tab_43377.col1_0 FROM defaultdb.public.table1 AS tab_43377 WHERE NOT ((tab_43377.col1_2 <= tab_43377.col1_2))) UNION (SELECT DISTINCT tab_43377.col1_0 FROM defaultdb.public.table1 AS tab_43377 WHERE ((tab_43377.col1_2 <= tab_43377.col1_2)) IS NULL)
		  | with args: []
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-13514

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions