Consider a query of the form UPDATE <table1> SET <field1> = (SELECT <field2> FROM <table2> WHERE <field3> != 0) WHERE <field4> = <value>;
If both tables are native tables, the function selectAddSubqueryTypeInfo() gets called exactly once for the subquery. However, if both tables are virtual tables, the function will be called more than once and the assertion will fail. It does not matter if the virtual tables are created/connected by SELECTING from them before the update or not. Everything seems to be working fine if the function returns WRC_Continue instead of aborting when called again. ________________________________ Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 - 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
