#98 [QB 1.0] After dropping a commit trigger successfully, the commit trigger still has affection on the tables.

[Jira Trac]

1. create a commit trigger as below
CREATE TRIGGER commit_trigger
BEFORE COMMIT
EXECUTE AFTER
INSERT INTO b (s_name, f_name) VALUES ('a','commit');;

2. set auto-commit off
3. insert a row and commit
4. drop TRIGGER commit_trigger
5. whatever you do dml, it will insert a row 'a','commit') into table b , even in select operation.

so the commit trigger still has affection on the tables.

and if you drop other trigger, and error show X_lock as attachment