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.

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.