diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/t/status2.test | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-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.test | 68 |
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 - |