Skip Menu |

This queue is for tickets about the DBD-mysqlPP CPAN distribution.

Report information
The Basics
Id: 16763
Status: resolved
Priority: 0/
Queue: DBD-mysqlPP
People
Owner: tsucchi [...] cpan.org
Requestors: info [...] whawes.co.uk
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Dec 28 06:50:47 2005 Guest - Ticket created
Subject: Incorrect quoting of parameter values in LIMIT clause
When the SQL statement passed to execute() contains a LIMIT clause containing one or more placeholders (e.g. "LIMIT ?,?), the values are quoted (e.g. "LIMIT '0','10'"). This causes MySQL 5.0.16 to return an "incorrect syntax" error. Previous MySQL versions untested. IMO the module should test for a LIMIT clause containing placeholders and ensure that the corresponding parameter values are not quoted.
  Wed Nov 02 22:11:12 2011 tsucchi [...] cpan.org - Taken
  Wed Nov 02 22:11:30 2011 tsucchi [...] cpan.org - Correspondence added
this issue is fixed in 0.06. If you have any problem, please re-open this ticket.
  Wed Nov 02 22:11:30 2011 The RT System itself - Status changed from 'new' to 'open'
  Wed Nov 02 22:11:30 2011 tsucchi [...] cpan.org - Status changed from 'open' to 'resolved'