Kbase P110712: SQL-92 query with INSERT and SUBSELECT may disconnects database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2005 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 query with INSERT and SUBSELECT disconnects database
"INSERT INTO tbl_test SELECT ID1+2,data1,0,ts1 FROM tbl_test WHERE ID1=1" disconnects database
ErrorCode=30034
JDBC OpenEdge Driver] Unable to connect to server
Error occurs in version 10.0B with Service Pack 1 and 2
The error does NOT occur without Service Pack and with Service Pack 3
CAUSE:
Bug #: 20051110-002
FIX:
upgrade to 10.0B with Service Pack 3