Defect HC-5182
Oracle SQL Error when a Product has more than 1000 SKUs
Software
Customer case | Applies to | Corrected in |
---|---|---|
CS0145240 | V9.0.1.12 | 9.0.1.14 |
Observed behavior
When a product contains more than 1000 skus, the product display page will show an exception similar to the following when using an Oracle database.
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
Expected behavior
Oracle database queries are limited to 1000 entries in their "in" clause.
Resolution
The code was restructured to split up the queries so that all entries can be retrieved without exceeding the 1000 entry limit.