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-2785) ij "describe" built in command cannot describe a table named "run"
Date Wed, 24 Mar 2010 03:28:27 GMT

     [ 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:
>         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.

View raw message