Debian Codegraph @

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

raw
1 ## Admin command: ensure_collection
2
3 --source include/xplugin_preamble.inc
4 --source include/xplugin_create_user.inc
5
6 CREATE SCHEMA xtest DEFAULT CHARSET 'utf8mb4';
7
8 ## Test starts here
9 --let $xtest_file= $MYSQL_TMP_DIR/admin_ensure_collection_mysqlx.xpl
10 --write_file $xtest_file
11 -->quiet
12
13 -->macro Make_stmt %CMD% %SCHEMA%
14 -->stmtadmin %CMD% { %SCHEMA% "name":"books"}
15 -->endmacro
16
17
18 -->macro Make_collection_with_schema %CMD% %SCHEMA% %ERROR%
19 -->callmacro Make_stmt %CMD% "schema":"%SCHEMA%",
20 -->expecterror %ERROR%
21 -->recvresult
22 -->stmtsql SHOW TABLES FROM xtest;
23 -->recvresult
24 -->endmacro
25
26
27 -->macro Make_collection_without_schema %CMD% %ERROR%
28 -->callmacro Make_stmt %CMD%
29 -->expecterror %ERROR%
30 -->recvresult
31 -->stmtsql SHOW TABLES FROM xtest;
32 -->recvresult
33 -->endmacro
34
35
36 -->macro Make_collection %CMD% %ERROR%
37 -->callmacro Make_collection_with_schema %CMD% xtest %ERROR%
38 -->endmacro
39
40
41 -->macro Make_table %DEF% %TEMP%
42 -->stmtsql CREATE %TEMP% TABLE xtest.books %DEF%;
43 -->recvresult
44 -->endmacro
45
46
47 -->macro Drop_table
48 -->stmtsql DROP TABLE xtest.books;
49 -->recvresult
50 -->endmacro
51
52
53 -->macro Make_index %NAME% %TYPE%
54 -->stmtadmin create_collection_index {"schema": "xtest", "collection":"books", "name":"%NAME%", "unique":true, "fields":{"field":"$.%NAME%", "type":"%TYPE%", "required":false}}
55 -->recvresult
56 -->endmacro
57
58
59 -->callmacro Make_collection create_collection 0
60 -->callmacro Make_collection create_collection 1050
61 -->callmacro Make_collection ensure_collection 0
62
63 -->callmacro Make_index isbn TEXT(13)
64 -->callmacro Make_collection ensure_collection 0
65
66 -->callmacro Make_index pages INT
67 -->callmacro Make_collection ensure_collection 0
68
69 -->stmtsql ALTER TABLE xtest.books ADD COLUMN (nothing INT)
70 -->recvresult
71 -->callmacro Make_collection ensure_collection 5156
72
73 -->callmacro Drop_table
74 -->callmacro Make_collection ensure_collection 0
75
76 -->callmacro Drop_table
77 -->callmacro Make_collection create_collection 0
78
79 -->stmtsql ALTER TABLE xtest.books DROP _id
80 -->recvresult
81 -->callmacro Make_collection ensure_collection 5156
82
83
84 -->callmacro Drop_table
85 -->callmacro Make_table (doc JSON, _id VARBINARY(32))
86 -->callmacro Make_collection ensure_collection 5156
87
88 -->callmacro Drop_table
89 -->callmacro Make_table (doc INT, _id VARBINARY(32))
90 -->callmacro Make_collection ensure_collection 5156
91
92 -->callmacro Drop_table
93 -->callmacro Make_table (doc JSON, _id INT)
94 -->callmacro Make_collection ensure_collection 5156
95
96
97 -->callmacro Make_collection_with_schema ensure_collection nowhere 1049
98
99 -->callmacro Drop_table
100 -->callmacro Make_collection_without_schema ensure_collection 1046
101
102 -->stmtsql USE xtest
103 -->recvresult
104
105 -->callmacro Make_collection_without_schema ensure_collection 0
106
107
108 -->callmacro Drop_table
109 -->newsession temp
110 -->callmacro Make_table (it_is_not_collection INT) TEMPORARY
111 -->callmacro Make_collection ensure_collection 0
112 -->stmtsql SHOW COLUMNS FROM xtest.books
113 -->recvresult
114 -->closesession
115 -->stmtsql SHOW COLUMNS FROM xtest.books
116 -->recvresult
117
118
119 -->callmacro Drop_table
120 -->sql
121 CREATE USER unpriv;
122 SET PASSWORD FOR unpriv = 'x';
123 GRANT SELECT ON xtest.* TO unpriv;
124 -->endsql
125 -->newsession unable_to_create unpriv x
126 -->callmacro Make_collection ensure_collection 1142
127 -->closesession
128 -->stmtsql DROP USER unpriv;
129 -->recvresult
130
131
132 -->callmacro Make_table (it_is_not_collection INT)
133 -->stmtsql LOCK TABLE xtest.books WRITE;
134 -->recvresult
135 -->newsession lock
136 -->callmacro Make_collection ensure_collection 5156
137 -->closesession
138 -->stmtsql UNLOCK TABLES
139 -->recvresult
140 EOF
141
142
143 --exec $MYSQLXTEST -ux_root --password='' --file=$xtest_file 2>&1
144
145 SHOW STATUS like 'Mysqlx_stmt_create_collection';
146 SHOW STATUS like 'Mysqlx_stmt_ensure_collection';
147 SHOW STATUS like 'Mysqlx_stmt_execute_mysqlx';
148
149 ## Cleanup
150 --source ../include/xplugin_cleanup.inc