Kbase P133111: Using character expressions for JOIN fields not supported in SQL-92 implementation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/28/2008 |
|
Status: Unverified
SYMPTOM(s):
When using a character expression to join two tables in Progress' implementation of SQL-92 it is possible that the index for the inner query could be scanned once for each iteration of the outer query
Index scans in select statement
FACT(s) (Environment):
Character expressions in SQL queries
SuSe Enterprise Server 9
OpenEdge 10.1B
CAUSE:
Using character expressions for JOIN fields is not supported in OE SQL-92 implementation. This is simply not expected to effectively join the two tables and is likely to end up scanning more data than is necessary.
FIX:
Create real fields in the subject tables to store the join data