#
# Bug#45235: 5.1 does not support 5.0-only syntax triggers in any way
#
let $MYSQLD_DATADIR=`SELECT @@datadir`;
--echo $MYSQLD_DATADIR

CREATE TABLE t1 ( a INT );

--write_file $MYSQLD_DATADIR/test/tx.TRN
TYPE=TRIGGERNAME
trigger_table=t1
EOF

--write_file $MYSQLD_DATADIR/test/t1.TRG
TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER tx BEFORE INSERT ON t1 FOR EACH ROW DELETE FROM t1 a USING t1 a'
sql_modes=0
definers='root@localhost'
EOF

SHOW TRIGGERS;
DROP TRIGGER tx;
DROP TABLE t1;