[jira] [Created] (TRAFODION-2220) INC UPD STATS: update stats returns 8102 unique constraint error

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

David Wayne Birdsall created TRAFODION-2220:
-----------------------------------------------

             Summary: INC UPD STATS: update stats returns 8102 unique constraint error
                 Key: TRAFODION-2220
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2220
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 2.1-incubating
            Reporter: David Wayne Birdsall
            Assignee: David Wayne Birdsall


The following sequence of statements returns a 8102 error indicating unique constraint violation. I was expecting the persistent sample table to be dropped and replaced by the new one.

>>create schema mysch2;

--- SQL operation complete.
>>set schema mysch2;

--- SQL operation complete.
>>
>>create table myFullTable (
+>c_char char(50),
+>c_char_upshift char(50) upshift,
+>c_char_not_casespecific char(50) not casespecific,
+>c_char_varying char varying(50),
+>c_char_varying_upshift char varying(50) upshift,
+>c_char_varying_not_casespecific char varying(50) not casespecific,
+>c_varchar varchar(50),
+>c_varchar_upshift varchar(50) upshift,
+>c_varchar_not_casespecific varchar(50) not casespecific,
+>c_nchar nchar(50),
+>c_nchar_upshift nchar(50) upshift,
+>c_nchar_not_casespecific nchar(50) not casespecific,
+>c_nchar_varying nchar varying(50),
+>c_nchar_varying_upshift nchar varying(50) upshift,
+>c_nchar_varying_not_casespecific nchar varying(50) not casespecific,
+>c_numeric numeric(9,2),
+>c_numeric_unsigned numeric(9,2) unsigned,
+>c_decimal decimal(9,2),
+>c_decimal_unsigned decimal(9,2) unsigned,
+>c_integer integer,
+>c_integer_unsigned integer unsigned,
+>c_largeint largeint,
+>c_smallint smallint,
+>c_smallint_unsigned smallint unsigned,
+>c_float float(10),
+>c_real real,
+>c_double_precision double precision,
+>c_date date,
+>c_time time, -- default is (0)
+>c_time5 time(5),
+>c_timestamp timestamp, -- default is (6)
+>c_timestamp5 timestamp(5),
+>c_interval interval year to month,
+>c_clob clob,
+>c_blob blob
+>);

--- SQL operation complete.
>>
>>insert into myFullTable values
+>('CHAR_1', 'char_1', 'char_1', 'CHARVAR_1', 'charvar_1', 'charvar_1', 'VARCHAR_1', 'varchar_1', 'varchar_1', 'NCHAR_1', 'nchar_1', 'nchar_1', 'NCHARVAR_1', 'ncharvar_1', 'ncharvar_1', -1, 1, -1.11, 1.11, -1, 1, -1, -1, 1, -1.11, -1.11, -1.11, date '2001-01-01', time '01:01:01', time '01:01:01.12345', timestamp '2001-01-01 01:01:01.123456', timestamp '2001-01-01 01:01:01.12345', interval '01-01' year to month, 'clob_1', 'blob_1'
+>),
+>('CHAR_2', 'char_2', 'char_2', 'CHARVAR_2', 'charvar_2', 'charvar_2', 'VARCHAR_2', 'varchar_2', 'varchar_2', 'NCHAR_2', 'nchar_2', 'nchar_2', 'NCHARVAR_2', 'ncharvar_2', 'ncharvar_2', -2, 2, -2.22, 2.22, -2, 2, -2, -2, 2, -2.22, -2.22, -2.22, date '2002-02-02', time '02:02:02', time '02:02:02.12345', timestamp '2002-02-02 02:02:02.123456', timestamp '2002-02-02 02:02:02.12345', interval '02-02' year to month, 'clob_2', 'blob_2'
+>),
+>('CHAR_3', 'char_3', 'char_3', 'CHARVAR_3', 'charvar_3', 'charvar_3', 'VARCHAR_3', 'varchar_3', 'varchar_3', 'NCHAR_3', 'nchar_3', 'nchar_3', 'NCHARVAR_3', 'ncharvar_3', 'ncharvar_3', -3, 3, -3.33, 3.33, -3, 3, -3, -3, 3, -3.33, -3.33, -3.33, date '2003-03-03', time '03:03:03', time '03:03:03.12345', timestamp '2003-03-03 03:03:03.123456', timestamp '2003-03-03 03:03:03.12345', interval '03-03' year to month, 'clob_3', 'blob_3'
+>),
+>('CHAR_4', 'char_4', 'char_4', 'CHARVAR_4', 'charvar_4', 'charvar_4', 'VARCHAR_4', 'varchar_4', 'varchar_4', 'NCHAR_4', 'nchar_4', 'nchar_4', 'NCHARVAR_4', 'ncharvar_4', 'ncharvar_4', -4, 4, -4.44, 4.44, -4, 4, -4, -4, 4, -4.44, -4.44, -4.44, date '2004-04-04', time '04:04:04', time '04:04:04.12345', timestamp '2004-04-04 04:04:04.123456', timestamp '2004-04-04 04:04:04.12345', interval '04-04' year to month, 'clob_4', 'blob_4'
+>),
+>(null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null
+>)
+>;

--- 5 row(s) inserted.
>>
>>update statistics for table myFullTable on every column sample random 50 percent persistent;

--- SQL operation complete.
>>update statistics for table myFullTable create sample random 100 percent;

*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.MYSCH2.MYFULLTABLE encountered an error (8102) from statement Process_Query.

*** ERROR[8102] The operation is prevented by a unique constraint.

--- SQL operation failed with errors.
>>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)