db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suresh Thalamati (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2103) After a Lexical Error due to syntax error , even a simple create table does not work on the same connection.
Date Tue, 21 Nov 2006 00:04:01 GMT
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

        

Mime
View raw message