--disable_abort_on_error

# suite/updown/include/basic.inc

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE test.t1 ( f1 DECIMAL (60,25), f2 DECIMAL (60,25));

INSERT INTO test.t1 VALUES(0.0,0.0);
# Note: other values like "1" give the same ugly effect

SELECT f1, f2 FROM t1;

SELECT f1 AS value FROM t1
     UNION ALL
SELECT f2 FROM t1;

SELECT 'XXXXXXXXXXXXXXXXXXXX' AS description, f1 AS value FROM test.t1
     UNION ALL
SELECT 'YYYYYYYYYYYYYYYYYYYY' , f2 FROM t1;

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;