db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suresh Thalamati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-390) Import/export fails with table names that are quoted in SQL like import to table "Order"
Date Thu, 23 Jun 2005 17:50:23 GMT
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


Mime
View raw message