Skip to content

Invalid migration script for H2 #4390

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
Closed
PascalSchumacher opened this issue May 31, 2023 · 0 comments
Closed

Invalid migration script for H2 #4390

PascalSchumacher opened this issue May 31, 2023 · 0 comments
Labels
for: backport-to-5.0.x Issues that will be back-ported to the 5.0.x line in: core type: bug
Milestone
5.1.0-M1

Comments

@PascalSchumacher
Copy link
Contributor

PascalSchumacher commented May 31, 2023 •
edited
Loading

Bug description
In the 5.0 migration-h2.sql the lines 8-10 seem to be invalid. When used with h2 2.1.214 (version managed by Spring Boot 3.1.0) it fails with:

Syntax error in SQL statement "ALTER TABLE BATCH_JOB_EXECUTION_PARAMS [*]MODIFY COLUMN TYPE_CD PARAMETER_TYPE VARCHAR(100)"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
ALTER TABLE BATCH_JOB_EXECUTION_PARAMS MODIFY COLUMN TYPE_CD PARAMETER_TYPE VARCHAR(100) [42001-214] [Failed SQL: (42001) ALTER TABLE BATCH_JOB_EXECUTION_PARAMS MODIFY COLUMN TYPE_CD PARAMETER_TYPE VARCHAR(100)]
@PascalSchumacher PascalSchumacher added status: waiting-for-triage Issues that we did not analyse yet type: bug labels May 31, 2023
@woniper woniper mentioned this issue Jun 4, 2023
Closed
@fmbenhassine fmbenhassine added in: core for: backport-to-5.0.x Issues that will be back-ported to the 5.0.x line and removed status: waiting-for-triage Issues that we did not analyse yet labels Jun 13, 2023
@fmbenhassine fmbenhassine added this to the 5.1.0 milestone Jun 13, 2023
@fmbenhassine fmbenhassine modified the milestones: 5.1.0, 5.1.0-M1 Jul 17, 2023
fmbenhassine pushed a commit that referenced this issue Jul 17, 2023
@woniper @fmbenhassine
Update migration-h2.sql script to use ALTER instead of MODIFY
26fc7ba 
Resolves #4390

(cherry picked from commit 37fb3f9)
@fmbenhassine fmbenhassine mentioned this issue Jul 17, 2023
Closed
@fmbenhassine fmbenhassine changed the title 5.0 migration-h2.sql script invalid Invalid migration script for H2 Jul 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
for: backport-to-5.0.x Issues that will be back-ported to the 5.0.x line in: core type: bug
Projects
None yet
Milestone
5.1.0-M1
Development

No branches or pull requests
2 participants
@fmbenhassine @PascalSchumacher