Kbase P144157: SQL: A query that ran error free under 10.1B03, 10.1C, 10.1C01 crashes ODBC and JDBC clients under 1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/11/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: A query that ran error free under 10.1B03, 10.1C, 10.1C01 crashes ODBC and JDBC clients under 10.1C02 and 10.1C03.
[DataDirect][OpenEdge JDBC Driver]Connection reset ErrorCode=0 SQLState=08S01
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Connection reset
The offending query:
SELECT Count(DISTINCT shipprod) AS nbritem
FROM pub.oeeh oh
INNER JOIN pub.oeel ol
ON oh.cono = ol.cono
AND oh.orderno = ol.orderno
AND oh.ordersuf = ol.ordersuf
WHERE oh.cono = 1000
AND oh.transtype IN ('SO','CS','BR')
AND NOT oh.orderdisp IN ('W','T')
AND NOT ol.specnstype IN ('N','S')
AND shipprod IN (SELECT DISTINCT prod
FROM pub.icsw
WHERE cono = 1000
AND qtybo > 0)
AND (oh.stagecd <= 2
OR (oh.stagecd > 2
AND oh.shipdt > '03/10/2009'))
AND oh.enterdt <= '03/10/2009'
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server crash likely."
//=====================================================
PROGRESS stack trace as of Mon Mar 16 13:24:04 2009
//=====================================================
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 00462EAF 01:00061EAF C:\Progress\OpenEdge101C\bin\_sqlsrv2.exe
Registers:
EAX:00D36130
EBX:00D37100
ECX:00000000
EDX:00D2B45C
ESI:00000000
EDI:00000001
CS:EIP:001B:00462EAF
SS:ESP:0023:01F7E100 EBP:01F7E1DC
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010206
Call Stack:
Address Frame
00462EAF 01F7E1DC sqld_free+321DF
00463C87 01F7E3D0 sqld_free+32FB7
004C0AD6 01F7E610 tpe_print_sqlda_var+1ED36
004C145F 00D3B980 tpe_print_sqlda_var+1F6BF
FACT(s) (Environment):
OpenEdge 10.1C02 Service Pack
OpenEdge 10.1C03 Service Pack
OpenEdge 10.2A
All Supported Operating Systems
CAUSE:
Bug# OE00182153
CAUSE:
The bug was introduced in OpenEdge 10.1C02 by incorrectly reordering the index predicate list while building the query plan for the resolution of the query.
FIX:
Upgrade to OpenEdge 10.1C04 or later.