Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » Jpa UNION and MySql(Parenthesis around SQL expression triggers error)

Show: Today's Messages :: Show Polls :: Message Navigator

Jpa UNION and MySql [message #1095841]

Tue, 27 August 2013 15:50

Rainer Schön

Messages: 2
Registered: November 2012

Junior Member

If the UNION element in a jpa SELECT statement is present, EclipseLink wraps the whole expression in parenthesis:

(SELECT Count(x) FROM Entity x UNION SELECT Count(y) FROM Entity y).

MySql (my version is 5.5) triggers ERROR 1064, when those parenthesis are set. There exists a MySql bug report (#25734) since 2007 for this issue, but obviously they never fixed it.

Has anyone an idea, how to prevent EclipseLink from putting those parenthesis?

Every hint is appreciated.

Thanks.
Rainer

Report message to a moderator

Re: Jpa UNION and MySql [message #1095997 is a reply to message #1095841]

Tue, 27 August 2013 20:44

Rainer Schön

Messages: 2
Registered: November 2012

Junior Member

Found an answer myself. Seems to be Bugzilla bug #378573 reported on 2012-05-05 but not fixed until now. If you came accross the same problem, please vote for it.

Tanks.
Rainer

Report message to a moderator

Previous Topic:	@JoinColumn @Convert
Next Topic:	Criteria API joinList inheritance Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 01:30:39 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter