Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.4.0
-
None
-
2019-06
Description
Build tested: 14.0-1
engine commit:
1f47534
test case: autopilot.systemTest.datatypes
MariaDB [mytest]> create table t1 (snDECIMAL4_2 DECIMAL(4,2), unDECIMAL4_2 DECIMAL(4,2) unsigned) engine=columnstore;
|
Query OK, 0 rows affected (0.433 sec)
|
|
MariaDB [mytest]> desc t1;
|
+--------------+-----------------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+--------------+-----------------------+------+-----+---------+-------+
|
| snDECIMAL4_2 | decimal(4,2) | YES | | NULL | |
|
| unDECIMAL4_2 | decimal(4,2) unsigned | YES | | NULL | |
|
+--------------+-----------------------+------+-----+---------+-------+
|
2 rows in set (0.001 sec)
|
|
MariaDB [mytest]> insert t1 values (10.55, 12.89);
|
Query OK, 1 row affected (0.295 sec)
|
|
MariaDB [mytest]> select * from t1;
|
+--------------+--------------+
|
| snDECIMAL4_2 | unDECIMAL4_2 |
|
+--------------+--------------+
|
| 10.55 | 12.89 |
|
+--------------+--------------+
|
1 row in set (0.094 sec)
|
|
MariaDB [mytest]> update t1 set snDECIMAL4_2 = 11.99, unDECIMAL4_2 = 17.99;
|
Query OK, 0 rows affected (0.322 sec)
|
Rows matched: 0 Changed: 0 Warnings: 0
|
|
MariaDB [mytest]> select * from t1;
|
+--------------+--------------+
|
| snDECIMAL4_2 | unDECIMAL4_2 |
|
+--------------+--------------+
|
| NULL | NULL |
|
+--------------+--------------+
|
1 row in set (0.010 sec)
|
|
MariaDB [mytest]> update t1 set snDECIMAL4_2 = 11, unDECIMAL4_2 = 17;
|
Query OK, 0 rows affected (0.162 sec)
|
Rows matched: 0 Changed: 0 Warnings: 0
|
|
MariaDB [mytest]> select * from t1;
|
+--------------+--------------+
|
| snDECIMAL4_2 | unDECIMAL4_2 |
|
+--------------+--------------+
|
| 11.00 | 17.00 |
|
+--------------+--------------+
|
1 row in set (0.042 sec)
|
|