Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Message-ID: <277624307.1119636657986.JavaMail.jira@ajax.apache.org>
Date: Fri, 24 Jun 2005 20:10:57 +0200 (CEST)
From: "Suresh Thalamati (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-390) Import/export  fails   with table names
 that are quoted in SQL  like import  to table  "Order"
In-Reply-To: <1437838598.1119549023657.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

    [ http://issues.apache.org/jira/browse/DERBY-390?page=comments#action_12314415 ] 

Suresh Thalamati commented on DERBY-390:
----------------------------------------

By  looking at other system procedures  and the way JDBC methods takes the table names,    it looks like following  the second approach is more consistent with other system procedures in Derby.   i.e
Import/Export should treat schema Names , table Names , Column Names as case sensitive. Because
the database automatically translated the SQL identifier into uppercase by the system. All unquoted
table names ..etc  should be passed in upper case to import/export procedure. 

Any comments ?
 

> Import/export  fails   with table names that are quoted in SQL  like import  to table  "Order"
> ----------------------------------------------------------------------------------------------
>
>          Key: DERBY-390
>          URL: http://issues.apache.org/jira/browse/DERBY-390
>      Project: Derby
>         Type: Bug
>     Versions: 10.0.2.1
>     Reporter: Suresh Thalamati

>
> import  fails   irrespective off whether the name is passed as  a quoted sttring or not:
> ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, '"ORDER"' , 'order.dat' ,
>                                       null, null, null, 0) ;
> ERROR XIE0M: Table '"ORDER"' does not exist.
> ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ORDER' , 'order.dat' ,
>                                       null, null, null, 0) ;
> ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "ORDER" at
> line 1, column 13.' was thrown while evaluating an expression.
> ERROR 42X01: Syntax error: Encountered "ORDER" at line 1, column 13.
> Export works with  a quoted table name but fails if the name is not quoted :
> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, '"ORDER"' , 'order.dat' ,
>                                  null, null, null) ;   --- PASSES
> ij> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'ORDER' , 'order.dat' ,
>                                  null, null, null) ;
> ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "ORDER" at
> line 1, column 15.' was thrown while evaluating an expression.
> ERROR 42X01: Syntax error: Encountered "ORDER" at line 1, column 15.
> Repro:
> connect 'jdbc:derby:wombat;create=true';
> create table "ORDER"(a int ) ;
> insert into "ORDER" values(1) ;
> insert into "ORDER" values(2) ;
> insert into "ORDER" values(3) ;
> call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, '"ORDER"' , 'order.dat' ,
>                                  null, null, null) ;
> -- Perform Import
> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, '"ORDER"' , 'order.dat' ,
>                                       null, null, null, 0) ;
> ERROR XIE0M: Table '"ORDER"' does not exist.
> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ORDER' , 'order.dat' ,
>                                       null, null, null, 0) ;
> ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "ORDER" at
> line 1, column 13.' was thrown while evaluating an expression.
> ERROR 42X01: Syntax error: Encountered "ORDER" at line 1, column 13.
> Note:  I think  the same problem will occur with  when  quoted schema Names and column names are passed to import/export procedures. 

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