ZF2-574: Not prefixing columns with table name creates invalid query

Issue Type: Bug Created: 2012-09-19T10:47:47.000+0000 Last Updated: 2012-10-08T20:12:19.000+0000 Status: Closed Fix version(s): Reporter: Robert Basic (robertbasic) Assignee: Ralph Schindler (ralph) Tags: - Zend\Db

Related issues: Attachments:


The columns() method of Sql\Select has a second parameter $prefixColumnsWithTable. When that is set to false, an invalid query is created.

<pre class="highlight">
// in an AbstractTableGateway
$select = $this->select();
    ->columns(array('column1'), false);

Expected query: SELECT "column1" FROM "my_table"

Actual query: SELECT ."column1" FROM "my_table"

Using PDO_Mysql.


Posted by Ralph Schindler (ralph) on 2012-10-08T20:12:19.000+0000

This issue has been closed on Jira and moved to GitHub for issue tracking. To continue following the resolution of this issues, please visit:

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.