Informix Bug? error -360
I am trying to run this statement with Informix 7.10:
INSERT INTO a
SELECT 1, b.* FROM b
B is view that is a join between table A and another. When
this statement is run, I get this error:
-360: Cannot modify table or view used in subquery.
Of course the text of the error is correct (the view _is_
readonly), but I'm not updating the view, so why does it
care?
Of course there are workarounds, but is this a fug or a
beature?
--
Robert M. Read
rread@ic.net