MySQL Bugs: #41479: Variable in LIMIT clause

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=6673