[jira] [Commented] (DERBY-6730) Cannot create a Lucene index if a key column's name is case-sensitive

["Rick Hillegas (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-6730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14126197#comment-14126197 ] 

Rick Hillegas commented on DERBY-6730:
--------------------------------------

Tests passed cleanly for me on derby-6730-01-aa-correctCasing.diff.

> Cannot create a Lucene index if a key column's name is case-sensitive
> ---------------------------------------------------------------------
>
>                 Key: DERBY-6730
>                 URL: https://issues.apache.org/jira/browse/DERBY-6730
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL, Tools
>    Affects Versions: 10.11.1.1, 10.12.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-6730-01-aa-correctCasing.diff
>
>
> The workaround is to create a view which gives the columns case-insensitive names. The following script shows this problem:
> {noformat}
> connect 'jdbc:derby:memory:db;create=true';
> call syscs_util.syscs_register_tool( 'luceneSupport', true );
> create schema "s";
> create table "s"."t"
> (
>     "passageID" int,
>     "text" varchar( 32672 )
> );
> -- fails because the trailing key id is case-sensitive
> call luceneSupport.createIndex
> (
>   '"s"',
>   '"t"',
>   '"text"',
>   null,
>   '"passageID"'
> );
> create view "s"."t_view" ( passageID, text ) as select * from "s"."t";
> -- succeeds on a view with case-insensitive identifiers
> call luceneSupport.createIndex
> (
>   '"s"',
>   '"t_view"',
>   'text',
>   null,
>   'passageID'
> );
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)