DROP TABLE IF EXISTS t1;
CREATE TABLE test.t1 ( f1 DECIMAL (60,25), f2 DECIMAL (60,25));
INSERT INTO test.t1 VALUES(0.0,0.0);
SELECT f1, f2 FROM t1;
f1	f2
0.0000000000000000000000000	0.0000000000000000000000000
SELECT f1 AS value FROM t1
UNION ALL
SELECT f2 FROM t1;
value
9999999999999999999999
9999999999999999999999
SELECT 'XXXXXXXXXXXXXXXXXXXX' AS description, f1 AS value FROM test.t1
UNION ALL
SELECT 'YYYYYYYYYYYYYYYYYYYY' , f2 FROM t1;
description	value
XXXXXXXXXXXXXXXX.XXX	9999999999999999999999
YYYYYYYYYYYYYYYY.YYY	9999999999999999999999
DROP TABLE IF EXISTS t1;
CREATE TABLE test.t1 ( f1 DECIMAL (60,24), f2 DECIMAL (60,24));
INSERT INTO test.t1 VALUES(0.0,0.0);
SELECT 'XXXXXXXXXXXXXXXXXXXX' AS description, f1 AS value FROM test.t1
UNION ALL
SELECT 'YYYYYYYYYYYYYYYYYYYY' , f2 FROM t1;
description	value
XXXXXXXXXXXXXXXXX.XX	9999999999999999999999
YYYYYYYYYYYYYYYYY.YY	9999999999999999999999