ORDER BY may remove result rows

2004-01-30 Thread lknecht
>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,

RELOAD privilege is global, but FLUSH TABLE is local.

2004-01-06 Thread lknecht
>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