Loading...
Loading...
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".
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
PRB674204
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.