Bugs item #2776908, was opened at 2009-04-21 01:54
Message generated for change (Settings changed) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2776908&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: Stefan de Konink (skinkie)
>Assigned to: Martin Kersten (mlkersten)
>Summary: \d <table> doesn't work with `mserver5 --optimizers`
Initial Comment:
sql>\d
+--------------+
| name |
+==============+
| args |
| auths |
| columns |
| db_user_info |
| functions |
| idxs |
| keycolumns |
| node_tags |
| nodes_legacy |
| privileges |
| relations |
| schemas |
| sequences |
| tables |
| triggers |
| types |
| user_role |
| users |
| way_nds |
| way_tags |
| ways |
+--------------+
21 tuples
sql>\d triggers
Table sys.triggers does not exist.
[Latest CVS]
When started a new database \d args works, while \d args hangs for me after
type_scale.
sql>\d args
CREATE TABLE "sys"."args" (
"id" int,
"func_id" int,
"name" varchar(256),
"type" varchar(1024),
"type_digits" int,
"type_scale" int,
"number" int
);
sql>bash-3.2$ /export/scratch1/konink/monetdb-head/bin/mclient -H -lsql -p
50005
sql>\d args
CREATE TABLE "sys"."args" (
"id" int,
"func_id" int,
"name" varchar(256),
"type" varchar(1024),
"type_digits" int,
"type_scale" int,
Disabling reorder seems to fix the issue.
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-04-25 18:40
Message:
added test in
sql/src/test/BugTracker-2009/Tests/Attic/dumping_tables.SF-2776908* in
three variants:
1) mserver5 started withou further options (default)
(did and does work fine)
2) mserver5 started with --performance
(works fine with post Feb2009-SP2 CVS code base)
3) mserver5 srated with --optimizers
(still fails as reported)
(did not test any other mserver5 commandline options)
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-04-24 17:42
Message:
Traced back to the --performance flag.
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-04-22 16:48
Message:
Probably related:
sql>create table node_tags (id integer);
0 tuples
sql>select * from node_tags;
0 tuples
0 tuples
sql>insert into node_tags values (1);
0 tuples
Rows affected 1
sql>select * from node_tags;
0 tuples
+----+
| id |
+====+
| 1 |
+----+
1 tuple
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-04-21 12:34
Message:
With reorder off \d results in 'nothing'. For the affected database.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2776908&group_id=56967
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
