Bugs item #2995671, was opened at 2010-05-03 02:48 Message generated for change (Settings changed) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2995671&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Core Group: MonetDB5 CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: zeuner (zeuner) >Assigned to: Martin Kersten (mlkersten) Summary: opt_reorder intermixing sql.bind with sql update instruction Initial Comment: Using SQL/MonetDB5 compiled from a 20100501 checkout, I noticed that the change introduced with [1] led to sql.bind and sql.append MAL instructions being intermixed by opt_reorder. In the attached SQL test, this leads to a primary key violation because the inserted data is checked for collisions with the table after the insertion has taken place. The attached fix prevents this from happening by having update instructions "depend" on all the sql.bind instructions that were invoked earlier. [1] http://monetdb.cvs.sourceforge.net/viewvc/monetdb/MonetDB5/src/optimizer/opt_support.mx?r1=1.115&r2=1.116 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2995671&group_id=56967 ------------------------------------------------------------------------------ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
