~drizzle-trunk/drizzle/development

--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