Bugs item #2734713, was opened at 2009-04-05 18:17
Message generated for change (Tracker Item Submitted) made by skinkie
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: Open
Resolution: None
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.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2734713&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
