[TRAFODION-1871] UPDATE STATS fails with error 2006 when default charset is UTF8

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3-incubating, 2.0-incubating
• Fix Version/s: 2.0-incubating
• Component/s: sql-cmu
• Environment: All
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 03/Mar/16 18:23
• Updated: 21/Apr/16 22:25
• Resolved: 23/Mar/16 22:38

Description

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.