Kbase P117863: SQL-92 query performs TABLE SCAN and SHARE-LOCKs every record searching for an invalid INTEGER.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/18/2011 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 query performs TABLE SCAN and SHARE-LOCK every record.
Query performs a full TABLE SCAN.
Transaction Isolation Level set to Committed Read.
Query holds every record in the table with a SHARE-LOCK.
Query is searching for an invalid INTEGER value against a PRIMARY UNIQUE indexed field.
The value is out of bounds, that is less than -2,147,483,648 or more than 2,147,483,647.
Query is similar to:
SELECT * FROM PUB.Customer WHERE CustNum = '2147483648';
Where CustNum is indexed as PRIMARY UNIQUE and the search value '2147483648' is an illegal INTEGER value.
SQL-92
OpenEdge 10.0B05
OpenEdge 10.1A01
FACT(s) (Environment):
OpenEdge 10.0B
OpenEdge 10.1A
All Supported Operating Systems
CAUSE:
Bug# OE00131129
FIX:
Upgrade to 10.1A02
or
Upgrade to 10.1B