Issues

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

Have you found an issue?

See the Overview section for more details.

Copyright

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

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

Contacts