# Derivate of is_triggers.test (not yet pushed)

--disable_warnings
DROP DATABASE IF EXISTS db_datadict;
--enable_warnings
CREATE DATABASE db_datadict;
--error 0,ER_CANNOT_USER
DROP   USER 'user4'@'localhost';
CREATE USER 'user4'@'localhost';
GRANT TRIGGER ON *.* TO 'user4'@'localhost';

USE db_datadict;
CREATE TABLE db_datadict.t1 (f1 INT, f2 INT, f3 INT);
CREATE TRIGGER trg1 BEFORE INSERT
ON db_datadict.t1 FOR EACH ROW SET @test_before = 2, new.f1 = @test_before;

--echo # Establish connection user4 (user=user4)
--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK
connect (user4, localhost, user4, , test);
--disable_abort_on_error
SHOW GRANTS FOR 'user4'@'localhost';
SHOW TABLES FROM db_datadict;
SHOW CREATE TABLE db_datadict.t1;
SHOW COLUMNS FROM db_datadict.t1;
SELECT table_schema,table_name FROM information_schema.tables
WHERE table_schema = 'db_datadict';
SELECT table_schema,table_name,column_name FROM information_schema.columns
WHERE table_schema = 'db_datadict';
SELECT f1 FROM db_datadict.t1;

SHOW TRIGGERS LIKE 't1';
SELECT event_object_schema,event_object_table,action_statement
FROM information_schema.triggers
WHERE trigger_name = 'trg1';

--echo # Switch to connection default and close connections user1 - user4
connection default;
disconnect user4;
DROP USER 'user4'@'localhost';
DROP DATABASE db_datadict;