Debian Codegraph @

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

raw
1 CREATE SCHEMA IF NOT EXISTS xtest;
2 USE xtest;
3
4 command ok
5
6 1 rows affected
7
8 1 rows affected
9
10 1 rows affected
11
12 1 rows affected
13
14 1 rows affected
15
16 1 rows affected
17
18 1. 'cont_in' operator (placholder_scalar in member_array)
19 ==========================================================
20 RUN recvok
21 1.a cont_in operator against string
22 doc
23 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
24 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
25 command ok
26 1.b cont_in operator against integer
27 doc
28 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
29 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
30 command ok
31 1.c cont_in operator against double
32 doc
33 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
34 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
35 command ok
36 1.d cont_in operator against bool
37 doc
38 {"_id": "104", "array": [true, false], "scalar": true}
39 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
40 command ok
41 1.e cont_in operator against null
42 doc
43 {"_id": "105", "array": [null], "scalar": null}
44 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
45 command ok
46 RUN recvok
47
48 2. 'cont_in' operator (member_scalar in placholder_scalar)
49 ===========================================================
50 RUN recvok
51 2.a cont_in operator against string
52 doc
53 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
54 command ok
55 2.b cont_in operator against integer
56 doc
57 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
58 command ok
59 2.c cont_in operator against double
60 doc
61 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
62 command ok
63 2.d cont_in operator against bool
64 doc
65 {"_id": "104", "array": [true, false], "scalar": true}
66 command ok
67 2.e cont_in operator against null
68 doc
69 {"_id": "105", "array": [null], "scalar": null}
70 command ok
71 RUN recvok
72
73 3. 'not_cont_in' operator (placholder_scalar in member_array)
74 ==============================================================
75 RUN recvok
76 3.a not_cont_in operator against string
77 doc
78 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
79 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
80 {"_id": "104", "array": [true, false], "scalar": true}
81 {"_id": "105", "array": [null], "scalar": null}
82 command ok
83 3.b not_cont_in operator against integer
84 doc
85 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
86 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
87 {"_id": "104", "array": [true, false], "scalar": true}
88 {"_id": "105", "array": [null], "scalar": null}
89 command ok
90 3.c not_cont_in operator against double
91 doc
92 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
93 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
94 {"_id": "104", "array": [true, false], "scalar": true}
95 {"_id": "105", "array": [null], "scalar": null}
96 command ok
97 3.d not_cont_in operator against bool
98 doc
99 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
100 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
101 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
102 {"_id": "105", "array": [null], "scalar": null}
103 command ok
104 3.e not_cont_in operator against null
105 doc
106 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
107 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
108 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
109 {"_id": "104", "array": [true, false], "scalar": true}
110 command ok
111 RUN recvok
112
113 4. Simple comparison with placeholder
114 ======================================
115 RUN recvok
116 4.a simple comparison with string
117 doc
118 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
119 command ok
120 4.b simple comparison with integer
121 doc
122 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
123 command ok
124 4.c simple comparison with double
125 doc
126 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
127 command ok
128 4.d simple comparison with bool
129 doc
130 {"_id": "104", "array": [true, false], "scalar": true}
131 command ok
132 4.e simple comparison with null
133 doc
134 {"_id": "105", "array": [null], "scalar": null}
135 command ok
136 RUN recvok
137
138 5. 'cont_in' operator and '!=' on the same placeholder
139 =======================================================
140 RUN recvok
141 doc
142 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
143 command ok
144 RUN recvok
145
146 6. 'cont_in' operator (member_scalar in placholder_array)
147 ==========================================================
148 RUN recvok
149 6.a cont_in operator against string
150 doc
151 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
152 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
153 command ok
154 6.b cont_in operator against integer
155 doc
156 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
157 command ok
158 6.c cont_in operator against double
159 doc
160 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
161 command ok
162 6.d cont_in operator against bool
163 doc
164 {"_id": "104", "array": [true, false], "scalar": true}
165 command ok
166 6.e cont_in operator against null
167 doc
168 {"_id": "105", "array": [null], "scalar": null}
169 command ok
170 6.e cont_in operator against mix of values
171 doc
172 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
173 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
174 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
175 {"_id": "104", "array": [true, false], "scalar": true}
176 {"_id": "105", "array": [null], "scalar": null}
177 command ok
178 RUN recvok
179
180 7. 'not_cont_in' operator (member_scalar in placholder_array)
181 ==============================================================
182 RUN recvok
183 7.a not_cont_in operator against string
184 doc
185 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
186 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
187 {"_id": "104", "array": [true, false], "scalar": true}
188 {"_id": "105", "array": [null], "scalar": null}
189 command ok
190 7.b not_cont_in operator against integer
191 doc
192 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
193 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
194 {"_id": "104", "array": [true, false], "scalar": true}
195 {"_id": "105", "array": [null], "scalar": null}
196 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
197 command ok
198 7.c not_cont_in operator against double
199 doc
200 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
201 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
202 {"_id": "104", "array": [true, false], "scalar": true}
203 {"_id": "105", "array": [null], "scalar": null}
204 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
205 command ok
206 7.d not_cont_in operator against bool
207 doc
208 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
209 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
210 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
211 {"_id": "105", "array": [null], "scalar": null}
212 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
213 command ok
214 7.e not_cont_in operator against null
215 doc
216 {"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
217 {"_id": "102", "array": [123, 345, 567], "scalar": 123}
218 {"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
219 {"_id": "104", "array": [true, false], "scalar": true}
220 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
221 command ok
222 7.e not_cont_in operator against mix of values
223 doc
224 {"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
225 command ok
226 RUN recvok
227 Mysqlx.Ok {
228 msg: "bye!"
229 }
230 ok