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