Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
Description
CREATE TABLE t (b bit(64)); |
INSERT INTO t VALUES (x'BE562B1A99001918'); |
|
ANALYZE TABLE t PERSISTENT FOR ALL; |
SET use_stat_tables= PREFERABLY; |
|
SELECT * FROM t; |
SELECT * FROM t; |
|
# Cleanup
|
DROP TABLE t; |
The first SELECT triggers warnings, but the second identical one doesn't:
10.2 5d57e04b |
SELECT * FROM t; |
b
|
�V+��
|
Warnings:
|
Warning 1292 Truncated incorrect INTEGER value: '13715197108439488792' |
Warning 1292 Truncated incorrect INTEGER value: '13715197108439488792' |
SELECT * FROM t; |
b
|
�V+��
|
Also reproducible with InnoDB, Aria.
Not reproducible without use_stat_tables.
Attachments
Issue Links
- relates to
-
MDEV-27492 DOUBLE_PREC_HB histogram has poor estimates for BIT columns
- Stalled