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; |