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:

    Description

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

    
// in an AbstractTableGateway
$select = $this->select();
$select->from('my_table')
    ->columns(array('column1'), false);

    Expected query: SELECT "column1" FROM "my_table"

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

    Using PDO_Mysql.

    Comments

    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: https://github.com/zendframework/zf2/issues/2599