summaryrefslogtreecommitdiff
path: root/mysql-test/main/ps_missed_cmds_bin_prot.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2021-06-16 16:18:15 +0200
committerSergei Golubchik <serg@mariadb.org>2021-06-17 19:30:24 +0200
commit12bcbfc9780e6c78993fd97818fc87516a4da6a1 (patch)
treec9616856144452a1d367ab627cd866ab4dd79456 /mysql-test/main/ps_missed_cmds_bin_prot.test
parentaedf3143339b588bc54eaa1c4f2708b9ba0f8e62 (diff)
downloadmariadb-git-12bcbfc9780e6c78993fd97818fc87516a4da6a1.tar.gz
MDEV-16708: extract nonembedded part of the test into a separate file
Diffstat (limited to 'mysql-test/main/ps_missed_cmds_bin_prot.test')
-rw-r--r--mysql-test/main/ps_missed_cmds_bin_prot.test29
1 files changed, 0 insertions, 29 deletions
diff --git a/mysql-test/main/ps_missed_cmds_bin_prot.test b/mysql-test/main/ps_missed_cmds_bin_prot.test
index 10ce9ebd60a..f36385cc079 100644
--- a/mysql-test/main/ps_missed_cmds_bin_prot.test
+++ b/mysql-test/main/ps_missed_cmds_bin_prot.test
@@ -219,35 +219,6 @@ CREATE SERVER s FOREIGN DATA WRAPPER mysql OPTIONS (USER 'u1', HOST '127.0.0.1')
ALTER SERVER s OPTIONS (USER 'u2');
DROP SERVER s;
---echo # Test case 18: Check that the statements CREATE EVENT/ALTER EVENT/
---echo # DROP EVENT can be executed as a prepared statement
-
---echo # Create the event e1 that specifies time in past. Such event is created
---echo # just for the sake of its existence and never will be triggered.
---echo # Disable warnings temprorary in order to hide the following warnings
---echo # generated in result of execution the 'CREATE EVENT' statement:
---echo # "1544 | Event execution time is in the past. Event has been disabled"
---echo # "1105 | Event scheduler is switched off, use SET GLOBAL event_scheduler=ON to enable it."
-
---disable_warnings
-
-CREATE EVENT e1 ON SCHEDULE AT CURRENT_TIMESTAMP - INTERVAL 1 DAY ON COMPLETION PRESERVE DO SET @a=1;
-
-ALTER EVENT e1 COMMENT 'New comment';
-
-DROP EVENT IF EXISTS e1;
-
---enable_warnings
-
---echo # Test case 19: Check that the statement 'SHOW RELAYLOG EVENTS' can be
---echo # executed as a prepared statement.
-SHOW RELAYLOG EVENTS;
-
---echo # Test case 20: Check the the statement 'EXECUTE IMMEDIATE'
---echo # can be executed as a prepared statement
-
-EXECUTE IMMEDIATE 'SELECT 1';
-
--echo # Test Test case 21: Check the statements 'BACKUP'/'BACKUP STAGE'
--echo # can be executed as a prepared statement
CREATE TABLE t1 (a INT);