JPA (Hibernate) false error for functions such as YEAR and MONTH

Answered

Behrang

Created August 07, 2019 04:05

This JPA query is valid when using Hibernate as the provider:

@Query("SELECT foo FROM Foo foo WHERE YEAR(foo.date) IN ?1")

But in a Spring Boot project, IDEA falsely marks it as an error with this message:

Error:(37, 102) <expression>, <operator>, GROUP, HAVING or ORDER expected, got '('

Is this a bug in IDEA or do I have to do something special to enable it?

5 comments

Behrang

Created August 07, 2019 04:10

Also update the text editor of the forums. It is barely usable.

Replace it with a sophisticated Markdown editor (https://github.com/showdownjs/showdown) and/or a decent WYSIWYG editor (e.g. https://www.froala.com/wysiwyg-editor).

Created August 07, 2019 04:15

@Behrang,

Here is a related bug on YouTrack:

Feel free to comment inside and watch the item in order to be notified once it has updates. See this article if you are not familiar with YouTrack.

Behrang

Created August 07, 2019 05:05

Thanks Konstantin,

Any plans to update the forum's text editor?

Cheers.

Created August 07, 2019 05:20

Unfortunately, we have no control over this forum engine, as it's a third-party hosted solution.

Created November 20, 2021 00:23

Here, another similar issue on YouTrack (this one with coalesce): https://youtrack.jetbrains.com/issue/DBE-14023

Please sign in to leave a comment.