Bugs item #2776908, was opened at 2009-04-21 01:54
Message generated for change (Comment added) made by skinkie
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: Niels Nes (nielsnes)
Summary: \d doesn't work anymore on tables
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 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
