Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1, 10.2.5, 10.2
-
None
-
Ubuntu 16.04
Description
Decimal values are inserted as NULL.
create table t3 (b decimal(10,2)) engine=CONNECT table_type=JSON ; |
|
|
insert into t3 values (5.28); |
select * from t3; |
+------+ |
| b |
|
+------+ |
| NULL | |
+------+ |
It worked as expected with other types of tables (CSV, DOS).
If decimal column is used in persistent column, results were correct (but NULL if column b1 is declared as decimal)
create table t1 |
(b decimal(10,2), b1 int as (b*100) persistent) engine=CONNECT table_type=JSON ; |
|
|
insert into t1 values ( 8.59, default), ('5.28', default); |
select * from t1; |
+------+------+ |
| b | b1 |
|
+------+------+ |
| NULL | 859 | |
| NULL | 528 | |
+------+------+ |