Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.22
-
None
-
Ubuntu 16.04
Description
After inserting values into a column, that is defined as TINYINT (JSON table, CONNECT engine), result values are NULL
--------------
|
create table t1( |
i1 int, |
i2 int, |
i3 int |
)engine=CONNECT table_type=JSON File_name='/home/alice/Downloads/3.json' |
--------------
|
Query OK, 0 rows affected (0.07 sec) |
|
--------------
|
insert into t1 values(1,1,1) |
--------------
|
Query OK, 1 row affected (0.00 sec)
|
|
--------------
|
select * from t1 |
--------------
|
+------+------+------+ |
| i1 | i2 | i3 |
|
+------+------+------+ |
| 1 | 1 | 1 |
|
+------+------+------+ |
1 row in set (0.00 sec) |
|
--------------
|
create table t2( |
i1 tinyint,
|
i2 tinyint,
|
i3 tinyint
|
)engine=CONNECT table_type=JSON File_name='/home/alice/Downloads/3.json' |
--------------
|
Query OK, 0 rows affected (0.06 sec) |
|
--------------
|
select * from t2 |
--------------
|
+------+------+------+ |
| i1 | i2 | i3 |
|
+------+------+------+ |
| 1 | 1 | 1 |
|
+------+------+------+ |
1 row in set (0.00 sec) |
|
--------------
|
insert into t2 values(1,1,1) |
--------------
|
Query OK, 1 row affected (0.00 sec)
|
|
--------------
|
select * from t2 |
--------------
|
+------+------+------+ |
| i1 | i2 | i3 |
|
+------+------+------+ |
| 1 | 1 | 1 |
|
| NULL | NULL | NULL | |
+------+------+------+ |
2 rows in set (0.00 sec) |