Zend Framework

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Won't Fix
• Affects Version/s: 1.0.0, 1.0.1
• Fix Version/s: 1.5.0
• Component/s: Zend_Db
• Labels:

  None

When using reserved characters like [ and ], the regular expressions in the protected function Zend_Db_Statement->_stripQuoted() throw an exception/error. This is because the strings should be quoted like that:

$q = preg_quote($q);
$qe = preg_quote($qe);
$d = preg_quote($d);
$de = preg_quote($de);

I noticed this problem while using MS-SQL Server (odbtp). Of course, you can set QUOTED_IDENTIFIER to ON and use double quotes instead of brackets (as described in related tickets):

http://msdn2.microsoft.com/en-us/library/aa224033(SQL.80).aspx

This however doesn't change the fact, that chars inserted into a regular expression should be escaped. Delimiters in brackets can always be used, regardless of the setting of QUOTED_IDENTIFIER.

Just an idea, but isn't there an easier way of getting the escape characters from the database adapter? Functions like getIdentifierQuoteStartChar(), getIdentifierQuoteEndChar(), getQuoteStartChar() and getQuoteEndChar()? I would even recommend using public class constants for this purpose.

• Assignee:

  Bill Karwin

  Reporter:

  Michael Mayer

• Created:

  24/Sep/07 7:04 AM

  Updated:

  21/Mar/08 4:25 PM

  Resolved:

  01/Oct/07 8:38 PM