You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Suresh Thalamati (JIRA)" <de...@db.apache.org> on 2005/07/01 03:57:57 UTC
[jira] Commented: (DERBY-390) Import/export fails with table names that are quoted in SQL like import to table "Order"
[ http://issues.apache.org/jira/browse/DERBY-390?page=comments#action_12314842 ]
Suresh Thalamati commented on DERBY-390:
----------------------------------------
Same patch (derby390.diff) also works fine for 10.1 branch also. Ran Derbyall on 10.1 after applying the patch for a 10.1 client , all tests passed.
> 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
> 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