ZF-5713: Zend_Db_Select INTERSECT

Issue Type: Improvement Created: 2009-02-07T07:31:45.000+0000 Last Updated: 2012-11-20T20:53:36.000+0000 Status: Closed Fix version(s): Reporter: Chris (binaryexp) Assignee: None Tags: - Zend_Db_Select

Related issues: Attachments:


I have noticed that there is now support for UNION queries, but still no INTERSECT support. It would be nice to also have intersection support when using postgres, etc, though I believe MySQL does not support it anyway.


Posted by Kamil Nowakowski (kamiln) on 2009-02-07T07:35:15.000+0000

you can achive this by using join see

Posted by Chris (binaryexp) on 2009-02-07T07:55:07.000+0000

It may be possible to use JOIN, depending on the queries. Besides, I think JOIN could potentially be far slower than INTERSECT.

Posted by Benjamin Eberlei (beberlei) on 2009-02-07T07:58:51.000+0000

shouldn't the SQL parser realize that and rebuild the statement?

however to the issue, Zend_Db_Select will only support features that can be done in all sql dialects supported. If you can do it by join though it might be a workaround for all those engines not supporting it. To get this issue through, you should provide generic intersect statements for all drivers, which would make it far easier to look through.

Posted by Rob Allen (rob) on 2012-11-20T20:53:36.000+0000

Bulk change of all issues last updated before 1st January 2010 as "Won't Fix".

Feel free to re-open and provide a patch if you want to fix this issue.

Have you found an issue?

See the Overview section for more details.


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

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