Description
When performing a simple query against a JDBC Oracle data source, if the query contains a "Group by" clause, the query fails with the error "ORA-00933: SQL Command not properly ended".
Steps to Reproduce
- Create an Oracle JDBC data source with a SQL statement containing a where clause and group by.
For example: select column1, count(*) from table1 where 1=1 group by column1 - Try to load 20 records.
An error message is displayed.
Workaround
Wrap the SQL statement with outer select and also add "where 1=1" at the end of the statement, such as in the following:
select * from (select column1, count(*) from table1 where 1=1 group by column1) where 1=1
Related Problem: PRB674204