[
https://issues.apache.org/jira/browse/TRAFODION-1819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15139826#comment-15139826
]
ASF GitHub Bot commented on TRAFODION-1819:
-------------------------------------------
GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/incubator-trafodion/pull/313
[TRAFODION-1819] Disallow UPDATE STATS in a user transaction
UPDATE STATS sometimes does DDL and DML under the covers, and likes to
start its own transactions for this purpose. Trafodion doesn't support mixed
DDL and DML in the same transaction. Therefore, it makes sense for UPDATE STATS
to check for a user transaction up front, and raise an error if there is one
running.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion1819
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/313.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 #313
----
commit 6073986a03d19be327619976559e59772b43c9e7
Author: Dave Birdsall <dbirds...@apache.org>
Date: 2016-02-09T21:15:40Z
Disallow UPDATE STATS in a user transaction
----
> UPDATE STATS should not be allowed in a user transaction
> --------------------------------------------------------
>
> Key: TRAFODION-1819
> URL: https://issues.apache.org/jira/browse/TRAFODION-1819
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.0-incubating, 1.3-incubating
> Environment: Any
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> UPDATE STATISTICS sometimes will do a mix of DDL and DML statements. These
> cannot be mixed in one transaction. Therefore, UPDATE STATISTICS should not
> be allowed in a user transaction.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
