Debian Codegraph @

mysql-test/suite/x/r/delete_del_none_table.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: "price"
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
82 0 rows affected
83 Mysqlx.Ok {
84 msg: "bye!"
85 }
86 ok