[DERBY-390] Import/export fails with table names that are quoted in SQL like import to table "Order"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.1.1.0, 10.2.1.6
• Component/s: Tools
• Assignee: Suresh Thalamati
• Reporter: Suresh Thalamati
• Created: 24/Jun/05 02:45
• Updated: 10/Oct/06 09:31
• Resolved: 13/Jul/05 09:51

Description

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.

Sub-Tasks

• documentation need to be modified to reflect the derby-390 fix(once it is committed) , schem , table , column names need to be in case-sensitive form.: Closed