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

["Roberta Marton (JIRA)" <ji...@apache.org>]

     [ 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)