ZF-7821: Unquoted identifier in sqlite pdo adapter
Description
In file Db/Adapter/Pdo/Sqlite.php, in the describeTable method, schema and table names are not quoted (as it is done in Mysql pdo adaptor).
code :
if ($schemaName) {
$sql = "PRAGMA $schemaName.table_info($tableName)";
} else {
$sql = "PRAGMA table_info($tableName)";
}
shoulb be
if ($schemaName) {
$sql = 'PRAGMA '.$this->quoteIdentifier($schemaName).'.table_info('.$this->quoteIdentifier($tableName).')';
} else {
$sql = 'PRAGMA table_info('.$this->quoteIdentifier($tableName).')';
}
Comments
Posted by Ralph Schindler (ralph) on 2009-09-17T22:30:57.000+0000
Fixed in trunk at r18213 and in release 1.9 at r18214