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

JPQL || operator for string concatenation #397

Closed
gavinking opened this issue Apr 18, 2023 · 0 comments · Fixed by #418
Closed

JPQL || operator for string concatenation #397

gavinking opened this issue Apr 18, 2023 · 0 comments · Fixed by #418
Projects
3.2.0

Comments

@gavinking
Copy link
Contributor

JPQL has a concat() function. It would be nice to also allow the SQL-style || operator.
gavinking added a commit to gavinking/jpa-api that referenced this issue May 25, 2023
@gavinking
Add || string concatenation operator
1c955d8 
See jakartaee#397
@gavinking gavinking mentioned this issue May 25, 2023
Merged
@rfelcman rfelcman mentioned this issue Jun 1, 2023
Closed
5 tasks
@rfelcman rfelcman mentioned this issue Jun 20, 2023
Merged
@lukasj lukasj linked a pull request Jul 11, 2023 that will close this issue
Add || string concatenation operator #418
Merged
rfelcman added a commit to eclipse-ee4j/eclipselink that referenced this issue Jul 17, 2023
@rfelcman
New JPQL 3.2 and || as a String concat operator (#1903)
9cb4c43 
This commit contains following changes:

    New JPQL Grammar 3.2 (version matches upcoming Jakarta Persistence 3.2) and EclipseLink JPQL Grammar 4.1
    New JPQL String expression category with related classes (like arithmetic expression)
    New JPQL String operator || for string concatenation like JPQL CONCAT(....) function
    Tests are available in JPQL parser and JPA JSE test module
    EclipseLink issue is described at 

Implement new JPQLGrammar for upcoming Jakarta Persistence 3.2 #1885 and JPA specification request at the JPQL || operator for string concatenation jakartaee/persistence#397
|| operator is handled at JPQL level, but translated into SQL function CONCAT(...) as not every database supports || or is mentioned as OR logical operator (MySQL).

Signed-off-by: Radek Felcman <radek.felcman@oracle.com>
@lukasj lukasj added this to To do in 3.2.0 via automation Aug 4, 2023
@lukasj lukasj moved this from To do to Done in 3.2.0 Aug 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
3.2.0
Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add || string concatenation operator gavinking/jpa-api
1 participant
@gavinking