db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-390) Import/export fails with table names that are quoted in SQL like import to table "Order"
Date Fri, 24 Jun 2005 21:34:57 GMT
    [ http://issues.apache.org/jira/browse/DERBY-390?page=comments#action_12314426 ] 

Satheesh Bandaram commented on DERBY-390:
-----------------------------------------

I agree with the suggestion for system procedures to treat arguments as case sensitive. This
has the unwanted side-effect of requiring users to provide table/column names (unquoted identifiers)
in upper case while calling system procedures and hence should be documented clearly. Can
we add the documentation, where applicable, for 10.1 manuals?

This should also go into release notes, I think.

> 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