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

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

Rick Hillegas created DERBY-6730:
------------------------------------

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


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)