Debian Codegraph @

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

raw
1 ## Test of user defined function mysqlx_error
2
3 ## Preamble
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6 ## Test starts here
7
8 --write_file $MYSQL_TMP_DIR/udf_mysqlx_error.xpl
9
10 -->stmtsql SELECT MYSQLX_ERROR(5018);
11 -->expecterror ER_X_BAD_UPSERT_DATA
12 -->recvresult
13
14 -->stmtsql DO MYSQLX_ERROR(5018);
15 -->expecterror ER_X_BAD_UPSERT_DATA
16 -->recvresult
17
18 -->stmtsql CALL MYSQLX_ERROR(5018);
19 -->expecterror ER_NO_DB_ERROR
20 -->recvresult
21
22 -->stmtsql USE test;
23 -->recvresult
24
25 -->stmtsql CALL MYSQLX_ERROR(5018);
26 -->expecterror ER_SP_DOES_NOT_EXIST
27 -->recvresult
28
29 -->stmtsql DO MYSQLX_ERROR(5018, 5017);
30 -->expecterror ER_CANT_INITIALIZE_UDF
31 -->recvresult
32
33 -->stmtsql DO MYSQLX_ERROR('abc');
34 -->expecterror ER_CANT_INITIALIZE_UDF
35 -->recvresult
36
37 -->stmtsql DO MYSQLX_ERROR(NULL);
38 -->expecterror ER_CANT_INITIALIZE_UDF
39 -->recvresult
40
41 -->stmtsql DO MYSQLX_ERROR(123.45);
42 -->expecterror ER_CANT_INITIALIZE_UDF
43 -->recvresult
44
45 -->expecterror ER_X_BAD_UPSERT_DATA
46 -->sql
47 DELIMITER ||
48 CREATE PROCEDURE my_procedure(IN nr_error INT)
49 BEGIN
50 SELECT 1;
51 SELECT MYSQLX_ERROR(nr_error);
52 SELECT 2;
53 END ||
54 DELIMITER ;
55
56 CALL my_procedure(5018);
57 -->endsql
58 EOF
59
60
61
62 --error 5018
63 SELECT MYSQLX_ERROR(5018);
64
65 --error 5018
66 DO MYSQLX_ERROR(5018);
67
68 --error 1305
69 CALL MYSQLX_ERROR(5018);
70
71 --error 1123
72 DO MYSQLX_ERROR(5018, 5017);
73
74 --error 1123
75 DO MYSQLX_ERROR('abc');
76
77 --error 1123
78 DO MYSQLX_ERROR(NULL);
79
80 --error 1123
81 DO MYSQLX_ERROR(123.45);
82
83 DELIMITER ||;
84 CREATE PROCEDURE my_procedure(IN nr_error INT)
85 BEGIN
86 SELECT 1;
87 DO MYSQLX_ERROR(nr_error);
88 SELECT 2;
89 END ||
90 DELIMITER ;||
91
92 --error 5018
93 CALL my_procedure(5018);
94 DROP PROCEDURE my_procedure;
95
96
97
98 exec $MYSQLXTEST
99 -ux_root --password=''
100 --file=$MYSQL_TMP_DIR/udf_mysqlx_error.xpl 2>&1;
101
102 ## Cleanup
103 --source ../include/xplugin_cleanup.inc
104 DROP PROCEDURE my_procedure;