Debian Codegraph @

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

raw
1 ## Test of user defined function mysqlx_get_prepared_statement_id
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_get_prepared_statement_id.xpl
9 -->import assert_select.macro
10 -->quiet
11
12 -->macro Prepare_stmt %CLIENT_ID%
13 Mysqlx.Prepare.Prepare {
14 stmt_id: %CLIENT_ID%
15 stmt: {
16 type: FIND
17 find: {
18 collection { name: "user" schema: "mysql" }
19 data_model: TABLE
20 projection {
21 source {
22 type: LITERAL literal {
23 type: V_OCTETS v_octets {
24 value: "%CLIENT_ID%"
25 }
26 }
27 }
28 }
29 }
30 }
31 }
32 -->recvok
33 -->endmacro
34
35 -->callmacro Prepare_stmt 4
36 -->callmacro Prepare_stmt 6
37 -->callmacro Prepare_stmt 8
38 -->callmacro Prepare_stmt 10
39 -->callmacro Prepare_stmt 12
40 -->callmacro Prepare_stmt 14
41
42
43 -->callmacro Assert_select Value null SELECT MYSQLX_GET_PREPARED_STATEMENT_ID(3) as Value
44
45 -->callmacro Assert_select Value 1 SELECT MYSQLX_GET_PREPARED_STATEMENT_ID(4) as Value
46
47 -->stmtsql DO MYSQLX_GET_PREPARED_STATEMENT_ID(6);
48 -->recvresult
49
50 -->stmtsql CALL MYSQLX_GET_PREPARED_STATEMENT_ID(8);
51 -->expecterror ER_NO_DB_ERROR
52 -->recvresult
53
54 -->stmtsql USE test;
55 -->recvresult
56
57 -->stmtsql CALL MYSQLX_GET_PREPARED_STATEMENT_ID(10);
58 -->expecterror ER_SP_DOES_NOT_EXIST
59 -->recvresult
60
61 -->stmtsql DO MYSQLX_GET_PREPARED_STATEMENT_ID(12, 1)
62 -->expecterror ER_CANT_INITIALIZE_UDF
63 -->recvresult
64
65 -->stmtsql DO MYSQLX_GET_PREPARED_STATEMENT_ID('abc')
66 -->expecterror ER_CANT_INITIALIZE_UDF
67 -->recvresult
68
69 -->stmtsql DO MYSQLX_GET_PREPARED_STATEMENT_ID(NULL);
70 -->expecterror ER_CANT_INITIALIZE_UDF
71 -->recvresult
72
73 -->stmtsql DO MYSQLX_GET_PREPARED_STATEMENT_ID(123.45);
74 -->expecterror ER_CANT_INITIALIZE_UDF
75 -->recvresult
76
77 -->sql
78 DELIMITER ||
79 CREATE PROCEDURE my_procedure(IN id INT)
80 BEGIN
81 SELECT 'begin';
82 SELECT MYSQLX_GET_PREPARED_STATEMENT_ID(id);
83 SELECT 'end';
84 END ||
85 DELIMITER ;
86
87 CALL my_procedure(14);
88
89 DROP PROCEDURE my_procedure;
90 -->endsql
91 EOF
92
93
94 # there is no xplugin client; always NULL expected
95 --let $assert_text= Validation of MYSQLX_GET_PREPARED_STATEMENT_ID(1)
96 --let $assert_cond= [SELECT MYSQLX_GET_PREPARED_STATEMENT_ID(1) AS Value, Value, 1] IS NULL
97 --source include/assert.inc
98
99 --let $assert_text= Validation of MYSQLX_GET_PREPARED_STATEMENT_ID(2)
100 --let $assert_cond= [SELECT MYSQLX_GET_PREPARED_STATEMENT_ID(2) AS Value, Value, 1] IS NULL
101 --source include/assert.inc
102
103
104 exec $MYSQLXTEST
105 -ux_root --password=''
106 --file=$MYSQL_TMP_DIR/udf_mysqlx_get_prepared_statement_id.xpl 2>&1;
107
108 ## Cleanup
109 --source ../include/xplugin_cleanup.inc