db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6730) Cannot create a Lucene index if a key column's name is case-sensitive
Date Tue, 09 Sep 2014 12:30:28 GMT

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

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

Before back-porting this fix and/or closing this issue, we should investigate the upgrade
implications. We may want to add a release note and recommend that users drop and recreate
their Lucene indexes after upgrade.

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

Mime
View raw message