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 "Jeffrey Aguilera (JIRA)" <de...@db.apache.org> on 2005/10/07 01:10:52 UTC

[jira] Created: (DERBY-607) Parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE should not be case sensitive

Parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE should not be case sensitive
----------------------------------------------------------------------------------

         Key: DERBY-607
         URL: http://issues.apache.org/jira/browse/DERBY-607
     Project: Derby
        Type: Bug
    Versions: 10.1.1.0    
 Environment: Java 1.5.0_04 on Windows Server 2003 Web Edition
    Reporter: Jeffrey Aguilera


The schema and table name parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE are case sensitive, contrary to normal SQL conventions.

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


[jira] Resolved: (DERBY-607) Parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE should not be case sensitive

Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-607?page=all ]
     
Rick Hillegas resolved DERBY-607:
---------------------------------

    Resolution: Fixed

This is because the arguments to procedures are data values (in this case Strings) rather than SQL identifiers. In SQL-speak, they behave like quoted identifiers, not unquoted identifiers. The arguments to system procedures obey the same rules which govern arguments to user-created functions and procedures.

> Parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE should not be case sensitive
> ----------------------------------------------------------------------------------
>
>          Key: DERBY-607
>          URL: http://issues.apache.org/jira/browse/DERBY-607
>      Project: Derby
>         Type: Bug
>     Versions: 10.1.1.0
>  Environment: Java 1.5.0_04 on Windows Server 2003 Web Edition
>     Reporter: Jeffrey Aguilera

>
> The schema and table name parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE are case sensitive, contrary to normal SQL conventions.

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


[jira] Updated: (DERBY-607) Parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE should not be case sensitive

Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-607?page=all ]

Rick Hillegas updated DERBY-607:
--------------------------------

    Component: SQL

Assigning this to SQL component.

> Parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE should not be case sensitive
> ----------------------------------------------------------------------------------
>
>          Key: DERBY-607
>          URL: http://issues.apache.org/jira/browse/DERBY-607
>      Project: Derby
>         Type: Bug

>   Components: SQL
>     Versions: 10.1.1.0
>  Environment: Java 1.5.0_04 on Windows Server 2003 Web Edition
>     Reporter: Jeffrey Aguilera

>
> The schema and table name parameters to SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE are case sensitive, contrary to normal SQL conventions.

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