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 <dbirds...@apache.org> Date: 2017-10-03T20:38:39Z [TRAFODION-2762] Allow UPDATE STATS to create sample tables regardless of CQD ---- ---