Bugs item #2776908, was opened at 2009-04-21 01:54
Message generated for change (Settings changed) 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-11-15 15:32
Message:
\d should not cause problems (anymore). It is firing an ordinary SQL
query.
The test output has been checked (it seems), all green.
Closing without new test.
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-08-13 19:32
Message:
re-opened as the respective test still fails; cf.,
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2009/dumping_tables.SF-2776908--optimizers.out.00.html
the reorder optimizer is no longer activated by default; hence, that
cannot be the problem.
In case "\d" is not supposed to work with --optimizers given on the
mserver5 command line, then we should document that, possibly add a
notification and approve the expected output as "correct".
----------------------------------------------------------------------
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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
