1SET big_tables = 1;
2CREATE TABLE t1(a BINARY (1)) ROW_FORMAT=DYNAMIC ENGINE=InnoDB;
3SELECT NOT EXISTS(SELECT 1) FROM t1 JOIN t1 a USING(a) GROUP BY 1 DESC WITH ROLLUP;
4NOT EXISTS(SELECT 1)
5Warnings:
6Warning	1287	'GROUP BY with ASC/DESC' is deprecated and will be removed in a future release. Please use GROUP BY ... ORDER BY ... ASC/DESC instead
7DROP TABLE t1;
8