[jira] [Updated] (PHOENIX-4307) Cannot create index on column without specifying column family if the column family is lowercase.

[Marcin Januszkiewicz (JIRA)]

     [ 
https://issues.apache.org/jira/browse/PHOENIX-4307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Marcin Januszkiewicz updated PHOENIX-4307:
------------------------------------------
    Description: 
Table DDL: 

{code:sql}
create table t (
  rowkey VARCHAR PRIMARY KEY,
  "cf"."vehicle.number" VARCHAR);
{code}


Index DDL:
{code:sql}
CREATE LOCAL INDEX test_02 ON t ("vehicle.number");
{code}

Result:
{noformat}
Error: ERROR 1001 (42I01): Undefined column family. familyName=CF 
(state=42I01,code=1001)
org.apache.phoenix.schema.ColumnFamilyNotFoundException: ERROR 1001 (42I01): 
Undefined column family. familyName=CF
{noformat}

When I specify the column family everything works:
CREATE LOCAL INDEX test_02 ON t ("cf"."vehicle.number");

  was:
Table DDL: 
create table t (
  rowkey VARCHAR PRIMARY KEY,
  "cf"."vehicle.number" VARCHAR);

Index DDL:
CREATE LOCAL INDEX test_02 ON t ("vehicle.number");

Result:
Error: ERROR 1001 (42I01): Undefined column family. familyName=CF 
(state=42I01,code=1001)
org.apache.phoenix.schema.ColumnFamilyNotFoundException: ERROR 1001 (42I01): 
Undefined column family. familyName=CF

When I specify the column family everything works:
CREATE LOCAL INDEX test_02 ON t ("cf"."vehicle.number");


> Cannot create index on column without specifying column family if the column 
> family is lowercase.
> -------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-4307
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4307
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Marcin Januszkiewicz
>
> Table DDL: 
> {code:sql}
> create table t (
>   rowkey VARCHAR PRIMARY KEY,
>   "cf"."vehicle.number" VARCHAR);
> {code}
> Index DDL:
> {code:sql}
> CREATE LOCAL INDEX test_02 ON t ("vehicle.number");
> {code}
> Result:
> {noformat}
> Error: ERROR 1001 (42I01): Undefined column family. familyName=CF 
> (state=42I01,code=1001)
> org.apache.phoenix.schema.ColumnFamilyNotFoundException: ERROR 1001 (42I01): 
> Undefined column family. familyName=CF
> {noformat}
> When I specify the column family everything works:
> CREATE LOCAL INDEX test_02 ON t ("cf"."vehicle.number");



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)