[ https://issues.apache.org/jira/browse/TRAFODION-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall closed TRAFODION-1871. ------------------------------------------- Fix is in Release 2.0 branch. > UPDATE STATS fails with error 2006 when default charset is UTF8 > --------------------------------------------------------------- > > Key: TRAFODION-1871 > URL: https://issues.apache.org/jira/browse/TRAFODION-1871 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmu > Affects Versions: 2.0-incubating, 1.3-incubating > Environment: All > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > Fix For: 2.0-incubating > > > When the default character set is set to UTF8 (for example, by setting the > value 'UTF8" for default 'DEFAULT_CHARSET' in the system defaults table, or > by issuing CQD DEFAULT_CHARSET 'UTF8'), UPDATE STATS may fail with an > assertion error 2006 when done on a table that already has statistics. > A workaround is known: First clear the statistics (by doing UPDATE STATISTICS > FOR TABLE table-name CLEAR;) before generating new statistics. -- This message was sent by Atlassian JIRA (v6.3.4#6332)