Debian Codegraph @

mysql-test/suite/x/r/crud_sundries.result

raw
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