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: <34243140.1121216172770.JavaMail.jira@ajax.apache.org>
Date: Wed, 13 Jul 2005 02:56:12 +0200 (CEST)
From: "Suresh Thalamati (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (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=all ]
     
Suresh Thalamati resolved DERBY-390:
------------------------------------

    Fix Version: 10.1.1.0
                 10.2.0.0
     Resolution: Fixed

patch was committed to 10.1 branch wiith svn  208776
patch was committed to 10.2 (main)  branch wiith svn  208770


> 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
>     Assignee: Suresh Thalamati
>      Fix For: 10.1.1.0, 10.2.0.0
>  Attachments: derby390.diff
>
> 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