Debian Codegraph @

mysql-test/suite/x/t/crud_find_doc_criteria.test

raw
1 ## Doc: Find using docpaths in expression
2 --source include/xplugin_preamble.inc
3 --source include/xplugin_create_user.inc
4
5 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
6
7 ## Test starts here
8 --write_file $MYSQL_TMP_DIR/crud_find_doc_criteria.xpl
9 ## Test data
10 -->quiet
11
12 -->stmtadmin create_collection {"schema":"xtest","name":"xcoll"}
13 -->recvresult
14
15 -->sql
16 INSERT INTO xtest.xcoll (doc) VALUES ('{"_id": "1", "name": "Anabel"}');
17 CREATE TABLE xtest.ycoll (ydoc JSON, _id VARBINARY(16) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(ydoc, '$._id'))) STORED PRIMARY KEY);
18 INSERT INTO xtest.ycoll (ydoc) VALUES ('{"_id": "1", "name": "Anabel"}');
19 CREATE TABLE xtest.zcoll (doc JSON, _zid VARBINARY(16) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY);
20 INSERT INTO xtest.zcoll (doc) VALUES ('{"_id": "1", "name": "Anabel"}');
21 -->endsql
22
23 -->macro Find_value %COLL% %IDENT% %VALUE% %ERROR%
24 Mysqlx.Crud.Find {
25 collection {
26 name: "%COLL%"
27 schema: "xtest"
28 }
29 data_model: DOCUMENT
30 criteria {
31 type: OPERATOR
32 operator {
33 name: "=="
34 param {
35 type: IDENT
36 identifier {
37 %IDENT%
38 }
39 }
40 param {
41 type: LITERAL
42 literal {
43 type: V_OCTETS
44 v_octets {value: "%VALUE%"}
45 }
46 }
47 }
48 }
49 }
50 -->expecterror %ERROR%
51 -->recvresult
52 -->endmacro
53
54 -->title * xcoll is corect collection
55 -->callmacro Find_value xcoll name:"_id" 1 ER_SUCCESS
56 -->callmacro Find_value xcoll name:"_id" no_data ER_SUCCESS
57 -->callmacro Find_value xcoll name:"doc" no_data ER_SUCCESS
58 -->callmacro Find_value xcoll document_path{type:MEMBER value:"name"} Anabel ER_SUCCESS
59 -->callmacro Find_value xcoll document_path{type:MEMBER value:"name"} no_data ER_SUCCESS
60 -->callmacro Find_value xcoll name:"name" no_data ER_X_DOC_REQUIRED_FIELD_MISSING
61
62 -->title * ycoll is not corect collection; missing `doc` column
63 -->callmacro Find_value ycoll name:"_id" 1 ER_X_DOC_REQUIRED_FIELD_MISSING
64 -->callmacro Find_value ycoll name:"_id" no_data ER_X_DOC_REQUIRED_FIELD_MISSING
65 -->callmacro Find_value ycoll name:"doc" no_data ER_X_DOC_REQUIRED_FIELD_MISSING
66 -->callmacro Find_value ycoll document_path{type:MEMBER value:"name"} Anabel ER_X_DOC_REQUIRED_FIELD_MISSING
67 -->callmacro Find_value ycoll document_path{type:MEMBER value:"name"} no_data ER_X_DOC_REQUIRED_FIELD_MISSING
68 -->callmacro Find_value ycoll name:"name" no_data ER_X_DOC_REQUIRED_FIELD_MISSING
69
70 -->title * zcoll is not corect collection; missing `_id` column
71 -->callmacro Find_value zcoll name:"_id" 1 ER_X_DOC_REQUIRED_FIELD_MISSING
72 -->callmacro Find_value zcoll name:"_id" no_data ER_X_DOC_REQUIRED_FIELD_MISSING
73 -->callmacro Find_value zcoll name:"doc" no_data ER_SUCCESS
74 -->callmacro Find_value zcoll document_path{type:MEMBER value:"name"} Anabel ER_SUCCESS
75 -->callmacro Find_value zcoll document_path{type:MEMBER value:"name"} no_data ER_SUCCESS
76 -->callmacro Find_value zcoll name:"name" no_data ER_X_DOC_REQUIRED_FIELD_MISSING
77 EOF
78
79 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/crud_find_doc_criteria.xpl 2>&1
80
81 ## Cleanup
82 --source ../include/xplugin_cleanup.inc