We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
INSERT … ON CONFLICT
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
Migrating from Spring Boot 3.3.5 to 3.4 lead to this error
The error
Caused by: org.springframework.data.jpa.repository.query.BadJpqlGrammarException: Line 4:8 mismatched input 'ON' expecting {, ','}; Bad JPQL grammar [ INSERT INTO AggregationPrice(range, price, type) VALUES (:range, :price, :priceType) ON CONFLICT (range) DO UPDATE SET price = :price, type = :priceType ]
The code
@Modifying @Query( """ INSERT INTO AggregationPrice(range, price, type) VALUES (:range, :price, :priceType) ON CONFLICT (range) DO UPDATE SET price = :price, type = :priceType """ ) fun save(range: Range<LocalDateTime>, price: Double, priceType: AggregationPriceType)
The text was updated successfully, but these errors were encountered:
This is a regression. Specifically, the issue that we do not consider the conflict clause is becoming visible by eagerly parsing statements.
Sorry, something went wrong.
CONFLICT
INSERT
34dc005
Consider CONFLICT clause on INSERT in HQL.
d203031
Closes: #3689 Original Pull Request: #3691
mp911de
Successfully merging a pull request may close this issue.
Migrating from Spring Boot 3.3.5 to 3.4 lead to this error
The error
The code
The text was updated successfully, but these errors were encountered: