[
https://issues.apache.org/jira/browse/DERBY-2103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465942
]
Dag H. Wanvik commented on DERBY-2103:
--------------------------------------
I looked at this, the fix will work, but it seems to me this might
be an bug in JavaCC and should be fixed there; why isn't this
state flag reset by the (generated) ReInit method(s)?
I didn't find any issue in JavaCC's bug database and
I also looked at the source of JavaCC and it is never generates a
reset on reinitialization; so it might be worth raising the issue with
the JavaCC folks..
> After a Lexical Error due to syntax error , even a simple create table
> does not work on the same connection.
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2103
> URL: https://issues.apache.org/jira/browse/DERBY-2103
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.0.0
> Reporter: Suresh Thalamati
> Assigned To: Mayuresh Nirhali
> Priority: Minor
> Fix For: 10.2.3.0, 10.3.0.0
>
> Attachments: derby2103.diff, derby2103_v2.diff
>
>
> connect 'jdbc:derby:wombat;create=true';
> create table t1(a int ) ;
> create table "t2"(a int ) ;
> -- this should fail.
> create table foo (a int , \"YEAR\" int ) ;
> -- but this should not fail. But failing
> create table t4 ( b int ) ;
> FYI:
> $ java org.apache.derby.tools.ij
> ij version 10.3
> ij> run 'weird1.sql';
> ij> connect 'jdbc:derby:wombat;create=true';
> ij> create table t1(a int ) ;
> 0 rows inserted/updated/deleted
> ij> create table "t2"(a int ) ;
> 0 rows inserted/updated/deleted
> ij> -- this should fail.
> create table foo (a int , \"YEAR\" int ) ;
> ERROR 42X02: Lexical error at line 2, column 28. Encountered: "\\" (92),
> after
> : "".
> ij> -- but this should not fail. But failing
> create table t4 ( b int ) ;
> ERROR 42X01: Syntax error: Encountered "" at line 2, column 21.
> ij>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
