ZF-10334: Wrong Generated SQL

Issue Type:
Bug
Created:
2010-08-18T13:18:05.000+0000
Last Updated:
2012-11-20T21:37:29.000+0000
Status:
Open
Fix version(s):
    Reporter:
    Stéphane Castonguay (sscaston)
    Assignee:
    None
    Tags:
    • Zend_Db_Adapter_Db2
    Related issues:
    Attachments:

    Description

    When I call fetchAll() From Zend_Db_Table_Abstract->fetchAll(), the generated SQL generated does'nt work:

    SELECT "ZENDDEMO".* FROM "OPM"."ZENDDEMO"

    Working SQL should be like: SELECT "ZENDDEMO".* FROM "OPM"."ZENDDEMO" AS "ZENDDEMO" or SELECT * FROM "OPM"."ZENDDEMO"

    The database is on a AIX64 server. There are similarities from issue ZF-6039.

    Comments

    Posted by Stéphane Castonguay (sscaston) on 2010-08-19T05:39:16.000+0000

    It Seams that Zend_Db_Select doesn't work, this statements generates the same sql:

    $select = new Zend_Db_Select($db); $select->from('ZENDDEMO','*','OPM');