Kbase P110419: Error (6242) when a WHERE clause uses unknown value
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/11/2005 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Error (6242) when a WHERE clause uses unknown value
Only comparison operators are allowed with NULL values. (6242)
Error also appears when querying with BEGINS <variable> when the variable is unknown (?)
Error does not occur against a Progress database
It works fine against an Oracle database using the DataServer for Oracle
CAUSE:
Enhancement request# 20051102-011
CAUSE:
This is expected behavior.
When you use the unknown value in a WHERE clause with the DataServer, the unknown value satisfies only the equals (=) or not equal (<>) operator.
FIX:
This enhancement has not been implemented in the product.