Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 2.5.0b5
Bug #8309 Error on SHOW statement
Submitted: 2006-07-27 15:57 UTC
From: mr dot lobach at gmail dot com Assigned: lsmith
Status: Closed Package: MDB2 (version 2.2.0)
PHP Version: 5.1.4 OS: gentoo
Roadmaps: (Not assigned)    
Subscription  


 [2006-07-27 15:57 UTC] mr dot lobach at gmail dot com (evgeny lobach)
Description: ------------ I'm using mysql database. If table's name one of reserved words, some methods return errors. Such tables need escaping apostrophes. For example, SHOW COLUMNS FROM `order`; List of methods which fixing: MDB2_Driver_Manager_mysql::listTableFields MDB2_Driver_Manager_mysql::listTableIndexes MDB2_Driver_Manager_mysql::listTableConstraints MDB2_Driver_Reverse_mysql::getTableFieldDefinition MDB2_Driver_Reverse_mysql::getTableIndexDefinition MDB2_Driver_Reverse_mysql::getTableConstraintDefinition Or another choice escaping into DB2_Driver_Manager_mysql::listTables Sorry for my bad english. Thaks

Comments

 [2006-07-27 16:03 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2006-07-28 07:13 UTC] mr dot lobach at gmail dot com
quote_identifier was enabled. It's result: MDB2_Error [message] => MDB2 Error: syntax error [userinfo] => _doQuery: [Error message: Could not execute statement] [Last query: SHOW COLUMNS FROM order LIKE 'orderid'] [Native code: 1064] Table's name not escaped.
 [2006-07-30 19:20 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!