Debian Codegraph @

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

raw
1 CREATE DATABASE `ytest`;
2
3 0 rows affected
4
5 1 rows affected
6
7 0 rows affected
8
9 1 rows affected
10
11 1 rows affected
12
13 1 rows affected
14
15 1 rows affected
16
17 1 rows affected
18
19 0 rows affected
20
21 5 rows affected
22 Records: 5 Duplicates: 0 Warnings: 0
23 Rel: Update a valid row
24
25 1 rows affected
26 Rows matched: 1 Changed: 1 Warnings: 0
27 id name price
28 1 lemon 1.20
29 2 apple 0.25
30 3 tomato 1.80
31 4 mango 3.14
32 5 orange 0.90
33 0 rows affected
34
35 0 rows affected
36
37 5 rows affected
38 Records: 5 Duplicates: 0 Warnings: 0
39 Rel: Update non-existing row
40
41 0 rows affected
42 Rows matched: 0 Changed: 0 Warnings: 0
43 id name price
44 1 banana 1.20
45 2 apple 0.25
46 3 tomato 1.80
47 4 mango 3.14
48 5 orange 0.90
49 0 rows affected
50
51 0 rows affected
52
53 5 rows affected
54 Records: 5 Duplicates: 0 Warnings: 0
55 Rel: Update multiple rows
56
57 3 rows affected
58 Rows matched: 3 Changed: 3 Warnings: 0
59 id name price
60 1 lemon 1.20
61 2 apple 0.25
62 3 lemon 1.80
63 4 lemon 3.14
64 5 orange 0.90
65 0 rows affected
66
67 0 rows affected
68
69 5 rows affected
70 Records: 5 Duplicates: 0 Warnings: 0
71 Rel: Update all rows (no criteria)
72
73 5 rows affected
74 Rows matched: 5 Changed: 5 Warnings: 0
75 id name price
76 1 lemon 1.20
77 2 lemon 0.25
78 3 lemon 1.80
79 4 lemon 3.14
80 5 lemon 0.90
81 0 rows affected
82
83 0 rows affected
84
85 5 rows affected
86 Records: 5 Duplicates: 0 Warnings: 0
87 Rel: Update two first rows in desc order
88
89 2 rows affected
90 Rows matched: 2 Changed: 2 Warnings: 0
91 id name price
92 1 banana 1.20
93 2 apple 0.25
94 3 lemon 1.80
95 4 lemon 3.14
96 5 orange 0.90
97 0 rows affected
98
99 0 rows affected
100
101 5 rows affected
102 Records: 5 Duplicates: 0 Warnings: 0
103 Rel: Update non-existing column
104 Got expected error: Unknown column 'noname' in 'field list' (code 1054)
105 id name price
106 1 banana 1.20
107 2 apple 0.25
108 3 tomato 1.80
109 4 mango 3.14
110 5 orange 0.90
111 0 rows affected
112
113 0 rows affected
114
115 5 rows affected
116 Records: 5 Duplicates: 0 Warnings: 0
117 Rel: Update on a table with expression on invalid columns
118 Got expected error: Unknown column 'noprice' in 'where clause' (code 1054)
119 id name price
120 1 banana 1.20
121 2 apple 0.25
122 3 tomato 1.80
123 4 mango 3.14
124 5 orange 0.90
125 0 rows affected
126
127 0 rows affected
128
129 5 rows affected
130 Records: 5 Duplicates: 0 Warnings: 0
131 Rel: Update with empty operations type
132 Got expected error: Invalid update expression list (code 5050)
133 id name price
134 1 banana 1.20
135 2 apple 0.25
136 3 tomato 1.80
137 4 mango 3.14
138 5 orange 0.90
139 0 rows affected
140
141 0 rows affected
142
143 5 rows affected
144 Records: 5 Duplicates: 0 Warnings: 0
145 Rel: Update source column with table
146 Got expected error: Invalid column name to update (code 5052)
147 id name price
148 1 banana 1.20
149 2 apple 0.25
150 3 tomato 1.80
151 4 mango 3.14
152 5 orange 0.90
153 0 rows affected
154
155 0 rows affected
156
157 5 rows affected
158 Records: 5 Duplicates: 0 Warnings: 0
159 Rel: Update source column with table
160 Got expected error: Invalid column name to update (code 5052)
161 id name price
162 1 banana 1.20
163 2 apple 0.25
164 3 tomato 1.80
165 4 mango 3.14
166 5 orange 0.90
167 0 rows affected
168
169 0 rows affected
170
171 5 rows affected
172 Records: 5 Duplicates: 0 Warnings: 0
173 Rel: Update source column with table and schema
174 Got expected error: Invalid column name to update (code 5052)
175 id name price
176 1 banana 1.20
177 2 apple 0.25
178 3 tomato 1.80
179 4 mango 3.14
180 5 orange 0.90
181 0 rows affected
182
183 0 rows affected
184
185 5 rows affected
186 Records: 5 Duplicates: 0 Warnings: 0
187 Rel: Update on an invalid schema
188 Got expected error: Table 'ytest.xtable' doesn't exist (code 1146)
189 id name price
190 1 banana 1.20
191 2 apple 0.25
192 3 tomato 1.80
193 4 mango 3.14
194 5 orange 0.90
195 0 rows affected
196
197 0 rows affected
198
199 5 rows affected
200 Records: 5 Duplicates: 0 Warnings: 0
201 Rel: Update on an invalid collection
202 Got expected error: Table 'xtest.ytable' doesn't exist (code 1146)
203 id name price
204 1 banana 1.20
205 2 apple 0.25
206 3 tomato 1.80
207 4 mango 3.14
208 5 orange 0.90
209 0 rows affected
210 Rel: Update one field twice
211
212 5 rows affected
213 Rows matched: 5 Changed: 5 Warnings: 0
214 id name price
215 1 lemon 1.20
216 2 lemon 0.25
217 3 lemon 1.80
218 4 lemon 3.14
219 5 lemon 0.90
220 0 rows affected
221 Mysqlx.Ok {
222 msg: "bye!"
223 }
224 ok
225 drop schema ytest;