Reported By: Pedro Silva Reported On: 12/4/2013 For: Version 4.37 Build 3
# 3990Index 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
ResolutionFixed Problem on 12/5/2013 in version 4.38 build 1
Products AffectedDBISAM 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