Bug #2937
improved sequence support in H2
0%
History
#1 Updated by Ovidiu Maxiniuc over 8 years ago
The H2 database engine is active developed. Starting at version 1.3.176 (2014-04-05) it fixes support for MINVALUE, MAXVALUE and CYCLE for sequences, after it was added in version 1.3.175 (2014-01-18).
The current implementation is based on an older version (1.3.169) that had only basic sequence support. Switching to a new version would greatly simplify the H2SequenceHandler class by removing client-side code that handles needed features that were missing in H2 at that time.
The version 1.4 is in beta phase for some time now and will probably be soon released as stable (I could not find an estimated date on their roadmap). Porting to the new version might be necessary.
#2 Updated by Eric Faulhaber about 8 years ago
- Target version set to Milestone 11
#3 Updated by Greg Shah about 8 years ago
Wrong task was edited.
#4 Updated by Greg Shah about 8 years ago
I edited the wrong task, sorry.
#5 Updated by Eric Faulhaber about 8 years ago
- Target version deleted (
Milestone 11)
I am removing this issue from M11. The existing sequence support works fine with H2 1.4, this is just a matter of changing that implementation to take advantage of the new sequence support, but it is not mandatory. Also, H2 is only used as a temp-table database in the customer's code -- it is not a supported, external database, so sequence use does not even come into play.