| 1 |
CREATE SCHEMA xtest; |
| 2 |
USE xtest; |
| 3 |
CREATE TABLE xtable (doc JSON); |
| 4 |
INSERT INTO xtable (doc) VALUES ('{"a":10, "b":20, "c":"30", "d":"40", "e":"foo", "f":"bar", "g":"2015.10.05"}'); |
| 5 |
string number |
| 6 |
foobar 1020 |
| 7 |
command ok |
| 8 |
string number |
| 9 |
foo-in-bar 10-in-20 |
| 10 |
command ok |
| 11 |
string number |
| 12 |
5.477225575051661 3.1622776601683795 |
| 13 |
command ok |
| 14 |
fun oper |
| 15 |
2015-10-08 2015-10-08 |
| 16 |
command ok |
| 17 |
Warnings generated: |
| 18 |
WARNING | 4095 | Delimiter '.' in position 4 in datetime value '2015.10.05' at row 1 is deprecated. Prefer the standard '-'. |
| 19 |
WARNING | 4095 | Delimiter '.' in position 4 in datetime value '2015.10.05' at row 1 is deprecated. Prefer the standard '-'. |
| 20 |
fun oper |
| 21 |
2015-10-02 2015-10-02 |
| 22 |
command ok |
| 23 |
Warnings generated: |
| 24 |
WARNING | 4095 | Delimiter '.' in position 4 in datetime value '2015.10.05' at row 1 is deprecated. Prefer the standard '-'. |
| 25 |
WARNING | 4095 | Delimiter '.' in position 4 in datetime value '2015.10.05' at row 1 is deprecated. Prefer the standard '-'. |
| 26 |
string number |
| 27 |
40 10 |
| 28 |
command ok |
| 29 |
string number |
| 30 |
40 10 |
| 31 |
command ok |
| 32 |
string number |
| 33 |
1 1 |
| 34 |
command ok |
| 35 |
string number |
| 36 |
1 1 |
| 37 |
command ok |
| 38 |
string number |
| 39 |
1 1 |
| 40 |
command ok |
| 41 |
string number |
| 42 |
1 1 |
| 43 |
command ok |
| 44 |
like regex |
| 45 |
1 1 |
| 46 |
command ok |
| 47 |
like regex |
| 48 |
0 1 |
| 49 |
command ok |
| 50 |
|
| 51 |
1 rows affected |
| 52 |
Rows matched: 1 Changed: 1 Warnings: 0 |
| 53 |
doc |
| 54 |
{"a": 10, "b": 20, "c": "30", "d": "40", "e": "foo", "f": "bar", "g": "2015.10.05", "sqrt": 3.1622776601683795, "extra": "FOO"} |
| 55 |
0 rows affected |
| 56 |
result-in result-not_in |
| 57 |
1 1 |
| 58 |
command ok |
| 59 |
result-in result-not_in |
| 60 |
1 1 |
| 61 |
command ok |
| 62 |
result-in result-not_in |
| 63 |
1 1 |
| 64 |
command ok |
| 65 |
result-in result-not_in |
| 66 |
1 1 |
| 67 |
command ok |
| 68 |
result-in result-not_in |
| 69 |
1 1 |
| 70 |
command ok |
| 71 |
result-in result-not_in |
| 72 |
1 1 |
| 73 |
command ok |
| 74 |
string number root |
| 75 |
STRING INTEGER OBJECT |
| 76 |
command ok |
| 77 |
keys |
| 78 |
["a", "b", "c", "d", "e", "f", "g", "sqrt", "extra"] |
| 79 |
command ok |
| 80 |
doc |
| 81 |
{"empty": {"a": 10, "b": 20, "c": "30", "d": "40", "e": "foo", "f": "bar", "g": "2015.10.05", "sqrt": 3.1622776601683795, "extra": "FOO"}} |
| 82 |
command ok |
| 83 |
Got expected error: Column name is required in ColumnIdentifier. (code 5152) |
| 84 |
Mysqlx.Ok { |
| 85 |
msg: "bye!" |
| 86 |
} |
| 87 |
ok |