Hi,
I'm just getting around to converting some queries in my system to using
Zend_Db_Select (in the cases where I need such specific functionality).
I was a little surprised to uncover a bug in Zend_Db_Select as I'd
expect this is one area that is fairly heavily unit tested (i've not
looked, it's just a guess) and also an area that quite a few people
would use.
But I noticed that it is producing incorrect SQL. It's not that fact
that joinUsing() does not actually use the SQL USING() clause (I'm not
sure how standard that is to be honest - could be a MySQLism), it's more
the fact it totally messes up when table aliases are used!
I found this bug:
http://framework.zend.com/issues/browse/ZF-3309
I was very surprised to see that this was added in May, well over six
months ago.
While I've been using Zend for a while, and not been hit by this bug,
I'm surprised this kind of thing has been left unfixed for so long!
I'll try and work on a fix as without it I'll have to write a whole heap
of more verbose code that I'd rather do without!
Col
--
Colin Guthrie
gmane(at)colin.guthr.ie
http://colin.guthr.ie/
Day Job:
Tribalogic Limited [http://www.tribalogic.net/]
Open Source:
Mandriva Linux Contributor [http://www.mandriva.com/]
PulseAudio Hacker [http://www.pulseaudio.org/]
Trac Hacker [http://trac.edgewall.org/]
