Bug #8309

Error on SHOW statement

Details

Submitted	2006-07-27 15:57 UTC
From	mr dot lobach at gmail dot com
Assigned	lsmith
Status	Closed
Package	MDB2
PHP Version	5.1.4
OS	gentoo
Roadmaps	(Not assigned)

Comments

[2006-07-27 15:57 UTC] mr dot lobach at gmail dot com

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

[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.