91
91
INSERT INTO t2 VALUES (100),(200);
92
92
SELECT i, COUNT(*) FROM t1 GROUP BY i WITH ROLLUP;
93
SELECT t1.i, t2.i, COUNT(*) FROM t1 CROSS JOIN t2 GROUP BY t1.i,t2.i WITH ROLLUP;
93
SELECT t1.i, t2.i, COUNT(*) FROM t1,t2 GROUP BY t1.i,t2.i WITH ROLLUP;
96
96
#bug #4767: ROLLUP with LEFT JOIN