Bugs item #1918135, was opened at 2008-03-18 13:10
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1918135&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: Out of Date
Priority: 6
Private: No
Submitted By: Arjen de Rijke (arjenderijke)
Assigned to: Niels Nes (nielsnes)
Summary: Cannot create more than one table
Initial Comment:
After compiling monetdb5 using yesterday's (20080317) source from cvs, the
creation of tables will fail after one table.
If you perform this script:
CREATE TABLE TESTA (
TESTA_ID integer
);
CREATE TABLE TESTB (
TESTB_ID integer
);
using mclient -lsql < testscript.sql
and than connect to the database using mclient -lsql
This query
sql>select * from tables;
will give (as expected):
| 3882 |testa | 985 |null | 0 |false | 0 | 0 |
| 3884 |testb | 985 |null | 0 |false | 0 | 0 |
+------+-------------+------+----------------------+-----+------+------+------+
and
sql>\d testa
CREATE TABLE "sys"."testa" (
"testa_id" int
);
but
sql>\d testb
Table sys.testb does not exist.
similar thing happen if you try to create multiple tables within mclient, of if
you dump the database with mclient -lsql -D
I found this when trying to make a simple testcase to reproduce an error with
foreign key constraint. I now suspect that that error was a symptom of this
problem. So i think this problem is at least a week old.
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-03-25 14:32
Message:
Logged In: YES
user_id=43556
Originator: NO
problem is fixed by disabling the recycler. No tests needed as many sql
create statements exists in the test set.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1918135&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
