|Jpa UNION and MySql [message #1095841]
||Tue, 27 August 2013 11:50
| Rainer Schön
Registered: November 2012
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.
Powered by FUDForum
. Page generated in 0.02222 seconds