summaryrefslogtreecommitdiff
path: root/mysql-test/t/status2.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/status2.test
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/t/status2.test')
-rw-r--r--mysql-test/t/status2.test68
1 files changed, 0 insertions, 68 deletions
diff --git a/mysql-test/t/status2.test b/mysql-test/t/status2.test
deleted file mode 100644
index 2d1541c54f2..00000000000
--- a/mysql-test/t/status2.test
+++ /dev/null
@@ -1,68 +0,0 @@
---source include/not_embedded.inc
-
---echo #
---echo # Bug#24289 Status Variable "Questions" gets wrong values with Stored Routines
---echo #
-FLUSH STATUS;
-DELIMITER $$;
-CREATE FUNCTION testQuestion() RETURNS INTEGER
-BEGIN
- DECLARE foo INTEGER;
- DECLARE bar INTEGER;
- SET foo=1;
- SET bar=2;
- RETURN foo;
-END $$
-CREATE PROCEDURE testQuestion2()
-BEGIN
- SELECT 1;
-END $$
-DELIMITER ;$$
---disable_warnings
-DROP TABLE IF EXISTS t1,t2;
---enable_warnings
-CREATE TABLE t1 (c1 INT);
-CREATE TABLE t2 (c1 INT);
-CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND
- DO INSERT INTO t1 VALUES(1);
-
---echo Assert Questions == 7
-SHOW STATUS LIKE 'Questions';
-SELECT testQuestion();
---echo Assert Questions == 9
-SHOW STATUS LIKE 'Questions';
-CALL testQuestion2();
---echo Assert Questions == 11
-SHOW STATUS LIKE 'Questions';
-SELECT 1;
---echo Assert Questions == 13
-SHOW STATUS LIKE 'Questions';
-connect (con1,localhost,root,,);
-connection con1;
-SELECT 1;
-connection default;
-disconnect con1;
---echo Assert Questions == 14
-SHOW STATUS LIKE 'Questions';
-DELIMITER $$;
-CREATE TRIGGER trigg1 AFTER INSERT ON t1
- FOR EACH ROW BEGIN
- INSERT INTO t2 VALUES (1);
- END;
-$$
-DELIMITER ;$$
---echo Assert Questions == 16
-SHOW STATUS LIKE 'Questions';
-INSERT INTO t1 VALUES (1);
---echo Assert Questions == 18
-SHOW STATUS LIKE 'Questions';
-# TODO: Uncomment the lines below when FLUSH GLOBAL STATUS is implemented.
-# FLUSH STATUS;
-# SHOW GLOBAL STATUS LIKE 'Questions';
-DROP PROCEDURE testQuestion2;
-DROP TRIGGER trigg1;
-DROP FUNCTION testQuestion;
-DROP EVENT ev1;
-DROP TABLE t1,t2;
---echo End of 6.0 tests
-