mirror of
https://github.com/MariaDB/server.git
synced 2026-02-24 19:49:01 +01:00
afbad3b02b
This patch removes MASTER_SSL_VERIFY_SERVER_CERT from the list reserved_keyword_udt_not_param_type and adds it to keyword_func_sp_var_and_label in the parser. All other MASTER_SSL_* keywords are in this list. This allows MASTER_SSL_VERIFY_SERVER_CERT to be used unquoted when directly accessed via INFORMATION_SCHEMA.slave_status, as well as opens it up to be used as names in other places, e.g. stored procedures. Reviewed-by: Brandon Nesterenko <brandon.nesterenko@mariadb.com>
41 lines
1.2 KiB
Text
41 lines
1.2 KiB
Text
SELECT Master_SSL_Verify_Server_Cert FROM information_schema.slave_status LIMIT 1;
|
|
Master_SSL_Verify_Server_Cert
|
|
SELECT `Master_SSL_Verify_Server_Cert` FROM information_schema.slave_status LIMIT 1;
|
|
Master_SSL_Verify_Server_Cert
|
|
CREATE DATABASE db_is_slave_status;
|
|
USE db_is_slave_status;
|
|
CREATE TABLE t1 (
|
|
Master_SSL_Verify_Server_Cert INT
|
|
);
|
|
INSERT INTO t1 VALUES (123);
|
|
SELECT Master_SSL_Verify_Server_Cert FROM t1;
|
|
Master_SSL_Verify_Server_Cert
|
|
123
|
|
DROP TABLE t1;
|
|
CREATE PROCEDURE master_ssl_verify_server_cert()
|
|
BEGIN
|
|
SELECT 1;
|
|
END//
|
|
DROP PROCEDURE IF EXISTS master_ssl_verify_server_cert;
|
|
CREATE FUNCTION master_ssl_verify_server_cert()
|
|
RETURNS INT
|
|
RETURN 1;
|
|
DROP FUNCTION IF EXISTS master_ssl_verify_server_cert;
|
|
CREATE PROCEDURE sp()
|
|
master_ssl_verify_server_cert:BEGIN
|
|
SELECT 1;
|
|
END//
|
|
DROP PROCEDURE IF EXISTS sp;
|
|
CREATE PROCEDURE sp()
|
|
BEGIN
|
|
DECLARE master_ssl_verify_server_cert CHAR;
|
|
END//
|
|
DROP PROCEDURE IF EXISTS sp;
|
|
CREATE PROCEDURE sp()
|
|
BEGIN
|
|
DECLARE master_ssl_verify_server_cert CONDITION FOR SQLSTATE '02000';
|
|
DECLARE EXIT HANDLER FOR master_ssl_verify_server_cert SET @var2 = 1;
|
|
END//
|
|
DROP PROCEDURE IF EXISTS sp;
|
|
DROP DATABASE IF EXISTS db_is_slave_status;
|
|
# End of rpl_is_slave_status.test
|