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 native support for H2's new UNIQUE predicate #8732

Closed
lukaseder opened this issue Jun 4, 2019 · 2 comments
Closed

Add native support for H2's new UNIQUE predicate #8732

lukaseder opened this issue Jun 4, 2019 · 2 comments
Labels
C: DB: H2 C: Functionality E: All Editions P: Medium R: Fixed T: Enhancement
Projects
3.14 Other improvements
Milestone
Version 3.14.0

Comments

@lukaseder
Copy link
Member

H2 added support for the SQL standard UNIQUE predicate: h2database/h2database#1969

Once this is released, we'll generate native support for this predicate as well in jOOQ.
@knutwannheden
Copy link
Contributor

This will then also allow us to run one of our integration tests again on our side.

knutwannheden added a commit that referenced this issue Jun 6, 2019
@knutwannheden
[#8732] H2: Fix DSL#week() implementation
6dfd51a 
For H2 the DSL#week() function should be mapped to the ISO_WEEK()
function as EXTRACT(WEEK FROM ...) is equivalent to the WEEK() function.
@lukaseder lukaseder added this to To do in 3.14 Other improvements via automation Aug 21, 2020
@lukaseder lukaseder moved this from To do to In progress in 3.14 Other improvements Aug 21, 2020
@lukaseder
Copy link
Member Author

This will then also allow us to run one of our integration tests again on our side.

Yes, testPredicates_UNIQUE_Correlated() now passes, when I implement native UNIQUE predicate support.

lukaseder added a commit that referenced this issue Aug 21, 2020
@lukaseder
[#8732] Add native support for H2's new UNIQUE predicate
ac51689
3.14 Other improvements automation moved this from In progress to Done Aug 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C: DB: H2 C: Functionality E: All Editions P: Medium R: Fixed T: Enhancement
Projects
No open projects
3.14 Other improvements
  
Done
Milestone
Version 3.14.0
Development

No branches or pull requests
2 participants
@knutwannheden @lukaseder