[
https://issues.apache.org/jira/browse/TRAFODION-1843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15376949#comment-15376949
]
ASF GitHub Bot commented on TRAFODION-1843:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/592
JIRA TRAFODION-1843 TRAFODION-2106
-- TRAFODION-1843: allow 'default user' in create table statement
-- TRAFODION-2106: fix bug with use of to_date function in where clause
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_trafr21_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/592.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #592
----
commit 77899fde1b20e53bbb6ad0de0cc91bb252542225
Author: Anoop Sharma <[email protected]>
Date: 2016-07-14T13:48:54Z
JIRA TRAFODION-1843 TRAFODION-2106
-- TRAFODION-1843: allow 'default user' in create table statement
-- TRAFODION-2106: fix bug with use of to_date function in where clause
----
> 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: Anoop Sharma
>
> 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)
