After a Lexical Error due to syntax error , even a simple create table does not work on the same connection. -----------------------------------------------------------------------------------------------------------------
Key: DERBY-2103 URL: http://issues.apache.org/jira/browse/DERBY-2103 Project: Derby Issue Type: Bug Affects Versions: 10.3.0.0 Reporter: Suresh Thalamati Priority: Minor 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: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira