Kbase P124295: SQL: Using the !=, and ^= operators in certain SQL queries may cause 'A server crash is likely' err
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Using the !=, <> and ^= operators in certain SQL queries may cause 'A server crash is likely' error
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=0
[DataDirect][OpenEdge JDBC Driver]A server crash is likely.
Executing an SQL query involving one of the above operators may crash the SQL server and generate a PROGRESS stack trace. For example:
SELECT
SA_COMPANY_NBR
FROM
PUB.SI_AGMT
WHERE
SA_COMPANY_NBR = 36533 AND
SI_ACCT_NBR = 1200 AND
SI_AGMT_ID_NBR != 0;
FACT(s) (Environment):
SuSe Linux 8.0
OpenEdge 10.1B01 32-bit Service Pack
Progress OpenEdge 10.1B driver
CAUSE:
Bug# OE00151690
FIX:
Upgrade to OpenEdge 10.1B02 or later. If
FIX:
Upgrade to OpenEdge 10.1B02 or later. If upgrading to OpenEdge 10.1B02 or later is not feasible, a workaround is to add a additional field that is not in the WHERE clause to the SELECT list. For example:
SELECT
SA_COMPANY_NBR, CS_MEM_NBR
FROM
PUB.SI_AGMT
WHERE
SA_COMPANY_NBR = 36533 AND
SI_ACCT_NBR = 1200 AND
SI_AGMT_ID_NBR != 0;