db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2785) ij "describe" built in command cannot describe a table named "run"
Date Thu, 18 Mar 2010 10:42:27 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12846832#action_12846832

Knut Anders Hatlen commented on DERBY-2785:

I think what Sylvain said above is correct. Also, the reason why "create table run(a int)"
does not fail, is that everything that does not match ij's grammar, is believed to be SQL
and passed on to the JDBC driver as it is. That's the same thing that's happens with "describe
run", by the way. It is not recognized as an ij command, so it's executed as an SQL statement
instead, and fails because Derby's SQL does not support DESCRIBE statements.

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