Debian Codegraph @

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

raw
1 create schema xtest;
2 RUN use xtest
3
4 0 rows affected
5 RUN create table mytable (id int primary key, name varchar(40), price decimal(5,2), info json)
6
7 0 rows affected
8 RUN insert into mytable values (1, 'banana', 1.20, '{"color": "yellow"}')
9
10 1 rows affected
11 RUN insert into mytable values (2, 'apple', 0.25, '{"color":"red"}')
12
13 1 rows affected
14 RUN insert into mytable values (3, 'tomato', 1.80, '{"color":"red"}')
15
16 1 rows affected
17 RUN insert into mytable values (4, 'mango', 3.14, '{"color":"green"}')
18
19 1 rows affected
20 RUN insert into mytable values (5, 'orange', 0.90, '{"color":"orange"}')
21
22 1 rows affected
23 send Mysqlx.Crud.Delete {
24 collection {
25 name: "mytable"
26 schema: "xtest"
27 }
28 data_model: TABLE
29 criteria {
30 type: OPERATOR
31 operator {
32 name: "&&"
33 param {
34 type: OPERATOR
35 operator {
36 name: ">"
37 param {
38 type: IDENT
39 identifier {
40 name: "bla"
41 }
42 }
43 param {
44 type: LITERAL
45 literal {
46 type: V_DOUBLE
47 v_double: 100
48 }
49 }
50 }
51 }
52 param {
53 type: OPERATOR
54 operator {
55 name: "=="
56 param {
57 type: IDENT
58 identifier {
59 document_path {
60 type: MEMBER
61 value: "color"
62 }
63 name: "info"
64 }
65 }
66 param {
67 type: LITERAL
68 literal {
69 type: V_OCTETS
70 v_octets {
71 value: "red"
72 }
73 }
74 }
75 }
76 }
77 }
78 }
79 }
80
81 Mysqlx.Error {
82 severity: ERROR
83 code: 1054
84 msg: "Unknown column \'bla\' in \'where clause\'"
85 sql_state: "42S22"
86 }
87
88 send Mysqlx.Crud.Delete {
89 collection {
90 name: "mytable"
91 schema: "xtest"
92 }
93 data_model: TABLE
94 criteria {
95 type: OPERATOR
96 operator {
97 name: "=="
98 param {
99 type: IDENT
100 identifier {
101 document_path {
102 type: MEMBER
103 value: "bogus"
104 }
105 name: "info"
106 }
107 }
108 param {
109 type: LITERAL
110 literal {
111 type: V_OCTETS
112 v_octets {
113 value: "red"
114 }
115 }
116 }
117 }
118 }
119 }
120
121
122 0 rows affected
123 Mysqlx.Ok {
124 msg: "bye!"
125 }
126 ok