Kbase P69871: Comparing YEAR() or HOUR() functions being equal to ? causes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
OpenEdge 10.0A
SYMPTOM(s):
SELECT statement tests the YEAR() function being equal to ?
SELECT statement tests the HOUR() function being equal to ?
The _SQLSRV2 executable crashes
CAUSE:
The fact that testing for '= ?' causes the server to crash is a bug, however, such a statement is not syntactically correct
FIX:
Modify the SQL statement to test for 'IS NULL' rather than '= ?'