[ASTERIXDB-1225] Allow creating multiple open indexes on promotable types

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Component/s: COMP - Compiler, TYPE - Data Model
• Assignee: Ildar Absalyamov
• Reporter: Ildar Absalyamov
• Created: 11/Dec/15 19:50
• Updated: 17/Jun/17 00:00
• Resolved: 16/Dec/15 19:50

Description

Allow creating multiple open indexes on promotable types and pick the right index during the optimization.

drop dataverse test if exists;
create dataverse test;
use dataverse test;

create type Emp as open {
id:int64,
fname:string,
lname:string,
dept:string
}

create dataset employee(Emp) primary key id;

create index idx_employee_age32 on employee(age:int32) enforced;
create index idx_employee_age64 on employee(age:int64) enforced;