[
https://issues.apache.org/jira/browse/TRAFODION-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-2762.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.3-incubating
> UPDATE STATS fails when creating sample table with nullable key
> ---------------------------------------------------------------
>
> Key: TRAFODION-2762
> URL: https://issues.apache.org/jira/browse/TRAFODION-2762
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.3-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Minor
> Fix For: 2.3-incubating
>
>
> Trafodion contains an experimental feature that optionally allows one to
> create a table with a nullable primary key. That is, NULL values can be used
> in the primary key. For purposes of uniqueness, NULL is treated like any
> other value.
> One can turn on this feature via CQD ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT
> 'ON'.
> However, if one creates a table with a nullable primary key, then later in
> another session without this CQD attempts to do UPDATE STATISTICS where a
> sample table is created, UPDATE STATISTICS will fail. For example:
> update statistics for table Traf2762 on every column sample;
> *** ERROR[9214] Object
> TRAFODION.SEABASE.TRAF_SAMPLE_05267662795492559847_1505757284_535476 could
> not be created.
> *** ERROR[1135] Clustering key column inputuid must be assigned a NOT NULL
> NOT DROPPABLE constraint.
> *** ERROR[8839] Transaction was aborted.
> *** ERROR[9201] Unable to DROP object
> TRAFODION.SEABASE.TRAF_SAMPLE_05267662795492559847_15057572 84_535476.
> *** ERROR[1389] Object
> TRAFODION.SEABASE.TRAF_SAMPLE_05267662795492559847_1505757284_535476 does not
> exist in Trafodion.
> *** ERROR[8839] Transaction was aborted.
> Note: This example assumes that Traf2762 is a large enough table that a
> sample table is required by UPDATE STATISTICS.
> A more reliable way to reproduce the error (which does not depend on table
> size) is "update statistics for table Traf2762 create sample random 10
> percent".
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
