Debian Codegraph @

mysql-test/suite/parts/r/cache.result

raw
1 CREATE TABLE t1 (f1 INT, f2 INT, f3 INT, f4 INT, KEY (f4),
2 KEY (f1,f4,f3,f2)
3 ) PARTITION BY RANGE(f1) ( PARTITION p VALUES LESS THAN MAXVALUE );
4 INSERT IGNORE INTO t1 VALUES
5 (140,0,0,7),(143,92,NULL,0),(0,0,NULL,154),(NULL,255,117,197),(0,0,NULL,0),(60,0,0,1);
6 CREATE TABLE t2 (f INT);
7 INSERT INTO t2 VALUES (NULL),(35),(NULL),(2);
8 SELECT * FROM t1, t2 WHERE f4 >= f;
9 f1 f2 f3 f4 f
10 0 0 NULL 154 2
11 0 0 NULL 154 35
12 140 0 0 7 2
13 NULL 255 117 197 2
14 NULL 255 117 197 35
15 DROP TABLE t1, t2;