David Wayne Birdsall created TRAFODION-2762:
-----------------------------------------------
Summary: 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
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 "InputErrors_10_TestClientData_10" on every column
sampl e;
*** 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
