Kbase P153385: SQL engine crashes when processing cross join with derived tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/09/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL engine crashes when processing cross join with derived tables
_sqlsvr2 process crashes when processing complex query.
Crash occurs whether query is executed through JDBC or ODBC.
Crash occurs whether tables contain data or not.
Windows unhandled exception message is generated ("_sqlsrv2.exe has encountered a problem ...").
Protrace is generated; the fault address is the same every time, but there is nothing in the call stack.
Client program generates messages related to the loss of connection when the server crashes.
FACT(s) (Environment):
Query contains a cross join and several derived tables (aliases for sub-selects).
Windows
OpenEdge 10.1C
CAUSE:
Bug# OE00186839
CAUSE:
Parser does not handle CROSS JOIN syntax with derived tables properly.
FIX:
Upgrade to OpenEdge 10.2A02. If an upgrade is not possible, it may be possible to avoid the problem by restating the query without the cross join.