[ASTERIXDB-1496] Having an ability to put nullable field information when creating an enforced index

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: soon
• Assignee: Michael J. Carey
• Reporter: Taewoo Kim
• Created: 22/Jun/16 22:59
• Updated: 26/Aug/16 20:19
• Resolved: 26/Aug/16 20:19

Description

It would be nice if we have an ability to put nullable field ("?") information when creating an enforced type index to indicate whether the field is nullable or not.

The current syntax
create index fbSendTimeIdx on FacebookMessages(send-time:datetime) type btree enforced;

The proposed syntax(nullable field)
create index fbSendTimeIdx on FacebookMessages(send-time:datetime?) type btree enforced;

or

(non-nullable field)
create index fbSendTimeIdx on FacebookMessages(send-time:datetime) type btree enforced;