Kbase 21013: SQL-92 server crashing running SQL-92 command that uses the IN predicate with a lengthy value list
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/10/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1A
Progress 9.1B
SYMPTOM(s):
Error running SQL-92 command that uses the "IN" predicate with a lengthy value list.
The SQL statement has more than 251 values in the "IN" clause.
Error occurs both using SQL explorer or ODBC driver
SQL Errors:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20217
[JDBC Progress Driver]:-20217
ODBC Error: [Merant ODBC progress driver], [Progress]
Server not reachable, or possible RPC error.
CAUSE:
Bug# 20000203-037
FIX:
Upgrade to 9.1B latest patch or later
To work around the problem, put all the elements in a table and then use a select statement for the "IN" set. This syntax assumes that there is a table called "sets" and a field called "element":
SELECT name FROM Pub.customer WHERE custnum in (select element from Pub.sets)