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.
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