Skip Menu |

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

Report information
The Basics
Id: 17466
Status: rejected
Priority: 0/
Queue: DBD-mysql
People
Owner: Nobody in particular
Requestors: me [...] privacy.net
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 3.0002_5
Fixed in: (no value)

History Show all quoted text
  Fri Feb 03 10:54:45 2006 Guest - Ticket created
Subject: Escaped single quotes in a literal values break variable binding
The following code: $dbh->selectall_arrayref(" SELECT * FROM people WHERE last_name = 'O\'Brian' AND age = ? ", undef, 25); dies with "DBD::mysql::db selectall_arrayref failed: called with 1 bind variables when 0 are needed". I know I could have just bound both variables, but this is a simplified example. The actual SQL is dynamic and the reasons for not using binding for some values are legitimate.
  Thu Dec 28 18:02:55 2006 jimw-removetoemail [...] trainedmonkey.com - Correspondence added
On Fri Feb 03 10:54:45 2006, guest wrote: Show quoted text
> The following code: > > $dbh->selectall_arrayref(" > SELECT * FROM people > WHERE last_name = 'O\'Brian' AND age = ? > ", undef, 25); > > > dies with "DBD::mysql::db selectall_arrayref failed: called with 1 > bind variables when 0 are needed". I know I could have just bound both > variables, but this is a simplified example. The actual SQL is dynamic > and the reasons for not using binding for some values are legitimate.
This is not a bug in the driver, it is a bug in your code. You need to escape the escape character before the ' to get the query you want, because it is being seen as an escaped character in the double-quoted string. You could also escape the single quote by using two single quotes. Thanks for the report.
  Thu Dec 28 18:02:58 2006 The RT System itself - Status changed from 'new' to 'open'
  Thu Dec 28 18:02:59 2006 jimw-removetoemail [...] trainedmonkey.com - Status changed from 'open' to 'rejected'