Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <432061611.452381269401307301.JavaMail.jira@brutus.apache.org>
Date: Wed, 24 Mar 2010 03:28:27 +0000 (UTC)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-2785) ij "describe" built in command cannot
 describe a table named "run"
In-Reply-To: <20220760.1181269406152.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Bryan Pendleton updated DERBY-2785:
-----------------------------------

    Attachment: describeKeywords.diff

Hi Eranda,

Here is a diff with an idea that might be worth pursuing. It changes the
behavior of the DESCRIBE statement so that, in addition to the identifier
or quoted string that it could take before, it now can also take a keyword,
which it then upper-cases and tries to use as a table name.

The patch isn't elegant, but it seems to make 'DESCRIBE RUN' work to
describe a table named 'run'.

If you think this idea has merit, then the next step, I think, would be to
do some more testing, and turn this simple diff into a complete patch
by adding a variety of test cases which show how the new code behaves.

Also, I think some additional work would be needed to be able to describe
a table with the same name as an ij keyword, but in a non-default schema
(as in 'DESCRIBE bryan.run' to describe the table named 'run' in the schema
named 'bryan').

Let me know what you think of this idea.

> ij "describe" built in command cannot describe a table named "run"
> ------------------------------------------------------------------
>
>                 Key: DERBY-2785
>                 URL: https://issues.apache.org/jira/browse/DERBY-2785
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.2.2.0
>         Environment: OS-X, Java 1.5
>            Reporter: Tim Halloran
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>         Attachments: describeKeywords.diff, step logs.txt
>
>
> steps to duplicate:
> (attach ij to any database)
> ij> create table run (i int);
> 0 rows inserted/updated/deleted
> ij> desc run;
> ERROR 42X01: Syntax error: Encountered "desc" at line 1, column 1.
> ij> 
> I think this is a parser problem within ij where the "run" is taken as a token and that token is not included in the definition of a tablename expression in the grammer (should be an easy fix).

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