Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.5.0b5

Bug #17094 NULL character is not escaped
Submitted: 2010-02-13 03:20 UTC
From: nilya Assigned: doconnor
Status: Closed Package: MDB2_Driver_ibase (version CVS)
PHP Version: 5.3.1 OS: Any
Roadmaps: (Not assigned)    
Subscription  


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 1 + 14 = ?

 
 [2010-02-13 03:20 UTC] nilya (Ilya Nazarov)
Description: ------------ escape() do not handles \x00 character. Test script: --------------- <? include_once "MDB2.php"; $db =& MDB2::connect('ibase(firebird)://SYSDBA:masterkey@localhost/test', array('database_extension'=>'')); $result=$db->query("SELECT '".$db->escape("test\x00test")."' AS x FROM RDB\$DATABASE"); if(PEAR::isError($result)) { echo $result->getUserInfo(); } else { echo 'NORMAL'; } Expected result: ---------------- NORMAL Actual result: -------------- _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT 'testtest' AS x FROM RDB$DATABASE] [Native code: -104] [Native message: Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 1, column 8 ]

Comments

 [2010-02-13 03:31 UTC] nilya (Ilya Nazarov)
 [2012-01-25 20:33 UTC] doconnor (Daniel O'Connor)
-Status: Open +Status: Closed -Assigned To: +Assigned To: doconnor
This bug has been fixed in SVN. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.