Seal Report Forum
»
Troubleshooting
»
Bug Reports
»
1.7: SELECT DISTINCT and GROUP BY error in ORACLE
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  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
|
|
|
|
|
|
Seal Report Forum
»
Troubleshooting
»
Bug Reports
»
1.7: SELECT DISTINCT and GROUP BY error in ORACLE
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.
