985
--echo # Bug#57688 Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field
988
CREATE TABLE t1 (f1 INT NOT NULL, PRIMARY KEY (f1));
989
CREATE TABLE t2 (f1 INT NOT NULL, f2 INT NOT NULL, PRIMARY KEY (f1, f2));
991
INSERT INTO t1 VALUES (4);
992
INSERT INTO t2 VALUES (3, 3);
993
INSERT INTO t2 VALUES (7, 7);
995
EXPLAIN SELECT * FROM t1 LEFT JOIN t2 ON t2.f1 = t1.f1
997
GROUP BY t2.f1, t2.f2;
999
SELECT * FROM t1 LEFT JOIN t2 ON t2.f1 = t1.f1
1001
GROUP BY t2.f1, t2.f2;
1003
EXPLAIN SELECT * FROM t1 LEFT JOIN t2 ON t2.f1 = t1.f1
1004
WHERE t1.f1 = 4 AND t2.f1 IS NOT NULL AND t2.f2 IS NOT NULL
1005
GROUP BY t2.f1, t2.f2;
1007
SELECT * FROM t1 LEFT JOIN t2 ON t2.f1 = t1.f1
1008
WHERE t1.f1 = 4 AND t2.f1 IS NOT NULL AND t2.f2 IS NOT NULL
1009
GROUP BY t2.f1, t2.f2;
984
1013
--echo End of 5.1 tests