Placeholders in Limit Clause - Server Side Prepared

Placeholders in Limit Clause - Server Side Prepared

am 27.10.2006 01:07:43 von Christian Hoermann

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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org