Informix - Problem description
Problem IT41573 | Status: Closed |
A NON-EXISTENT COLUMN IS NOT DETECTED IN A SUB-QUERY WITH VALID WHERE CONDITION AND SELECT / UPDATE / DELETE CONSIDERS ALL ROWS | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
A non-existent column is not detected if in a sub-query with a valid where condition and the SELECT / UPDATE / DELETE considers the WHERE clause as true i.e. table_a acol1 acol2 acol3 table_b bcol1 bcol2 A query like: SELECT * FROM table_a WHERE acol3 = (SELECT bcol3 FROM table_b WHERE bcol1 = 1); If table_b does have a row that satisfies the WHERE clause bcol1 = 1 then the select on table_a gets all rows on table_a. Same for an UPDATE and/or DELETE, might cause undesirable results It should error and report that there's a non-existent column | |
Problem Summary: | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.07.2022 28.11.2022 28.11.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |