Icon View Incident Report

Minor Minor
Reported By: Samuel Costa
Reported On: 9/21/2005
For: Version 4.21 Build 10
# 2111 Using a Non-Existent Column in an SQL Query WHERE Clause Does Not Cause an Error

i've been running this query with weird results, the following sql deletes all records from the table. But the weird part is that the field year on table two is a field of type Word so an exception should be raised not delete the entire table.

delete from table1
where code in (select code
               from table2
               where year = A)



Resolution Resolution
Fixed Problem on 9/26/2005 in version 4.21 build 11


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