Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add support for SQL standard UNION syntax. jOOQ's current understanding of UNION is just convenience #1658

Closed
lukaseder opened this issue Aug 1, 2012 · 1 comment
Closed

Add support for SQL standard UNION syntax. jOOQ's current understanding of UNION is just convenience #1658

lukaseder opened this issue Aug 1, 2012 · 1 comment
Labels
C: Functionality P: Medium R: Fixed T: Enhancement
Milestone
Version 3.5.0

Comments

@lukaseder
Copy link
Member

The SQL standard expects the UNION operator (and other set operations) to stand between unordered "subselects". Only the whole UNION expression can then be ordered (and maybe limited). This should be reflected in the jOOQ API, correctly. Today's implementation is wrong, strictly speaking, although it may sometimes be more convenient
@lukaseder lukaseder modified the milestones: Version 3.4.0, Version 3.3.0 Feb 5, 2014
@lukaseder
Copy link
Member Author

This issue is very complex to implement and would make #2694 and #2335 much harder to implement. We should wait with this improvement

@lukaseder lukaseder modified the milestones: Version 3.5.0, Version 3.4.0 May 8, 2014
@lukaseder lukaseder mentioned this issue Aug 22, 2014
Open
lukaseder added a commit that referenced this issue Aug 22, 2014
@lukaseder
[#1658] Add support for SQL standard UNION syntax. jOOQ's current und…
908e0ca 
…erstanding of UNION is just convenience
lukaseder added a commit that referenced this issue Aug 22, 2014
@lukaseder
[#1658] Fixed compilation issues
278aa65
@lukaseder lukaseder mentioned this issue Oct 5, 2014
Closed
lukaseder added a commit that referenced this issue Oct 30, 2014
@lukaseder
[#1658] Fixed unit tests
bcd4e9e
lukaseder added a commit that referenced this issue Nov 20, 2014
@lukaseder
[#1658] Correct placement of TOP clause with respect to synthetic par…
c372ed9 
…entheses placed around <query expression body>
lukaseder added a commit that referenced this issue Nov 21, 2014
@lukaseder
[#1658] Fixed trailing LIMIT clauses for more sophisticated nested se…
9d97cc7 
…lects to prevent issues in DB2
arnaudroger pushed a commit to arnaudroger/jOOQ that referenced this issue Dec 16, 2014
@lukaseder @arnaudroger
[jOOQ#1658] Correct placement of TOP clause with respect to synthetic…
c1304ce 
… parentheses placed around <query expression body>
arnaudroger pushed a commit to arnaudroger/jOOQ that referenced this issue Dec 16, 2014
@lukaseder @arnaudroger
[jOOQ#1658] Fixed trailing LIMIT clauses for more sophisticated neste…
cb5e8c0 
…d selects to prevent issues in DB2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C: Functionality P: Medium R: Fixed T: Enhancement
Projects
None yet
Milestone
Version 3.5.0
Development

No branches or pull requests
1 participant
@lukaseder