Bugs item #2779462, was opened at 2009-04-23 14:30 Message generated for change (Settings changed) made by vzzzbx You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779462&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: SQL/Core Group: MonetDB5 CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) >Assigned to: Martin Kersten (mlkersten) Summary: SQL: table leftovers Initial Comment: Using todays CVS head. The following sql statements give wrong results (both SELECT yield 1 row with number '10'). Note that without setting the optimizers, it works fine. start transaction; set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,reorder,joinPath,deadcode,recycle,reduce,garbageCollector,dataflow,history,multiplex'; CREATE TABLE y (x int); INSERT INTO y VALUES (10); SELECT * FROM y; rollback; start transaction; CREATE TABLE y (x int); INSERT INTO y VALUES (13); SELECT * FROM y; rollback; ---------------------------------------------------------------------- >Comment By: Wouter Alink (vzzzbx) Date: 2009-04-23 14:47 Message: the 'recycle' optimizer caused the problems. This optimizer has been switched off a while ago apparently. I don't know whether it will be enabled again any time soon, but if so, i assume this bug should stay open. If not, this bug could be postponed or closed. Martin/Milena, could you comment? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779462&group_id=56967 ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
