logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
epf  
#1 Posted : Wednesday, May 13, 2015 10:05:07 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
From the 1.7 version, you may got the following error in ORACLE: 'not a group by expression' for SQL that were fine in 1.6
Actually the difference is that by default the 'SELECT DISTINCT' is used to build up the SQL,
this seems to cause problem with ORACLE when the query contains functions and the ORDER BY is used (which is the default).

it looks like a bug in old ORACLE version as it does not occur in the last version...

The simple workaround to avoid this is the edit the Select property of your model and change the 'SELECT DISTINCT' to 'SELECT'

For the next release, we are considering to use the DISTINCT by default only if there is no GROUP BY (it should make sense).

Edited by user Wednesday, May 13, 2015 2:26:03 PM(UTC)  | Reason: Not specified

Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.