[PHOENIX-3380] Document that NOT NULL can only be applied to primary keys

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Francis Chuang
• Created: 13/Oct/16 23:31
• Updated: 13/Oct/16 23:31

Description

According to https://phoenix.apache.org/language/index.html#create_table, the second example shows a non-primary key column having NOT NULL set. Executing this will currently return an error as NOT NULL can only be used on primary key columns.

The railroad diagram from ColumnDef also seems to imply that you can use NOT NULL on any column: https://phoenix.apache.org/language/index.html#column_def

I think a note should be added to mention that NOT NULL is only supported on primary key columns.