Skip to content

roachtest: unoptimized-query-oracle/disable-rules=all/rand-tables failed #146524

Open
@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.unoptimized-query-oracle/disable-rules=all/rand-tables failed with artifacts on release-25.1 @ 1797174e32d9cd3419c332bf3f8fb9c59e2bf2f5:

(query_comparison_util.go:419).runOneRoundQueryComparison: . 2664 statements run: expected unoptimized and optimized results to be equal
  []string{
  	... // 34 identical elements
  	"{1,-102232.6753746744565}",
  	"{1,1.2,0.111}",
- 	"{1.0}",
  	"{1.1,0,1611465014.534075758}",
  	"{1.1,5288645.252319572989,9.8,0.111,-9.8}",
  	... // 3 identical elements
  	"{12662190617.980984,-7751720.684212990149}",
  	"{144118787106363.6430,-9.8}",
+ 	"{1}",
  	"{3.677984647291620043E+37,9.9,1}",
  	"{4.131349781301468676E+36,-13929286644114906.39}",
  	... // 22 identical elements
  }
sql: SELECT
	tab_3218.col4_0 AS col_9145
FROM
	defaultdb.public.table_4 AS tab_3218
GROUP BY
	tab_3218.col4_0, tab_3218.crdb_internal_origin_id
ORDER BY
	tab_3218.col4_0 DESC NULLS LAST, tab_3218.crdb_internal_origin_id ASC NULLS FIRST, col_9145 NULLS LAST
LIMIT
	90:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=all/rand-tables/run_1

Parameters:

  • arch=amd64
  • cloud=gce
  • coverageBuild=false
  • cpu=4
  • encrypted=false
  • runtimeAssertionsBuild=false
  • ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

This test on roachdash | Improve this report!

Jira issue: CRDB-50572

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-roachtestO-robotOriginated from a bot.O-rsgRandom Syntax GeneratorT-sql-queriesSQL Queries Teambranch-release-25.1release-blockerIndicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.

    Type

    No type

    Projects

    Status

    Triage

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions