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