Kbase P123425: SQL-92 query using formula crashes _SQLSRV2.EXE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/03/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
Windows
SYMPTOM(s):
Executing SQL query crashes _SQLSRV2.EXE
Query returns the result of a SUM function
SELECT
SUM((table1.field1 + table1field2) / table2.field3)
FROM
PUB.table1,
PUB.table2
ODBC trace log file shows point of failure in 10.1x:
sqlcon32 1998-2c68 ENTER SQLFetch
HSTMT 00D11FD0
sqlcon32 1998-2c68 EXIT SQLFetch with return code -1 (SQL_ERROR)
HSTMT 00D11FD0
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. (7503)
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. (7503)
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. (7503)
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. (7503)
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. (7503)
DIAG [S1000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server crash likely. (-4)
ODBC trace log file shows point of failure in 9.1E04:
sqlcon32 380-2070 ENTER SQLFetch
HSTMT 00D11FF0
sqlcon32 380-2070 EXIT SQLFetch with return code -1 (SQL_ERROR)
HSTMT 00D11FF0
DIAG [S1000] [DataDirect][ODBC PROGRESS driver][PROGRESS]-20217 (-20217)
Query executes correctly on IBM AIX 5.3
Problem does not occur when using the JDBC driver
CAUSE:
Bug# OE00148938
FIX:
Upgrade to 10.1C or later