roachtest: costfuzz/rand-tables failed

[cockroach-teamcity]

roachtest.costfuzz/rand-tables failed with artifacts on master @ aacba20d325e5702836e9a76be646b5f1bd922af:

- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
- 	"NULL,NULL,aab,NULL,NULL,NULL,À,F>\x0f,NULL,NULL,NULL,,,\x06r\x13\x14\x02P1!",
  	... // 28 identical elements
  }
sql: SELECT
	tab1137.col2_0 AS col3524,
	tab1137.col2_0 AS col3525,
	'aab':::STRING:::NAME AS col3526,
	tab1138.col2_0 AS col3527,
	tab1137.col2_0 AS "😛col?	3528",
	tab1137.col2_0 AS col3529,
	e'\u00C0':::STRING:::NAME AS col3530,
	e'F>\x0f':::STRING:::NAME AS "co_L 3531",
	tab1138.col2_0 AS col3532,
	tab1137.col2_0 AS "Col3533",
	tab1138.col2_0 AS col3534,
	'':::STRING:::NAME AS co😋l3535,
	'':::STRING:::NAME AS col3536,
	e'\x06r\x13\x14\x02P1!':::STRING:::NAME AS "col 3537"
FROM
	defaultdb.public."tabl�e2" AS tab1137
	JOIN defaultdb.public."tabl�e2" AS tab1138 ON
			(tab1137.col2_2) = (tab1138.col2_2)
			AND (tab1137."col2'_4") = (tab1138."col2'_4")
			AND (tab1137.col2_8) = (tab1138.col2_8)
ORDER BY
	tab1137.col2_0 ASC NULLS LAST, tab1137.col2_0 DESC NULLS LAST, tab1137.col2_0 DESC NULLS LAST
test artifacts and logs in: /artifacts/costfuzz/rand-tables/run_1

Parameters: ROACHTEST_arch=amd64 , ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_encrypted=false , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-29330

[mgartner]

Reduced:

CREATE TABLE t (
  a STRING NOT NULL,
  b INT,
  c INT,
  d INT,
  INDEX (d),
  INDEX (b),
  UNIQUE (a)
);

SET unconstrained_non_covering_index_scan_enabled = true;

INSERT INTO t (a, b, c)
VALUES ( 'foo', NULL, 1);

SELECT t1.b, t2.b
FROM t AS t1 JOIN t AS t2 ON
  t1.a = t2.a
  AND t1.c = t2.c;

SET testing_optimizer_random_seed = 8290919608099293508;

SET testing_optimizer_cost_perturbation = 1.0;

SELECT t1.b, t2.b
FROM t AS t1 JOIN t AS t2 ON
  t1.a = t2.a
  AND t1.c = t2.c;

In the second query, an incorrect equality filter is synthesized, b = b:

  • hash join
  │ equality: (a, c, b) = (a, c, b)
  │ left cols are key
  │ right cols are key
  │
  ├── • scan
  │     missing stats
  │     table: t@t_pkey
  │     spans: FULL SCAN
  │
  └── • scan
        missing stats
        table: t@t_pkey
        spans: FULL SCAN

This is a duplicate of #105608 and #105598.