[
https://issues.apache.org/jira/browse/TRAFODION-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15904100#comment-15904100
]
ASF GitHub Bot commented on TRAFODION-2530:
-------------------------------------------
GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1003
[TRAFODION-2530] Add explicit transaction control in CreateHistTables
This change causes UPDATE STATISTICS to do an explicit BEGIN WORK before
creating histogram tables and an explicit COMMIT WORK (or ROLLBACK) afterwards.
This will help make UPDATE STATISTICS behavior immune to autocommit settings.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion2530
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1003.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 #1003
----
commit c875b878ffd877031a53e4576961c3b42557d189
Author: Dave Birdsall <dbirds...@apache.org>
Date: 2017-03-09T23:55:37Z
[TRAFODION-2530] Add explicit transaction control in CreateHistTables
----
> UPDATE STATISTICS is sensitive to tdm_arkcmp autocommit setting
> ---------------------------------------------------------------
>
> Key: TRAFODION-2530
> URL: https://issues.apache.org/jira/browse/TRAFODION-2530
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating, 2.2-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
