blob: a567286a367c61a254130e0d1370ac6f8d5d5b0d [file] [log] [blame]
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;