Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

\d command fails if the schema is provided explicitly #2846

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

\d command fails if the schema is provided explicitly #2846

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
enhancement New feature or request SQL

Comments

@monetdb-team
Copy link

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:

    \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>>

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.

@monetdb-team monetdb-team added enhancement New feature or request SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request SQL
Projects
None yet
Development

No branches or pull requests

2 participants