Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.12.2
Bug #11716 SQLite returns result field names with quotes
Submitted: 2007-07-31 10:47 UTC
From: cweiske Assigned: aharvey
Status: Closed Package: DB (version 1.7.12)
PHP Version: 5.2.3 OS:
Roadmaps: 1.7.13    
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 : 32 + 27 = ?

 
 [2007-07-31 10:47 UTC] cweiske (Christian Weiske)
Description: ------------ A bug in SQLite causes the field names to be returned with quotes when using the quotes in the query. To have consistent behaviour among all drivers, the sqlite driver should remove the quotes if there are any. Test script: --------------- SELECT field FROM table; -> DB::getRow() returns $result['field']; SELECT "field" FROM table; -> DB::getRow() returns $result['"field"'];

Comments

 [2007-09-21 14:23 UTC] aharvey (Adam Harvey)
This bug has been fixed in CVS. 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.