Bug #32399 query parser doesn't understand limit statement containing floating-point value
Submitted: 14 Nov 2007 22:27 Modified: 15 Nov 2007 4:35
Reporter: Alex Fihman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Parser Severity:S4 (Feature request)
Version:5.0.27, 5.0.45 OS:Any
Assigned to: CPU Architecture:Any
Tags: floating-point value, limit

[14 Nov 2007 22:27] Alex Fihman
Description:
query parser doesn't understand limit statement containing floating-point value

How to repeat:
example query:
------------------------------
select m.*
from mysql.user m 
limit 1e2

Suggested fix:
please add floating-point parsing, typing 4-5 zeros is annoying
[14 Nov 2007 22:32] Alex Fihman
also limit part of the sql statement doesn't accept variables:
-------------------------------------------------
set @a=100;

select m.*
from mysql.user m limit @a
-------------------------------------------------
[fc6] ERROR 1064: 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 '@a' at line 2
[15 Nov 2007 4:35] Valeriy Kravchuk
According to the manual, http://dev.mysql.com/doc/refman/5.0/en/select.html:

"The LIMIT clause can be used to constrain the number of rows returned by the SELECT  statement. LIMIT takes one or two numeric arguments, which must both be non-negative integer constants (except when using prepared statements)."

but yes, what you are asking for still looks like a reasonable feature request.