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

[asfgit]

Github user asfgit closed the pull request at:

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


---

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

[DaveBirdsall]

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 
Date:   2017-10-03T20:38:39Z

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




---