INFORMIX SERVER / 5725A3900 / E10 - 

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

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.07.2022
28.11.2022
28.11.2022