Icon View Incident Report

Minor Minor
Reported By: Oliver Bock
Reported On: 7/18/2005
For: Version 4.21 Build 3
# 2085 Executing UNION ALL With Mixed Blob and Character Columns Causes an AV

Running the SQL below causes DBSys to disappear (and my application to crash).

create table "\Memory\A" (vc varchar(50));
create table "\Memory\B" (mem memo);
insert into "\Memory\B" values('blah');
select vc 
from "\Memory\A"
union all 
select mem 
from "\Memory\B"



Comments Comments and Workarounds
The workaround is to not mix and match BLOB columns with non-BLOB columns in UNION ALL queries.


Resolution Resolution
Fixed Problem on 7/20/2005 in version 4.21 build 7


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image