Bugs item #2776908, was opened at 2009-04-21 01:54
Message generated for change (Comment added) made by mlkersten
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 "stable"
>Status: Closed
>Resolution: Wont Fix
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: Martin Kersten (mlkersten)
Date: 2009-07-20 20:24
Message:
Given the fact that reorder seems to be the cause, this bug is related to
#2770608
----------------------------------------------------------------------
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
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
