Debian Codegraph @

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

raw
1 ## Admin commands error messages
2
3 --source include/xplugin_preamble.inc
4 --source include/xplugin_create_user.inc
5 ## Test starts here
6 --let $xtest_file= $MYSQL_TMP_DIR/admin_cmd_error_msgs.xpl
7 --write_file $xtest_file
8 -->quiet
9 -->stmtadmin create_collection {"schema":"xtest", "name":"books"}
10 -->recvresult
11
12 -->stmtadmin disable_notices {"notice":42}
13 -->expecterror ER_X_CMD_ARGUMENT_VALUE
14 -->recvresult
15
16 -->stmtadmin disable_notices {"notice":[]}
17 -->expecterror ER_X_CMD_ARGUMENT_VALUE
18 -->recvresult
19
20 -->stmtadmin disable_notices {"notice":["warnings", "account_expired", 42]}
21 -->expecterror ER_X_CMD_ARGUMENT_VALUE
22 -->recvresult
23
24
25 -->stmtadmin create_collection_index {"schema":42, "collection":"books", "name":"mix", "unique":true, "fields":{"field":"$.isbn", "type":"TEXT(80)", "required":false}}
26 -->expecterror ER_X_CMD_ARGUMENT_VALUE
27 -->recvresult
28
29 -->stmtadmin create_collection_index {"schema":"xtest", "collection":[42, 43], "name":"mix", "unique":true, "fields":{"field":"$.isbn", "type":"TEXT(80)", "required":false}}
30 -->expecterror ER_X_CMD_ARGUMENT_VALUE
31 -->recvresult
32
33 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":{"mix":42}, "unique":true, "fields":{"field":"$.isbn", "type":"TEXT(80)", "required":false}}
34 -->expecterror ER_X_CMD_ARGUMENT_VALUE
35 -->recvresult
36
37 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":"true", "fields":{"field":"$.isbn", "type":"TEXT(80)", "required":false}}
38 -->expecterror ER_X_CMD_ARGUMENT_VALUE
39 -->recvresult
40
41 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":"field"}
42 -->expecterror ER_X_CMD_ARGUMENT_VALUE
43 -->recvresult
44
45 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":{"field":42, "type":"TEXT(80)", "required":false}}
46 -->expecterror ER_X_CMD_ARGUMENT_VALUE
47 -->recvresult
48
49 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":{"field":"$.isbn", "type":42, "required":false}}
50 -->expecterror ER_X_CMD_ARGUMENT_VALUE
51 -->recvresult
52
53 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":{"field":"$.isbn", "type":"TEXT(80)", "required":42}}
54 -->expecterror ER_X_CMD_ARGUMENT_VALUE
55 -->recvresult
56
57 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[]}
58 -->expecterror ER_X_CMD_ARGUMENT_VALUE
59 -->recvresult
60
61 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[42]}
62 -->expecterror ER_X_CMD_ARGUMENT_VALUE
63 -->recvresult
64
65 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[{"field":42, "type":"TEXT(80)", "required":false}]}
66 -->expecterror ER_X_CMD_ARGUMENT_VALUE
67 -->recvresult
68
69 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[{"field":"$.isbn", "type":42, "required":false}]}
70 -->expecterror ER_X_CMD_ARGUMENT_VALUE
71 -->recvresult
72
73 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[{"field":"$.isbn", "type":"TEXT(80)", "required":42}]}
74 -->expecterror ER_X_CMD_ARGUMENT_VALUE
75 -->recvresult
76
77 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[{"field":"$.isbn", "type":"TEXT(80)", "required":false}, {"field":42, "type":"INT", "required":false}]}
78 -->expecterror ER_X_CMD_ARGUMENT_VALUE
79 -->recvresult
80
81 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[{"field":"$.isbn", "type":"TEXT(80)", "required":false}, {"field":"$.pages", "type":42, "required":false}]}
82 -->expecterror ER_X_CMD_ARGUMENT_VALUE
83 -->recvresult
84
85 -->stmtadmin create_collection_index {"schema":"xtest", "collection":"books", "name":"mix", "unique":true, "fields":[{"field":"$.isbn", "type":"TEXT(80)", "required":false}, {"field":"$.pages", "type":"INT", "required":42}]}
86 -->expecterror ER_X_CMD_ARGUMENT_VALUE
87 -->recvresult
88
89 EOF
90
91
92 CREATE SCHEMA xtest;
93
94 --exec $MYSQLXTEST -ux_root --password='' --file=$xtest_file 2>&1
95
96 ## Cleanup
97 --source ../include/xplugin_cleanup.inc