932
932
DROP USER 'no_rights'@'localhost';
933
933
DROP DATABASE db1;
936
# Bug#55421 Protocol::end_statement(): Assertion `0' on multi-table UPDATE IGNORE
937
# To reproduce a crash we need to provoke a trigger execution with
938
# the following conditions:
939
# - active SELECT statement during trigger execution
940
# (i.e. LEX::current_select != NULL);
941
# - IGNORE option (i.e. LEX::current_select->no_error == TRUE);
943
DROP DATABASE IF EXISTS mysqltest_db1;
946
CREATE DATABASE mysqltest_db1;
949
GRANT ALL ON mysqltest_db1.* TO mysqltest_u1@localhost;
951
--connect(con1,localhost,mysqltest_u1,,mysqltest_db1)
957
INSERT INTO t1 VALUES (1, 20);
959
CREATE TRIGGER mysqltest_db1.upd_t1
960
BEFORE UPDATE ON t1 FOR EACH ROW SET new.a2 = 200;
966
INSERT INTO t2 VALUES (2);
970
REVOKE ALL PRIVILEGES, GRANT OPTION FROM mysqltest_u1@localhost;
972
--error ER_TABLEACCESS_DENIED_ERROR
973
UPDATE IGNORE t1, t2 SET t1.a1 = 2, t2.a1 = 3 WHERE t1.a1 = 1 AND t2.a1 = 2;
976
DROP DATABASE mysqltest_db1;
977
DROP USER mysqltest_u1@localhost;
935
983
--echo End of 5.1 tests.