>> I observe a difference in results of a DELETE query using the EXISTS >> operator between Sqlite version 3.8.11.1 and 3.9.0. > > Thanks for the bug report. > > Ticket: https://www.sqlite.org/src/info/dc6ebeda9396087 > Candidate fix: https://www.sqlite.org/src/info/3f221f592a9a1900 > -- > Richard Hipp > drh at sqlite.org
Thanx for solving this issue so quickly. We integrated the fix and we get the expected results. I guess that the fact that the behavior of sqlite was updated to the old behavior also answers my question how my query should be interpreted according to the SQL standard: EXISTS and subqueries should operate on the original (unmodified) tables, not on the (partly) updated table. Met Vriendelijke Groet, Kind Regards, Rob Golsteijn
