Details
Description
I tryied again with phoenix 4.1 version and still got the exception. Following is my statements:
1 create table example (id integer not null,fn varchar,ln varchar constraint pk primary key(id)) DEFAULT_COLUMN_FAMILY='F';
Notice that I would like to create default mutable index for the table.
2 create local index my_idx on example (fn) DEFAULT_COLUMN_FAMILY='F';
Here no matter with or without specifying DEFAULT_COLUMN_FAMILY options we would always got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
3 I also tried to create local index with immutable rows setting true, however, I still got the above error.