ZF-10334: Wrong Generated SQL

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

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');