|
When d < 0, truncate(x, d) function has no effect on unsigned int family data types (tinyint, smallint, int, bigint).
Here is an example:
MariaDB [mcs]> create table t1(a bigint unsigned)engine=columnstore;
|
Query OK, 0 rows affected (0.293 sec)
|
|
MariaDB [mcs]> insert into t1 value (18446744073709551613);
|
Query OK, 1 row affected (0.252 sec)
|
|
MariaDB [mcs]> select truncate(a, -19) from t1;
|
+----------------------+
|
| truncate(a, -19) |
|
+----------------------+
|
| 18446744073709551613 |
|
+----------------------+
|
1 row in set (0.107 sec)
|
|