DROP TABLE IF EXISTS DECIMAL_PRECISION; | |
CREATE TABLE DECIMAL_PRECISION(`dec` decimal) | |
ROW FORMAT DELIMITED | |
FIELDS TERMINATED BY ' ' | |
STORED AS TEXTFILE; | |
SELECT * from DECIMAL_PRECISION WHERE `dec` > 1234567890123456789.0123456789bd; | |
DROP TABLE DECIMAL_PRECISION; |