[TRAFODION-1843] Allow USER option(s) to be defined as defaults in a table column definition

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-cmu
• Assignee: Anoop Sharma
• Reporter: Roberta Marton
• Created: 19/Feb/16 23:15
• Updated: 15/Sep/18 07:30
• Resolved: 17/Feb/17 22:13

Description

SQL ANSI allows you to specify: USER, CURRENT_USER, and SESSION_USER as default options associated with the <default-clause> when creating a column definition for a table. Trafodion should support similar functionality.

USER and SYSTEM_USER are semantically the same and irepresents the value of the current authorization identifier.

SESSION_USER is the values of the SQL session authorization identifier

Support for USER, CURRENT_USER, and SESSION_USER exist in the code and can be used, for example, in insert statements.

All user values should be returned as a varchar 128 to match the current implementation.

ANSI also support a SYSTEM_USER option. The SYSTEM_USER is an implementation defined value that represents the operating system user related to the process running the request. At this time, there are no plans to support the SYSTEM_USER.

Issue Links

• links to: GitHub Pull Request #592