Bugs item #2734713, was opened at 2009-04-05 16:17
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2734713&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: SQL CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: Temporary table is semi-persistent when transaction fails
Initial Comment:
verywrong.sql:
START TRANSACTION;
CREATE TEMPORARY TABLE persistent_temopary (id integer);
blabla;
COMMIT;
verywrong2.sql:
drop table persistent_temopary;
bash-3.2$ /export/scratch1/konink/monetdb-head/bin/mclient -H -lsql -p 50005 <
verywrong.sql
MAPI = mone...@localhost:50005
QUERY = blabla;
ERROR = !syntax error, unexpected IDENT in: "blabla"
MAPI = mone...@localhost:50005
QUERY = COMMIT;
ERROR = !COMMIT: failed
!ERROR: COMMIT: transaction is aborted, will ROLLBACK instead
bash-3.2$ /export/scratch1/konink/monetdb-head/bin/mclient -H -lsql -p 50005 <
verywrong.sql
MAPI = mone...@localhost:50005
QUERY = CREATE TEMPORARY TABLE persistent_temopary (id integer);
ERROR = !CREATE TABLE: name 'persistent_temopary' already in use
MAPI = mone...@localhost:50005
QUERY = blabla;
ERROR = !current transaction is aborted (please ROLLBACK)
MAPI = mone...@localhost:50005
QUERY = COMMIT;
ERROR = !COMMIT: failed
!ERROR: COMMIT: transaction is aborted, will ROLLBACK instead
bash-3.2$ /export/scratch1/konink/monetdb-head/bin/mclient -H -lsql -p 50005 <
verywrong2.sql
MAPI = mone...@localhost:50005
ACTION= read_line
QUERY = drop table persistent_temopary;
ERROR = Connection terminated
>mserver5: ../../../src/storage/store.mx:3071: sys_drop_table: Assertion `rid
>!= -1' failed.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-05-13 17:24
Message:
Test added to
src/test/BugTracker-2009/Tests/temporary_table_leftover.SF-2734713.sql
The reset_schema now correctly removes tables/views created in the the
last failed transaction
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-04-25 17:34
Message:
See also
ID: 2779437 "SQL: Temporary table leftovers"
https://sourceforge.net/tracker/?func=detail&aid=2779437&group_id=56967&atid=482468
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2734713&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
