[06:16:47] 	-- OK;
[06:16:47] CREATE TABLE t44624(c0 STRING, c1 BOOL); INSERT INTO t44624(rowid, c0, c1) VALUES (0, '', true), (1, '', NULL);;
[06:16:47] rewrote:
CREATE TABLE t44624 (c0 STRING, c1 BOOL, FAMILY (c0, c1));
INSERT INTO t44624(rowid, c0, c1) VALUES (0, '', true), (1, '', NULL);


[06:16:47] SELECT * FROM t44624 ORDER BY CASE WHEN c1 IS NULL THEN c0 WHEN true THEN c0 END;
[06:16:47] 	-- OK;
[06:16:47] CREATE TABLE t44726(c0 INT); INSERT INTO t44726(c0) VALUES (0);;
[06:16:47] SELECT * FROM t44726 WHERE 0 > (CASE WHEN nullif(NULL, ilike_escape('', current_user(), '')) THEN 0 ELSE t44726.c0 END);
[06:16:47] 	-- OK;
[06:16:47] CREATE TABLE t44822(c0 BYTES); CREATE VIEW v0(c0) AS SELECT min(t44822.c0) FROM t44822;;
[06:16:47] SELECT * FROM v0 WHERE v0.c0 NOT BETWEEN v0.c0 AND v0.c0;
[06:16:47] 	-- OK;
[06:16:47] CREATE TABLE t44935 (x decimal); INSERT INTO t44935 VALUES (1.0), (1.00);;
[06:16:47] SELECT count(*) FROM (SELECT DISTINCT x FROM t44935);
[06:16:47] 	-- OK;
[06:16:47] CREATE TABLE t45481 (a INT, b INT, c FLOAT, d DECIMAL, e STRING, f BYTES, g UUID, PRIMARY KEY (a, b, c, d, e, f, g));
RESET vectorize;
INSERT INTO t45481 SELECT a, b, c::FLOAT, d::DECIMAL, d::STRING, d::STRING::BYTES, rpad(d::STRING, 32, d::STRING)::UUID FROM
   generate_series(1, 7) AS a(a),
   generate_series(1, 7) AS b(b),
   generate_series(1, 7) AS c(c),
   generate_series(1, 7) AS d(d);
SET vectorize = experimental_always;
[06:16:47] rewrote:
CREATE TABLE t45481 (a INT8, b INT8, c FLOAT8, d DECIMAL, e STRING, f BYTES, g UUID, PRIMARY KEY (a, b, c, d, e, f, g), FAMILY (b, f, e), FAMILY (d), FAMILY (g, a, c));
RESET vectorize;
INSERT INTO t45481 SELECT a, b, c::FLOAT8, d::DECIMAL, d::STRING, d::STRING::BYTES, rpad(d::STRING, 32, d::STRING)::UUID FROM ROWS FROM (generate_series(1, 7)) AS a (a), ROWS FROM (generate_series(1, 7)) AS b (b), ROWS FROM (generate_series(1, 7)) AS c (c), ROWS FROM (generate_series(1, 7)) AS d (d);
SET vectorize = experimental_always;


[06:16:47] SELECT b, d, e, f, g, sum(a) FROM t45481 GROUP BY b, d, e, f, g ORDER BY b, d, e, f, g;
[06:17:13] 	-- OK;
[06:17:13] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3761/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-dbg/bin/pkg/sql/logictest/tests/fakedist/fakedist_test_/fakedist_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/vectorize: 170 statements
[06:17:13] CREATE TABLE mixed_type_a (a INT, b TIMESTAMPTZ);
CREATE TABLE mixed_type_b (a INT, b INTERVAL, c TIMESTAMP);
INSERT INTO mixed_type_a VALUES (0, 0::TIMESTAMPTZ);
INSERT INTO mixed_type_b VALUES (0, INTERVAL '0 days', 0::TIMESTAMP);;
[06:17:13] rewrote:
CREATE TABLE mixed_type_a (a INT8, b TIMESTAMPTZ, FAMILY (a), FAMILY (b));
CREATE TABLE mixed_type_b (a INT8, b INTERVAL, c TIMESTAMP, FAMILY (b), FAMILY (a), FAMILY (c));
INSERT INTO mixed_type_a VALUES (0, 0::TIMESTAMPTZ);
INSERT INTO mixed_type_b VALUES (0, '0 days'::INTERVAL, 0::TIMESTAMP);


[06:17:14] SELECT b > now() - interval '1 day'  FROM mixed_type_a;
[06:17:14] 	-- OK;
[06:17:14] SELECT * FROM mixed_type_a AS a INNER MERGE JOIN mixed_type_b AS b ON a.a = b.a AND a.b < (now() - b.b);