CREATE SCHEMA xtest;
USE xtest;
CREATE TABLE xtable (doc JSON);
INSERT INTO xtable (doc) VALUES ('{"a":10, "b":20, "c":"30", "d":"40", "e":"foo", "f":"bar", "g":"2015.10.05"}');
string	number
foobar	1020
command ok
string	number
foo-in-bar	10-in-20
command ok
string	number
5.477225575051661	3.1622776601683795
command ok
fun	oper
2015-10-08	2015-10-08
command ok
fun	oper
2015-10-02	2015-10-02
command ok
string	number
40	10
command ok
string	number
40	10
command ok
string	number
1	1
command ok
string	number
1	1
command ok
string	number
1	1
command ok
string	number
1	1
command ok
like	regex
1	1
command ok
like	regex
0	1
command ok

1 rows affected
Rows matched: 1  Changed: 1  Warnings: 0
doc
{"a": 10, "b": 20, "c": "30", "d": "40", "e": "foo", "f": "bar", "g": "2015.10.05", "sqrt": 3.1622776601683795, "extra": "FOO"}
0 rows affected
result-in	result-not_in
1	1
command ok
result-in	result-not_in
1	1
command ok
result-in	result-not_in
1	1
command ok
result-in	result-not_in
1	1
command ok
result-in	result-not_in
1	1
command ok
result-in	result-not_in
1	1
command ok
string	number	root
STRING	INTEGER	OBJECT
command ok
keys
["a", "b", "c", "d", "e", "f", "g", "sqrt", "extra"]
command ok
doc
{"empty": {"a": 10, "b": 20, "c": "30", "d": "40", "e": "foo", "f": "bar", "g": "2015.10.05", "sqrt": 3.1622776601683795, "extra": "FOO"}}
command ok
Got expected error: Column name is required in ColumnIdentifier. (code 5152)
Mysqlx.Ok {
  msg: "bye!"
}
ok