Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5, 10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
When ANALYZE TABLE .. PERSISTENT is run for geometry columns, the statistics for them is collected and put into mysql.column_stats, but histogram field remains NULL. It is different from, for example, blobs for which statistics aren't collected at all.
I couldn't find out whether it is intentional. If it is, maybe it's worth mentioning in the KB.
CREATE OR REPLACE TABLE t (g GEOMETRY); |
INSERT INTO t VALUES (POINT(0,0)),(POINT(1,1)),(POINT(2,2)); |
|
|
SET histogram_type= SINGLE_PREC_HB, histogram_size= 255; |
|
|
ANALYZE TABLE t PERSISTENT FOR ALL; |
|
|
SELECT DECODE_HISTOGRAM(hist_type,histogram) FROM mysql.column_stats where table_name = 't'; |
|
|
# Cleanup
|
DROP TABLE t; |
|
10.6 27738bd7 |
SELECT DECODE_HISTOGRAM(hist_type,histogram) FROM mysql.column_stats where table_name = 't'; |
DECODE_HISTOGRAM(hist_type,histogram)
|
NULL |