[MDEV-36765] JSON histograms cannot handle >1 byte characters from 10.11.12 - Jira

XML

Word

Printable

Bug Category:
Can result in hang or crash
Release Note Summary:

Hide
Starting from 10.11.12, Incorrect handling of UTF-8 characters (and other character sets requiring more than a single byte representation) in the minimum/maximum positions of a table during the execution of ANALYZE TABLE tbl PERSISTENT FOR ALL resulted in an endless loop consuming more memory and prevented the server from terminating.

Show
Starting from 10.11.12, Incorrect handling of UTF-8 characters (and other character sets requiring more than a single byte representation) in the minimum/maximum positions of a table during the execution of ANALYZE TABLE tbl PERSISTENT FOR ALL resulted in an endless loop consuming more memory and prevented the server from terminating.

As a regression from f699010, JSON histograms resulted in an endless loop for character sets where the bytes required was more than 1.

This highlighted that the column statistics for minium/maximum values of the column for utf8 character sets was incorrect.

regression from 11.4.5 and 10.11.13

is duplicated by

MDEV-36901 huge performance drop after update

MDEV-37027 Hang after update on access to several tables

relates to

MDEV-36977 Histogram code lacks coverage for non-latin characters

MDEV-37428 JSON_VALUE returns NULL for a key with an empty string value rather than an empty string

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.