232 lines
7.2 KiB
Plaintext
232 lines
7.2 KiB
Plaintext
CREATE SCHEMA IF NOT EXISTS xtest;
|
|
USE xtest;
|
|
|
|
command ok
|
|
|
|
1 rows affected
|
|
|
|
1 rows affected
|
|
|
|
1 rows affected
|
|
|
|
1 rows affected
|
|
|
|
1 rows affected
|
|
|
|
1 rows affected
|
|
|
|
1. 'cont_in' operator (placholder_scalar in member_array)
|
|
==========================================================
|
|
RUN recvok
|
|
1.a cont_in operator against string
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
1.b cont_in operator against integer
|
|
doc
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
1.c cont_in operator against double
|
|
doc
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
1.d cont_in operator against bool
|
|
doc
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
1.e cont_in operator against null
|
|
doc
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
RUN recvok
|
|
|
|
2. 'cont_in' operator (member_scalar in placholder_scalar)
|
|
===========================================================
|
|
RUN recvok
|
|
2.a cont_in operator against string
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
command ok
|
|
2.b cont_in operator against integer
|
|
doc
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
command ok
|
|
2.c cont_in operator against double
|
|
doc
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
command ok
|
|
2.d cont_in operator against bool
|
|
doc
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
command ok
|
|
2.e cont_in operator against null
|
|
doc
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
RUN recvok
|
|
|
|
3. 'not_cont_in' operator (placholder_scalar in member_array)
|
|
==============================================================
|
|
RUN recvok
|
|
3.a not_cont_in operator against string
|
|
doc
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
3.b not_cont_in operator against integer
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
3.c not_cont_in operator against double
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
3.d not_cont_in operator against bool
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
3.e not_cont_in operator against null
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
command ok
|
|
RUN recvok
|
|
|
|
4. Simple comparison with placeholder
|
|
======================================
|
|
RUN recvok
|
|
4.a simple comparison with string
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
command ok
|
|
4.b simple comparison with integer
|
|
doc
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
command ok
|
|
4.c simple comparison with double
|
|
doc
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
command ok
|
|
4.d simple comparison with bool
|
|
doc
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
command ok
|
|
4.e simple comparison with null
|
|
doc
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
RUN recvok
|
|
|
|
5. 'cont_in' operator and '!=' on the same placeholder
|
|
=======================================================
|
|
RUN recvok
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
command ok
|
|
RUN recvok
|
|
|
|
6. 'cont_in' operator (member_scalar in placholder_array)
|
|
==========================================================
|
|
RUN recvok
|
|
6.a cont_in operator against string
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
6.b cont_in operator against integer
|
|
doc
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
command ok
|
|
6.c cont_in operator against double
|
|
doc
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
command ok
|
|
6.d cont_in operator against bool
|
|
doc
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
command ok
|
|
6.e cont_in operator against null
|
|
doc
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
6.e cont_in operator against mix of values
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
RUN recvok
|
|
|
|
7. 'not_cont_in' operator (member_scalar in placholder_array)
|
|
==============================================================
|
|
RUN recvok
|
|
7.a not_cont_in operator against string
|
|
doc
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
command ok
|
|
7.b not_cont_in operator against integer
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
7.c not_cont_in operator against double
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
7.d not_cont_in operator against bool
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "105", "array": [null], "scalar": null}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
7.e not_cont_in operator against null
|
|
doc
|
|
{"_id": "101", "array": ["abc", "cde", "efg"], "scalar": "abc"}
|
|
{"_id": "102", "array": [123, 345, 567], "scalar": 123}
|
|
{"_id": "103", "array": [2.3, 3.4, 4.5], "scalar": 2.3}
|
|
{"_id": "104", "array": [true, false], "scalar": true}
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
7.e not_cont_in operator against mix of values
|
|
doc
|
|
{"_id": "106", "array": ["cde", 345, 3.4, true, null], "scalar": "cde"}
|
|
command ok
|
|
RUN recvok
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
DROP SCHEMA IF EXISTS xtest;
|