Bugs item #2779437, was opened at 2009-04-23 12:10 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779437&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: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Niels Nes (nielsnes) Summary: SQL: Temporary table leftovers Initial Comment: It may be related to previous bug-reports. (using todays CVS head) The following works fine (can be run many times): start transaction; CREATE TEMPORARY TABLE y (x int); INSERT INTO y VALUES (13); SELECT * FROM y; DROP TABLE y; rollback; The following doesn't work multiple times (the only difference is that the drop table statement is omitted which shouldn't be necessary for temporary tables): start transaction; CREATE TEMPORARY TABLE y (x int); INSERT INTO y VALUES (13); SELECT * FROM y; rollback; ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-05-13 17:15 Message: Fixed bug. The temporary schema was handled differently in the reset (mvc) code. This is still the case but it first goes through the normal code. Added a test for this bug in src/test/BugTracker-2009/temporary_table_leftover ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-04-25 17:34 Message: See also ID: 2734713 "Temporary table is semi-persistent when transaction fails" https://sourceforge.net/tracker/?func=detail&aid=2734713&group_id=56967&atid=482468 ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-04-23 12:19 Message: Additional info: Running the following query multiple times in separate sessions fails: CREATE TEMPORARY TABLE y (x int); INSERT INTO y VALUES (10); SELECT * FROM y; The table is already known. There are however no records in table y. SELECT * FROM y; yields an empty table. ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-04-23 12:16 Message: Additional info: The following works fine: start transaction; CREATE TABLE y (x int); INSERT INTO y VALUES (10); SELECT * FROM y; rollback; SELECT * FROM y; While the code below doesn't: (it still knows about y after the rollback) start transaction; CREATE TEMPORARY TABLE y (x int); INSERT INTO y VALUES (10); SELECT * FROM y; rollback; SELECT * FROM y; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2779437&group_id=56967 ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
