Placeholders in Limit Clause - Server Side Prepared

Hello All,

it seems that the latest developer release (3.0008_1) will support
placeholders in the limit clause of a server side prepared statement.
However, I was wondering why this seems to be restricted to MySQL
version 5.1 and up? MySQL documentation states that this is supported
as of 5.0.7.

dbdimp.h code extract:
#define LIMIT_PLACEHOLDER_VERSION 50100


::::::MySQL Manual (http://dev.mysql.com/doc/refman/5.0/en/select.html)
"LIMIT takes one or two numeric arguments, which must both be
non-negative integer constants (except when using prepared
statements)"
...
"For prepared statements, you can use placeholders (supported as of
MySQL version 5.0.7)."

::::::Change Log 5.0.7 (10 June 2005)
(http://dev.mysql.com/doc/refman/5.0/en/news-5-0-7.html)
"Placeholders now can be used for LIMIT in prepared statements. (Bug#7306)"


Best Regards,

Christian

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]