Bugs item #2776908, was opened at 2009-04-21 01:54
Message generated for change (Comment added) 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 "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: Stefan Manegold (stmane)
Date: 2009-11-15 15:49
Message:
for the records:
the test was failing until it was disabled (on the Nov2009 branch, only):
$ cvs log -Nr1.51.2.5 sql/src/test/BugTracker-2009/Tests/All
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
Working file: sql/src/test/BugTracker-2009/Tests/All
head: 1.58
branch:
locks: strict
access list:
keyword substitution: kv
total revisions: 162; selected revisions: 1
description:
----------------------------
revision 1.51.2.5
date: 2009/11/09 22:22:38; author: nielsnes; state: Exp; lines: +2 -2
disable a few more test (no propagation)
=============================================================================
$ cvs diff -r1.51.2.{4,5} sql/src/test/BugTracker-2009/Tests/All
Index: sql/src/test/BugTracker-2009/Tests/All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
retrieving revision 1.51.2.4
retrieving revision 1.51.2.5
diff -u -r1.51.2.4 -r1.51.2.5
--- sql/src/test/BugTracker-2009/Tests/All 8 Nov 2009 20:11:51
-0000 1.51.2.4
+++ sql/src/test/BugTracker-2009/Tests/All 9 Nov 2009 22:22:38
-0000 1.51.2.5
@@ -58,9 +58,9 @@
missing_column_name.SF-2776100
dumping_tables.SF-2776908
dumping_tables.SF-2776908--performance
-dumping_tables.SF-2776908--optimizers
+#dumping_tables.SF-2776908--optimizers
name_clash_with_dump.SF-2780395
-temporary_table_leftover.SF-2779437
+#temporary_table_leftover.SF-2779437
temporary_table_leftover.SF-2734713
multi-column_join_with_expression.SF-2783279
BOM.SF-2787813
----------------------------------------------------------------------
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
