Debian Codegraph @

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

raw
1 RUN DROP SCHEMA IF EXISTS xtest
2
3 0 rows affected
4 RUN CREATE SCHEMA xtest
5
6 1 rows affected
7 RUN CREATE TABLE xtest.xtable (xcolumn VARCHAR(20))
8
9 0 rows affected
10 RUN SHOW STATUS LIKE 'Mysqlx_sessions'
11 Variable_name Value
12 Mysqlx_sessions 1
13 0 rows affected
14 RUN SHOW STATUS LIKE 'Mysqlx_crud_insert'
15 Variable_name Value
16 Mysqlx_crud_insert 0
17 0 rows affected
18 send Mysqlx.Crud.Insert {
19 collection {
20 name: "xtable"
21 schema: "xtest"
22 }
23 data_model: TABLE
24 projection {
25 name: "xcolumn"
26 }
27 row {
28 field {
29 type: LITERAL
30 literal {
31 type: V_STRING
32 v_string {
33 value: "xstring"
34 }
35 }
36 }
37 }
38 }
39
40
41 1 rows affected
42 RUN SHOW STATUS LIKE 'Mysqlx_crud_insert'
43 Variable_name Value
44 Mysqlx_crud_insert 1
45 0 rows affected
46 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
47 Variable_name Value
48 Mysqlx_crud_find 0
49 0 rows affected
50 send Mysqlx.Crud.Find {
51 collection {
52 name: "xtable"
53 schema: "xtest"
54 }
55 data_model: TABLE
56 }
57
58 xcolumn
59 xstring
60 command ok
61 RUN SHOW STATUS LIKE 'Mysqlx_crud_find'
62 Variable_name Value
63 Mysqlx_crud_find 1
64 0 rows affected
65 RUN SHOW STATUS LIKE 'Mysqlx_crud_update'
66 Variable_name Value
67 Mysqlx_crud_update 0
68 0 rows affected
69 send Mysqlx.Crud.Update {
70 collection {
71 name: "xtable"
72 schema: "xtest"
73 }
74 data_model: TABLE
75 criteria {
76 type: OPERATOR
77 operator {
78 name: "=="
79 param {
80 type: IDENT
81 identifier {
82 name: "xcolumn"
83 }
84 }
85 param {
86 type: LITERAL
87 literal {
88 type: V_OCTETS
89 v_octets {
90 value: "xstring"
91 }
92 }
93 }
94 }
95 }
96 operation {
97 source {
98 name: "xcolumn"
99 }
100 operation: SET
101 value {
102 type: LITERAL
103 literal {
104 type: V_STRING
105 v_string {
106 value: "updated_xstring"
107 }
108 }
109 }
110 }
111 }
112
113
114 1 rows affected
115 Rows matched: 1 Changed: 1 Warnings: 0
116 RUN SHOW STATUS LIKE 'Mysqlx_crud_update'
117 Variable_name Value
118 Mysqlx_crud_update 1
119 0 rows affected
120 RUN SHOW STATUS LIKE 'Mysqlx_crud_delete'
121 Variable_name Value
122 Mysqlx_crud_delete 0
123 0 rows affected
124 send Mysqlx.Crud.Delete {
125 collection {
126 name: "xtable"
127 schema: "xtest"
128 }
129 data_model: TABLE
130 criteria {
131 type: OPERATOR
132 operator {
133 name: "=="
134 param {
135 type: IDENT
136 identifier {
137 name: "xcolumn"
138 }
139 }
140 param {
141 type: LITERAL
142 literal {
143 type: V_OCTETS
144 v_octets {
145 value: "updated_xstring"
146 }
147 }
148 }
149 }
150 }
151 }
152
153
154 1 rows affected
155 RUN SHOW STATUS LIKE 'Mysqlx_crud_delete'
156 Variable_name Value
157 Mysqlx_crud_delete 1
158 0 rows affected
159 RUN SHOW STATUS LIKE 'Mysqlx_stmt_execute_%'
160 Variable_name Value
161 Mysqlx_stmt_execute_mysqlx 0
162 Mysqlx_stmt_execute_sql 13
163 Mysqlx_stmt_execute_xplugin 0
164 0 rows affected
165 send Mysqlx.Sql.StmtExecute {
166 stmt: "SELECT COUNT(*) FROM xtest.xtable"
167 }
168
169 COUNT(*)
170 0
171 0 rows affected
172 RUN SHOW STATUS LIKE 'Mysqlx_stmt_execute_%'
173 Variable_name Value
174 Mysqlx_stmt_execute_mysqlx 0
175 Mysqlx_stmt_execute_sql 15
176 Mysqlx_stmt_execute_xplugin 0
177 0 rows affected
178 RUN DROP SCHEMA IF EXISTS xtest
179
180 1 rows affected
181 Mysqlx.Ok {
182 msg: "bye!"
183 }
184 ok