(it seems my google-fu is weak, as I cant find anything on this subject)
What is the behavior when inserting into a table based on a query on the same table?
For example:
insert into t1 select a,b+1 from t1
will the SELECT part only consider rows the were present before starting this statement? OR will it also consider new rows? If yes, when?
Note that the above is a simplified example. It could be a multitable insert where the SELECT is a join of multiple tables (let's say only one of source tables is also inserted into).
I case different version behave differently, I am interested in 11.2.
Regards,
David