Skip to content

Update h2 and flyway#1690

Merged
mergify[bot] merged 6 commits intomasterfrom
h2-update
Aug 12, 2022
Merged

Update h2 and flyway#1690
mergify[bot] merged 6 commits intomasterfrom
h2-update

Conversation

@eikek
Copy link
Copy Markdown
Owner

@eikek eikek commented Aug 9, 2022

Sadly it is necessary to fix an existing changeset for H2.

eikek added 4 commits August 12, 2022 16:34
Sadly it is necessary to fix an existing changeset for H2.
In sql 'value' is a reserved word and should not be used (unless
quoted). Postgresql and MariaDB are ok with it, but the new version of
h2 is now complaining.
Unfortunately, the new h2 version has some regressions related to
CTEs. The query selecting the next group failed only for H2 after the
update. The query has been rewritten to not use union on CTE tables.
The weird thing was that the error only occured using bind values and
was not reproducible with "just string" SQL in the h2 console.

The QJobTest are now running on all databases.
@eikek eikek marked this pull request as ready for review August 12, 2022 15:31
@mergify mergify bot merged commit 0d62001 into master Aug 12, 2022
@eikek eikek deleted the h2-update branch August 18, 2022 17:57
@eikek eikek added this to the Docspell 0.39.0 milestone Nov 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant