Debian Codegraph @

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

raw
1 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
2
3 Create_collection
4 =================
5
6 command ok
7
8 Insert documents into collection 'data'
9 =======================================
10
11 1 rows affected
12 Got expected error (code 0)
13
14 1 rows affected
15 Got expected error (code 0)
16
17 1 rows affected
18 Got expected error (code 0)
19
20 1 rows affected
21 Got expected error (code 0)
22
23 Create index on collection 'data'
24 =================================
25
26 command ok
27 ## 1. Verify usage array index
28 ## 1.1 with "cont_in (JSON_CONTAINS)
29 doc
30 {"_id": "003", "integer": [11, 12]}
31 command ok
32 Verify ["SELECT NO_INDEX_USED OR NO_GOOD_INDEX_USED as Result FROM performance_schema.events_statements_history WHERE THREAD_ID = XX ORDER BY event_id DESC LIMIT 1" returns in "Result" column, following value 0]
33 ## 1. Verify usage array index
34 ## 1.2 with "overlaps" (JSON_OVERLAPS)
35 doc
36 {"_id": "004", "integer": [13, 14, 15, 16]}
37 command ok
38 Verify ["SELECT NO_INDEX_USED OR NO_GOOD_INDEX_USED as Result FROM performance_schema.events_statements_history WHERE THREAD_ID = XX ORDER BY event_id DESC LIMIT 1" returns in "Result" column, following value 0]
39 Mysqlx.Ok {
40 msg: "bye!"
41 }
42 ok