Debian Codegraph @

mysql-test/suite/rpl/t/rpl_is_slave_status.test

raw
1 #
2 # Test for MDEV-38194: Master_SSL_Verify_Server_Cert should not require identifier quoting
3 #
4
5 --source include/not_embedded.inc
6
7 # Select the column unquoted
8 SELECT Master_SSL_Verify_Server_Cert FROM information_schema.slave_status LIMIT 1;
9
10 # Select the column quoted
11 SELECT `Master_SSL_Verify_Server_Cert` FROM information_schema.slave_status LIMIT 1;
12
13
14 # Verify that stored procedures, variables, labels, and functions using the name
15 # Master_SSL_Verify_Server_Cert can be successfully created
16
17 CREATE DATABASE db_is_slave_status;
18
19 USE db_is_slave_status;
20
21 CREATE TABLE t1 (
22 Master_SSL_Verify_Server_Cert INT
23 );
24 INSERT INTO t1 VALUES (123);
25 SELECT Master_SSL_Verify_Server_Cert FROM t1;
26 DROP TABLE t1;
27
28
29 DELIMITER //;
30 CREATE PROCEDURE master_ssl_verify_server_cert()
31 BEGIN
32 SELECT 1;
33 END//
34 DELIMITER ;//
35
36 DROP PROCEDURE IF EXISTS master_ssl_verify_server_cert;
37
38 --disable_warnings
39 CREATE FUNCTION master_ssl_verify_server_cert()
40 RETURNS INT
41 RETURN 1;
42 --enable_warnings
43
44 DROP FUNCTION IF EXISTS master_ssl_verify_server_cert;
45
46
47 DELIMITER //;
48 CREATE PROCEDURE sp()
49 master_ssl_verify_server_cert:BEGIN
50 SELECT 1;
51 END//
52 DELIMITER ;//
53
54 DROP PROCEDURE IF EXISTS sp;
55
56
57 DELIMITER //;
58 CREATE PROCEDURE sp()
59 BEGIN
60 DECLARE master_ssl_verify_server_cert CHAR;
61 END//
62 DELIMITER ;//
63
64 DROP PROCEDURE IF EXISTS sp;
65
66
67 DELIMITER //;
68 CREATE PROCEDURE sp()
69 BEGIN
70 DECLARE master_ssl_verify_server_cert CONDITION FOR SQLSTATE '02000';
71 DECLARE EXIT HANDLER FOR master_ssl_verify_server_cert SET @var2 = 1;
72 END//
73 DELIMITER ;//
74
75 DROP PROCEDURE IF EXISTS sp;
76
77 DROP DATABASE IF EXISTS db_is_slave_status;
78
79 --echo # End of rpl_is_slave_status.test