Icon View Incident Report

Serious Serious
Reported By: Pedro Silva
Reported On: 12/4/2013
For: Version 4.37 Build 3
# 3990 Index Out of Bounds Error with CAST and UNION in SQL SELECT Statement

DBISAM is throwing an error (Index Out of Bounds) with the following query.

select 0 as order, cast(sum(price) as money) as total
from myTable
group by order
union all
select 0, 0 as total
from myTable2



Resolution Resolution
Fixed Problem on 12/5/2013 in version 4.38 build 1


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

Image