Bugs item #2779462, was opened at 2009-04-23 14:30 Message generated for change (Comment added) made by stmane 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: Milena Ivanova (mivanova) 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: Stefan Manegold (stmane) Date: 2009-11-07 16:59 Message: The test still fails as reported on Darwin (MacOS X), Debia, 32-bit Fedora 10, SunOS (Solaris) & Windows: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Darwin9.8.0/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.32.32.d.1-Debian4.0/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.32.32.d.1-Fedora10/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.32.32.d.1-SunOS5.10/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-SunOS5.10/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-SunOS5.10/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-SunOS5.11/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.32.32.d.1-Windows5.1/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.64.32.d.1-Windows6.0/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.64.64.d.1-Windows6.0/src_test_BugTracker-2009/table-leftovers.SF-2779462.out.00.html On 64-bit Fedora 10, Fedora 11 & Gentoo, the test (now?) produced the expected results, but (also) triggers a "weird" or empty error message: weird: ERROR = !ERROR: Optimizer '`ږ?' does not exist, use default pipe instead empty: ERROR = ! http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.32.d.1-Fedora10/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.0-Fedora10/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.64.32.d.1-Fedora10/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/Int.64.64.d.1-Fedora10/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.32.32.d.1-Fedora11/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Gentoo2.0.1/src_test_BugTracker-2009/table-leftovers.SF-2779462.err.00.html ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-08-11 00:15 Message: added test as: sql/src/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql with hand-crafted output (it still fails) ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-04-27 11:36 Message: I can reproduce this one, both with the Feb2009-SP2 code base and with this mornings CVS HEAD: It works by default, i.e., with the following optimizers activated: Feb2009-SP2: sql>select optimizer; 0 tuples +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | single_value | +===============================================================================================================================================================================+ | inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,constants,commonTerms,joinPath,accumulators,deadcode,reduce,garbageCollector,dataflow,history,multiplex | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ CVS HEAD: sql>select optimizer; +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | single_value | +===================================================================================================================================================================================+ | inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ but fails as reported when recycle is activated (between deadcode & reduce), i.e., Feb2009-SP2: sql>set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,constants,commonTerms,joinPath,accumulators,deadcode,recycle,reduce,garbageCollector,dataflow,history,multiplex'; CVS HEAD: sql>set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,recycle,reduce,garbageCollector,dataflow,history,multiplex'; This looks as if recycle is too eager caching/recycling update operations (even) across transaction boundaries... ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-04-23 14:57 Message: re-assigned to Mrs. "recycler" --- Milena ;-) ---------------------------------------------------------------------- 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 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
