MySQL Bugs: #2037: LIMIT X,-1 doesn't work

Bug #2037	LIMIT X,-1 doesn't work
Submitted:	7 Dec 2003 11:02	Modified:	8 Dec 2003 7:30
Reporter:	nico champix	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	mysql Ver 14.3 Distrib 4.1.1-alpha	OS:	Linux (Linux slackware 2.4.22)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
mysql> select * from users_permissions limit 0, -1;
ERROR 1064 (42000): You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1

How to repeat:
mysql> select * from users_permissions limit 0, -1;
ERROR 1064 (42000): You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

this is not a bug.
Instead, the fact that LIMIT X, -1 worked some time ago was a bug (low priority, though) and it was listed in the "known bugs" section. Finally it was fixed, so LIMIT no longer accepts negative arguments. Use a large positive number for that.