Description: ------------ When we have a query with quoted string containing a string matching sql comment definition, skipDelimitedStrings() can't handle it right, eg.: UPDATE test SET col1='-- some text' WHERE col2=? the solution is to change $ignores array creation order in such function to make comments checking last: $ignores = $this->string_quoting; $ignores[] = $this->identifier_quoting; $ignores[] = $this->sql_comments; but I'm not sure if that's a good solution. Test script: --------------- $options = array(); $dsn = 'pgsql://dbuser:pass@192.168.0.100/dbname'; $query = "UPDATE identities SET signature='-- blahblah' WHERE identity_id=?"; $mdb2 =& MDB2::factory($dsn, $options); if (PEAR::isError($mdb2)) { die($mdb2->getMessage()); } $q = $mdb2->prepare($query); if (PEAR::isError($q)) { die($q->getMessage()); } $mdb2->disconnect(); Expected result: ---------------- no error Actual result: -------------- _skipDelimitedStrings: [Error message: query with an unterminated text string specified]

absolutely, that was a silly error of mine. Fixed in CVS, thanks.