|
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a DECIMAL(18,7)) ENGINE=ColumnStore;
|
INSERT INTO t1 VALUES (50.1);
|
INSERT INTO t1 VALUES (50.12);
|
INSERT INTO t1 VALUES (50.123);
|
INSERT INTO t1 VALUES (50.1234);
|
INSERT INTO t1 VALUES (50.12345);
|
INSERT INTO t1 VALUES (50.123456);
|
INSERT INTO t1 VALUES (50.1234567);
|
SELECT MAKETIME(0,0,a) FROM t1;
|
+-----------------+
|
| MAKETIME(0,0,a) |
|
+-----------------+
|
| 00:00:50.000000 |
|
| 00:00:50.000000 |
|
| 00:00:50.000000 |
|
| 00:00:50.000000 |
|
| 00:00:50.000000 |
|
| 00:00:50.000000 |
|
| 00:00:50.000000 |
|
+-----------------+
|
This result looks wrong.
The correct result is:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a DECIMAL(18,7)) ENGINE=MyISAM;
|
INSERT INTO t1 VALUES (50.1);
|
INSERT INTO t1 VALUES (50.12);
|
INSERT INTO t1 VALUES (50.123);
|
INSERT INTO t1 VALUES (50.1234);
|
INSERT INTO t1 VALUES (50.12345);
|
INSERT INTO t1 VALUES (50.123456);
|
INSERT INTO t1 VALUES (50.1234567);
|
SELECT MAKETIME(0,0,a) FROM t1;
|
+-----------------+
|
| MAKETIME(0,0,a) |
|
+-----------------+
|
| 00:00:50.100000 |
|
| 00:00:50.120000 |
|
| 00:00:50.123000 |
|
| 00:00:50.123400 |
|
| 00:00:50.123450 |
|
| 00:00:50.123456 |
|
| 00:00:50.123456 |
|
+-----------------+
|
|