Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.13
-
mariadb v10.2.13
CONNECT v1.06.0005
openSUSE Leap 42.3 x64
4GB RAM, 2 CPUs, 40GB HDD Virtual Machine on ESXi6
Description
I have found a couple of issues on webpage https://mariadb.com/kb/en/library/connect-json-table-type/
Section: Alternate Table Arrangement
[
[56, "Coucou", 500.00],
[[2,0,1,4], "Hello World", 2.0316],
["1784", "John Doo", 32.4500],
[1914, ["Nabucho","donosor"], 5.12],
[7, "sept", [0.77,1.22,2.01]],
[8, "huit", 13.0],
]
insert into xjson values(25, 'Breakfast', 1.414);
Returns: SQL Error (1296): Got error 174 'Unexpected ',]' near ],' from CONNECT
Solution: Remove comma after the last JSON item [8, "huit", 13.0]
Section: CRUD operations on JSON tables
CREATE TABLE jauthor (
FIRSTNAME CHAR(64),
LASTNAME CHAR(64))
ENGINE=CONNECT table_type= JSON File_name='biblio3.json' option_list='Object=2.AUTHOR';
select * from jauthor;
Returns: SQL Error (1296): Got error 174 'Cannot find array value 2' from CONNECT
Solution: Either option_list='Object=1.AUTHOR' or option_list='Object=2.AUTHOR, Base=1'
Attachments
Issue Links
- relates to
-
MDEV-15521 CONNECT XML Table Type
- Open