Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.16
-
None
Description
{ "items": [
|
{ "id": 0, "value": "a" },
|
{ "id": 1, "value": "b" },
|
{ "id": 2, "value": "c" },
|
{ "id": 3, "value": "d" },
|
{ "id": 5, "value": "e" },
|
{ "id": 6, "value": "f" },
|
{ "id": 7, "value": "g" },
|
{ "id": 8, "value": "h" },
|
{ "id": 9, "value": "i" },
|
{ "id": 10, "value": "j" },
|
{ "id": 11, "value": "k" },
|
{ "id": 12, "value": "l" },
|
{ "id": 13, "value": "m" }
|
] }
|
mariadb 10.0.16-MariaDB-log (root) [test]> create table json ( id int field_format='items:[x]:id', value char(1) field_format='items:[x]:value' ) engine=connect, table_type=json, file_name='test.json';
|
Query OK, 0 rows affected (0.01 sec)
|
 |
mariadb 10.0.16-MariaDB-log (root) [test]> select * from json;
|
+------+-------+
|
| id | value |
|
+------+-------+
|
| 0 | a |
|
| 1 | b |
|
| 2 | c |
|
| 3 | d |
|
| 5 | e |
|
| 6 | f |
|
| 7 | g |
|
| 8 | h |
|
| 9 | i |
|
| 10 | j |
|
+------+-------+
|
10 rows in set (0.00 sec)
|