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

BadJpqlGrammarException with attribute 'date' #3092

Closed
m-ignatov opened this issue Aug 2, 2023 · 1 comment
Closed

BadJpqlGrammarException with attribute 'date' #3092

m-ignatov opened this issue Aug 2, 2023 · 1 comment
Assignees
@gregturn
Labels
in: query-parser Everything related to parsing JPQL or SQL type: regression A regression from a previous release
Milestone
3.1.3 (2023.0.3)

Comments

@m-ignatov
Copy link

Could be similar to #3062.

Spring Data JPA throws BadJpqlGrammarException: Line 1:46 no viable alternative at input 'e.embeddedId.date'; Bad JPQL grammar [SELECT e FROM Entity e WHERE e.embeddedId.date BETWEEN :from AND :to]

  @Query("SELECT e FROM Entity e WHERE e.embeddedId.date BETWEEN :from AND :to")
  List<Entity> findAllEntitiesBetween(@Param("from") LocalDate from, @Param("to") LocalDate to);

We are using the latest Spring Boot BOM 3.1.2 with Spring Data JPA 3.1.2.
@spring-projects-issues spring-projects-issues added the status: waiting-for-triage An issue we've not yet triaged label Aug 2, 2023
@gregturn gregturn self-assigned this Aug 2, 2023
@gregturn gregturn added type: regression A regression from a previous release in: query-parser Everything related to parsing JPQL or SQL and removed status: waiting-for-triage An issue we've not yet triaged labels Aug 2, 2023
@gregturn gregturn added this to the 3.1.3 (2023.0.3) milestone Aug 2, 2023
gregturn added a commit that referenced this issue Aug 2, 2023
@gregturn
FROM and DATE should be usable as parameters in JPQL queries.
10c26d2 
See #3092
gregturn added a commit that referenced this issue Aug 2, 2023
@gregturn
FROM and DATE should be usable as parameters in JPQL queries.
34e2331 
See #3092
@gregturn
Copy link
Contributor

gregturn commented Aug 2, 2023

Merged to main and backported to 3.1.x.

@gregturn gregturn closed this as completed Aug 2, 2023
@gregturn gregturn mentioned this issue Aug 28, 2023
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@gregturn gregturn

Labels
in: query-parser Everything related to parsing JPQL or SQL type: regression A regression from a previous release
Projects
None yet
Milestone
3.1.3 (2023.0.3)
Development

No branches or pull requests
3 participants
@gregturn @spring-projects-issues @m-ignatov