Re: world_x

[Christian Soutou]

Thanks Andrzej

--1

In my table the createCollection() methods doesn't underneath ?
Does the virtual column should be added?

CREATE DATABASE bd_json;

CREATE TABLE bd_json.tab_vol_json
(vol_id INT AUTO_INCREMENT PRIMARY KEY,
details_vol JSON
);

/*
CREATE TABLE `CountryInfo` (
`doc` json DEFAULT NULL,
`_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(doc, '$._id'))) STORED PRIMARY KEY
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
*/


--2

OK if I want create a collection with the name of my table :

\use bd_json

mysql-js> db.createCollection("tab_vol_json")
MySQL Error (1050): Table 'tab_vol_json' already exists at (shell):1:3
in db.createCollection("tab_vol_json")

and db.getCollections() returns nothing.