Debian Codegraph @

mysql-test/suite/x/r/udf_mysqlx_error.result

raw
1 SELECT MYSQLX_ERROR(5018);
2 ERROR HY000: Mysqlx internal error
3 DO MYSQLX_ERROR(5018);
4 ERROR HY000: Mysqlx internal error
5 CALL MYSQLX_ERROR(5018);
6 ERROR 42000: PROCEDURE test.MYSQLX_ERROR does not exist
7 DO MYSQLX_ERROR(5018, 5017);
8 ERROR HY000: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument
9 DO MYSQLX_ERROR('abc');
10 ERROR HY000: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument
11 DO MYSQLX_ERROR(NULL);
12 ERROR HY000: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument
13 DO MYSQLX_ERROR(123.45);
14 ERROR HY000: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument
15 CREATE PROCEDURE my_procedure(IN nr_error INT)
16 BEGIN
17 SELECT 1;
18 DO MYSQLX_ERROR(nr_error);
19 SELECT 2;
20 END ||
21 CALL my_procedure(5018);
22 1
23 1
24 ERROR HY000: Mysqlx internal error
25 DROP PROCEDURE my_procedure;
26 RUN SELECT MYSQLX_ERROR(5018);
27 Got expected error: Mysqlx internal error (code 5018)
28 RUN DO MYSQLX_ERROR(5018);
29 Got expected error: Mysqlx internal error (code 5018)
30 RUN CALL MYSQLX_ERROR(5018);
31 Got expected error: No database selected (code 1046)
32 RUN USE test;
33
34 0 rows affected
35 RUN CALL MYSQLX_ERROR(5018);
36 Got expected error: PROCEDURE test.MYSQLX_ERROR does not exist (code 1305)
37 RUN DO MYSQLX_ERROR(5018, 5017);
38 Got expected error: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument (code 1123)
39 RUN DO MYSQLX_ERROR('abc');
40 Got expected error: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument (code 1123)
41 RUN DO MYSQLX_ERROR(NULL);
42 Got expected error: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument (code 1123)
43 RUN DO MYSQLX_ERROR(123.45);
44 Got expected error: Can't initialize function 'mysqlx_error'; Function expect only one numeric argument (code 1123)
45 RUN CREATE PROCEDURE my_procedure(IN nr_error INT)
46 BEGIN
47 SELECT 1;
48 SELECT MYSQLX_ERROR(nr_error);
49 SELECT 2;
50 END
51
52 0 rows affected
53 RUN CALL my_procedure(5018)
54 1
55 1
56 While executing CALL my_procedure(5018):
57 Got expected error: Mysqlx internal error (code 5018)
58 Mysqlx.Ok {
59 msg: "bye!"
60 }
61 ok
62 Warnings:
63 Warning 4005 User 'x_root'@'localhost' is referenced as a definer account in a stored routine.
64 DROP PROCEDURE my_procedure;