[ http://issues.apache.org/jira/browse/DERBY-390?page=comments#action_12314415 ]
Suresh Thalamati commented on DERBY-390: ---------------------------------------- By looking at other system procedures and the way JDBC methods takes the table names, it looks like following the second approach is more consistent with other system procedures in Derby. i.e Import/Export should treat schema Names , table Names , Column Names as case sensitive. Because the database automatically translated the SQL identifier into uppercase by the system. All unquoted table names ..etc should be passed in upper case to import/export procedure. Any comments ? > 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
