Bug #41479 Variable in LIMIT clause
Submitted: 15 Dec 2008 16:31 Modified: 15 Dec 2008 16:51
Reporter: Ruvim Pinka Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.29-rc OS:Any
Assigned to: CPU Architecture:Any

[15 Dec 2008 16:31] Ruvim Pinka
Description:
Variables in the LIMIT clause doesn't supported.

How to repeat:
SET @lim = 1;
SELECT 1 AS n LIMIT @lim;

Suggested fix:
A supporting of this syntax will be useful.
[15 Dec 2008 16:51] MySQL Verification Team
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=6673