Mantis - Quercus
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
4713 major always 08-16-11 08:40 06-21-12 13:38
Reporter: jamesdlow Platform:  
Assigned To: nam OS:  
Priority: normal OS Version:  
Status: closed Product Version: 4.0.14  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version:  
Summary: 0004713: Certain Valid MySQL statements fail
Description: Certain mysql statements seem to fail in in Quercus when doing PDO.

A statement like:
update {table} set {column} = 'A string which we\'ve escaped but has a colon :'

This fails because there is a colon in the string after an escaped apostrophe. The strange thing is that it doesn't occur if there are two escape apostrophe's before the colon.

I've managed to track it down to: PDOStatement.parseQueryString where it is checking for colons within a statement. If I remove this check the MySQL query works.
      else if (quote == 0 && ch == ':') {
        parameterCount++;
        name = new StringBuilder();
        continue;
      }
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:

Notes
(0005924)
nam   
06-21-12 13:38   
php/1s1e

colons in quotes should work now:

$stmt = $pdo->prepare("SELECT * FROM test WHERE data = ':a'");
var_dump($stmt->execute());
var_dump($stmt->fetchAll());