[PHOENIX-1673] Allow tenant ID to be of any integral data type

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.3.0
• Fix Version/s: 4.6.0
• Labels: Newbie multi-tenant
• Assignee: Jeffrey Lyons
• Reporter: Mark Tse
• Created: 18/Feb/15 20:21
• Updated: 21/Nov/15 18:16
• Resolved: 21/Nov/15 18:16

Description

When creating multi-tenant tables and views, the column that identifies the tenant (first primary key column) must be of type 'VARCHAR' or 'CHAR'.

It should be possible to relax this restriction to use any integral data type. The tenant ID from the connection property can be converted based on the data type of the first primary key column.