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
• Status: Verified
• Category: MySQL Server: Parser
• Severity: S4 (Feature request)
• Version: 5.0.27, 5.0.45
• OS: Any
• 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.