db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suresh Thalamati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-437) SYSCS_UTIL.SYSCS_COMPRESS_TABLE does not work on tables that are created with delimited identifier names.
Date Fri, 01 Jul 2005 22:11:58 GMT
SYSCS_UTIL.SYSCS_COMPRESS_TABLE  does not work  on tables that are created with delimited identifier
names.
-----------------------------------------------------------------------------------------------------------

         Key: DERBY-437
         URL: http://issues.apache.org/jira/browse/DERBY-437
     Project: Derby
        Type: Bug
  Components: SQL  
    Versions: 10.0.2.2    
    Reporter: Suresh Thalamati
     Fix For: 10.2.0.0


COMPRESS_TABLE procedure forms SQL statement undeneath,  so if  the user does not pass quoted
names , it is not working with delimited table/schema names..

eg: create table "Order"(a int ) ;

ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP' , 'Order'  ,1) ;
ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at
line 1, column 17.' was thrown while evaluating an expression.
ERROR 42X01: Syntax error: Encountered "Order" at line 1, column 17.
With quoted names it works fine.
ij> call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP' , '"Order"'  ,1) ;
0 rows inserted/updated/deleted

If  it is  expected that  user to pass quoted names for SYSCS_UTIL.SYSCS_COMPRESS_TABLE, then
it is ok.
But doc is not clear:

COMPRESS_TABLE doc in the reference manual:
TABLENAME
   An input argument of type VARCHAR(128) that specifies the table name
   of the table. The string must exactly match the case of the table
   name, and the argument of "Fred" will be passed to SQL as the
   delimited identifier 'Fred'. Passing a null will result in an error.

So either doc has to be fixed or code needs to be fixed to handle  quoted names for compress
table.

I think the code has to fixed to be consistent with other system procedures. .  i.e
If you  created a schema, table or column name as a non-delimited identifier, you must pass
the name in all upper case. If you created a schema, table or column name as a delimited identifier,
you must pass the name in the same case as it was created.

For example:
create table "Order"(a int ) ;
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP' , 'Order'  ,1) ;

create table t1( a int ) 
call SYSCS_UTIL.SYSCS_COMPRESS_TABLE('APP' , 'T1'  ,1) ;





-- 
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