Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.7.1
-
Component/s: Optimizer
-
Labels:None
Description
JSON histograms turn out invalid if a column value contains, for example, a double quote mark.
create or replace table t (a varchar(32)); |
insert into t values ('this is "quoted" text'); |
set histogram_type= JSON_HB; |
analyze table t persistent for all; |
select * from t where a = 'foo'; |
 |
# Cleanup
|
drop table t; |
preview-10.7-MDEV-26519-json-histograms da8bb4b4703 |
MariaDB [test]> select * from t where a = 'foo'; |
ERROR 4183 (HY000): Failed to parse histogram: Root JSON element must be a JSON object at offset 0. |
Attachments
Issue Links
- is caused by
-
MDEV-21130 Histograms: use JSON as on-disk format
-
- Closed
-
-
MDEV-26519 JSON Histograms: improve histogram collection
-
- Closed
-