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