>Description:
Instead of ordering rows, ORDER BY may remove rows
>How-To-Repeat:
CREATE TABLE T (
Id INTEGER NOT NULL,
Id2 INTEGER NOT NULL,
Val FLOAT NOT NULL,
Id3 INTEGER NOT NULL,
KEY Key2 (Id2, Val),
KEY Key3 (Id3)
);
INSERT INTO T VALUES(1,3,-12,4);
INSERT INTO T VALUES(2,2,-27.5,
>Description:
FLUSH TABLE requires a global RELOAD privilege, even
though it only operates on a table in a given database. RELOAD privileges
cannot be granted on specific databases or even tables.
>How-To-Repeat:
mysql> grant reload on test.* to [EMAIL PROTECTED];
ERROR 1221 (HY000): Wron