Skip to content

roachtest: opt: join reordering incorrectly omitting filters when some optimization rules are disabled #146507

@cockroach-teamcity

Description

@cockroach-teamcity

roachtest.unoptimized-query-oracle/disable-rules=half/seed-multi-region failed with artifacts on release-25.1 @ 1797174e32d9cd3419c332bf3f8fb9c59e2bf2f5:

  	"NULL,-90,0,-1,NULL",
- 	"NULL,-90,0,-13567561,200 years 8 days 00:00:10",
- 	"NULL,-90,0,-1849683824,NULL",
- 	"NULL,-90,0,17,NULL",
  	"NULL,-90,0,32,NULL",
  	"NULL,-90,0,32767,62 years 10 mons 749 days 03:29:27.260172",
- 	"NULL,-90,0,NULL,NULL",
- 	"NULL,-90,0,NULL,NULL",
  	"NULL,-90,0,NULL,NULL",
  }
sql: SELECT
	tab_50._timestamp AS col_259,
	(-90):::INT8 AS col_260,
	0:::OID AS col_261,
	tab_50._int4 AS col_262,
	tab_50._interval AS col_263
FROM
	defaultdb.public.seed AS tab_50
WHERE
	tab_50._uuid::UUID IN (SELECT tab_50._uuid::UUID AS col_258 FROM defaultdb.public.seed AS tab_51)
ORDER BY
	tab_50._int8 DESC NULLS LAST,
	tab_50._timestamp ASC,
	tab_50._int4 NULLS LAST,
	tab_50._string ASC,
	tab_50.crdb_internal_origin_timestamp DESC NULLS LAST,
	tab_50._int2 DESC NULLS FIRST,
	tab_50._bool DESC NULLS FIRST,
	col_262 NULLS LAST,
	tab_50.tableoid NULLS FIRST,
	tab_50._interval NULLS LAST,
	tab_50.crdb_internal_mvcc_timestamp DESC NULLS LAST,
	tab_50._float4 ASC NULLS LAST,
	tab_50._timestamptz DESC,
	tab_50._decimal ASC,
	tab_50._inet ASC,
	tab_50._bytes DESC NULLS FIRST,
	tab_50._jsonb ASC NULLS FIRST,
	col_259,
	tab_50.crdb_internal_origin_id ASC NULLS LAST,
	col_260 ASC,
	col_261 ASC NULLS FIRST,
	tab_50._uuid NULLS LAST,
	tab_50._enum ASC NULLS FIRST,
	tab_50._float8 ASC NULLS LAST,
	tab_50._date DESC NULLS FIRST,
	col_263 NULLS FIRST
LIMIT
	12:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/seed-multi-region/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-50559

Metadata

Metadata

Assignees

Type

No type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions