[
https://issues.apache.org/jira/browse/TRAFODION-1843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-1843 stopped by Roberta Marton.
-------------------------------------------------
> Allow USER option(s) to be defined as defaults in a table column definition
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-1843
> URL: https://issues.apache.org/jira/browse/TRAFODION-1843
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmu
> Reporter: Roberta Marton
> Assignee: Roberta Marton
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
