db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2019) IJ's describe command does not handle quotes very well
Date Sat, 05 May 2007 18:25:15 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Bryan Pendleton updated DERBY-2019:

    Attachment: docs.diff

Attached is docs.diff, with a patch proposal to the
describe page in the tools guide, and the HTML-formatted
version of that page for easier review. Please let me know
what you think of the code and docs change proposals.

> IJ's describe command does not handle quotes very well
> ------------------------------------------------------
>                 Key: DERBY-2019
>                 URL: https://issues.apache.org/jira/browse/DERBY-2019
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions:,
>            Reporter: John H. Embretsen
>         Assigned To: Bryan Pendleton
>            Priority: Minor
>         Attachments: describe_enhancement.diff, docs.diff, rtoolsijcomrefdescribe.html
> In IJ, the describe <table | view> command does not handle quotes very well. Current
behavior is:
> a) Double quotes:
> IJ does not recognize describe command when encountering double quotes.
>     ij> create table "CamelCaseTable" (col1_in_cct int);
>     0 rows inserted/updated/deleted
>     ij> describe "CamelCaseTable";
>     ERROR 42X01: Syntax error: Encountered "describe" at line 1, column 1.
> I'm assuming that it should be possible to execute the describe command on case-sensitive
table names.
> b) Single quotes:
> IJ describes all tables in current schema when encountering two single quotes after the
describe command.
>     ij> create table table1 (col1_table1 int);
>     0 rows inserted/updated/deleted
>     ij> create table table2 (col1_table2 int);
>     0 rows inserted/updated/deleted
>     ij> describe '';
>     ------------------------------------------------------------------------------
>     COL1_TABLE1         |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
>     COL1_TABLE2         |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
>     2 rows selected
> In case b), it does not make a difference whether the single quotes actually surround
a valid table name, some garbage, or nothing at all.
> I must admit that b) seems like a useful feature, listing all columns in all tables in
a schema, but it's usage is not very intuitive, nor is it documented, so this may be a bug.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message