You are viewing a plain text version of this content. The canonical link for it is here.

Posted to codereview@trafodion.apache.org by DaveBirdsall <gi...@git.apache.org> on 2017/10/03 20:42:52 UTC

[GitHub] incubator-trafodion pull request #1255: [TRAFODION-2762] Allow UPDATE STATS ...

GitHub user DaveBirdsall opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/1255

    [TRAFODION-2762] Allow UPDATE STATS to create sample tables regardless

    This change causes UPDATE STATISTICS to always set CQD ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT 'ON' and CQD CONTROL QUERY DEFAULT CAT_ERROR_ON_NOTNULL_STOREBY 'OFF'.
    
    This allows UPDATE STATISTICS to create a sample table with a nullable primary key (the first CQD) or a nullable STORE BY (the second CQD). In this way, the user does not need to remember to set these CQDs when doing UPDATE STATISTICS on a table that was created with either of these experimental features.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/DaveBirdsall/incubator-trafodion nullableKeyUstatBug

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/1255.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 #1255
    
----
commit 2f49cda944da82ff8cc411b324d1000b8b9795d0
Author: Dave Birdsall <db...@apache.org>
Date:   2017-10-03T20:38:39Z

    [TRAFODION-2762] Allow UPDATE STATS to create sample tables regardless of CQD

----


---

[GitHub] incubator-trafodion pull request #1255: [TRAFODION-2762] Allow UPDATE STATS ...

Posted by asfgit <gi...@git.apache.org>.

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafodion/pull/1255


---