You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
\d[Stvsfn]+ object
Describe the given object in the database using SQL statements
that reconstruct the object. The same specifiers as above can
be used, following the same rules. When no specifiers are
given, vt is assumed. The object can be given with or without a
schema, separated by a dot. The object name can contain the
wildcard characters * and _ that represent zero or more, and
exactly one character respectively. An object name is converted
to lowercase, unless the object name is quoted by double quotes
("). Examples of this, are e.g. *.mytable, tabletype* or
"myschema.FOO". Note that wildcard characters do not work in
quoted objects.
Comment 16056
Date: 2011-07-29 16:59:08 +0200
From: Simon Brodt <<simon.brodt>>
Date: 2011-07-29 16:49:14 +0200
From: Simon Brodt <<simon.brodt>>
To: SQL devs <>
Version: 11.5.3 (Aug2011-SP1) [obsolete]
Last updated: 2012-01-26 15:32:06 +0100
Comment 16054
Date: 2011-07-29 16:49:14 +0200
From: Simon Brodt <<simon.brodt>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0
Build Identifier:
\d command fails if the schema is provided explicitly like in
\d "testschema"."test"
Reproducible: Always
Steps to Reproduce:
sql>CREATE TABLE "test" (id INT);
operation successful
sql>\d "test"
CREATE TABLE "sys"."test" (
"id" INTEGER
);
sql>\d "sys"."test"
table sys"."test does not exist
sql>CREATE SCHEMA "testschema";
operation successful
sql>CREATE TABLE "testschema"."test" (id INT);
operation successful
sql>\d "testschema"."test"
table testschema"."test does not exist
Actual Results:
table does not exist
Expected Results:
description of table
Comment 16055
Date: 2011-07-29 16:52:30 +0200
From: @grobian
this currently is expected behaviour:
Comment 16056
Date: 2011-07-29 16:59:08 +0200
From: Simon Brodt <<simon.brodt>>
oh, sorry
Comment 16057
Date: 2011-07-29 17:01:16 +0200
From: @grobian
It's kind of odd behaviour, so I consider it an enhancement to allow quoting of arbitrary parts of the string passed to \d
Comment 16278
Date: 2011-09-16 15:10:40 +0200
From: @sjoerdmullender
The Aug2011 version has been released.
Comment 16393
Date: 2011-10-11 16:05:55 +0200
From: @grobian
http://dev.monetdb.org/hg/MonetDB/rev/c31533943a6b
Implemented this feature for the next feature release.
Comment 16831
Date: 2012-01-26 15:32:06 +0100
From: @sjoerdmullender
The Dec2011 version has been release, so declaring this bug as FIXED.
The text was updated successfully, but these errors were encountered: