[ http://issues.apache.org/jira/browse/DERBY-390?page=all ]
Rick Hillegas updated DERBY-390: -------------------------------- Component: Tools Assigning to Tools component. > 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 > Components: Tools > 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