|
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.
|