[
https://issues.apache.org/jira/browse/TRAFODION-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-1871.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.0-incubating
> 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)
