Debian Codegraph @

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

raw
1 create schema xtest default charset 'utf8mb4';
2
3 command ok
4 RUN use xtest
5
6 0 rows affected
7 RUN insert into fancycoll (doc) values ('\n{\n \"_id\": \"X999_Y999\",\n \"from\": {\n \"name\": \"Tom Brady\", \"id\": \"X12\"\n },\n \"message\": \"Looking forward to 2010!\",\n \"actions\": [\n {\n \"name\": \"Comment\",\n \"link\": \"http://www.facebook.com/X999/posts/Y999\"\n },\n {\n \"name\": \"Like\",\n \"link\": \"http://www.facebook.com/X999/posts/Y999\"\n }\n ],\n \"type\": \"status\",\n \"created_time\": \"2010-08-02T21:27:44+0000\",\n \"updated_time\": \"2010-08-02T21:27:44+0000\"\n }\n')
8
9 1 rows affected
10 RUN insert into fancycoll (doc) values ('\n{\n \"_id\": \"X999_Y998\",\n \"from\": {\n \"name\": \"Dom Crady\", \"id\": \"A12\"\n },\n \"message\": \"Looking forward to 2034!\",\n \"actions\": [\n {\n \"name\": \"Comment\",\n \"link\": \"http://www.facebook.com/X999/posts/Y222\"\n },\n {\n \"name\": \"Like\",\n \"link\": \"http://www.facebook.com/X999/posts/Y222\"\n }\n ],\n \"type\": \"status\",\n \"created_time\": \"2011-08-02T21:27:44+0000\",\n \"updated_time\": \"2011-08-02T21:27:44+0000\"\n }\n')
11
12 1 rows affected
13 send Mysqlx.Crud.Find {
14 collection {
15 name: "fancycoll"
16 schema: "xtest"
17 }
18 data_model: DOCUMENT
19 criteria {
20 type: OPERATOR
21 operator {
22 name: "!="
23 param {
24 type: IDENT
25 identifier {
26 document_path {
27 type: MEMBER
28 value: "from"
29 }
30 document_path {
31 type: MEMBER
32 value: "id"
33 }
34 }
35 }
36 param {
37 type: LITERAL
38 literal {
39 type: V_OCTETS
40 v_octets {
41 value: "X12"
42 }
43 }
44 }
45 }
46 }
47 }
48
49 Mysqlx.Resultset.ColumnMetaData {
50 type: BYTES
51 name: "doc"
52 original_name: "doc"
53 table: "fancycoll"
54 original_table: "fancycoll"
55 schema: "xtest"
56 catalog: "def"
57 collation: 63
58 length: 4294967295
59 content_type: 2
60 }
61
62 Mysqlx.Resultset.Row {
63 field: "{\"_id\": \"X999_Y998\", \"from\": {\"id\": \"A12\", \"name\": \"Dom Crady\"}, \"type\": \"status\", \"actions\": [{\"link\": \"http://www.facebook.com/X999/posts/Y222\", \"name\": \"Comment\"}, {\"link\": \"http://www.facebook.com/X999/posts/Y222\", \"name\": \"Like\"}], \"message\": \"Looking forward to 2034!\", \"created_time\": \"2011-08-02T21:27:44+0000\", \"updated_time\": \"2011-08-02T21:27:44+0000\"}\000"
64 }
65
66 Mysqlx.Resultset.FetchDone {
67 }
68
69 Mysqlx.Sql.StmtExecuteOk {
70 }
71
72 Mysqlx.Ok {
73 msg: "bye!"
74 }
75 ok