Bug #12278 Triggers: packet error if select from information_schema
Submitted: 29 Jul 2005 22:48 Modified: 15 Aug 2005 19:29
Reporter: Peter Gulutzan
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:5.0.11-beta-debug OS:Linux (SUSE 9.2)
Assigned to: Dmitri Lenev Target Version:

[29 Jul 2005 22:48] Peter Gulutzan 
Description:
I create a before-insert trigger, which accesses information_schema.
I insert, twice.
I see "Packets out of order".

How to repeat:
mysql> delimiter //

mysql> create table tj (s1 int, s2 char(5))//
Query OK, 0 rows affected (0.00 sec)

mysql> create trigger tj_bi before insert on tj for each row set @a = ( select count(*)
from information_schema.triggers)//
Query OK, 0 rows affected (0.01 sec)

mysql> insert into tj values (0,'a')//
Query OK, 1 row affected, 68 warnings (0.38 sec)

mysql> insert into tj values (0,'a')//
Query OK, 0 rows affected, 28265 warnings (0.01 sec)

Packets out of order (Found: 2, expected 1)
[9 Aug 2005 11:11] Dmitri Lenev 
This bug is fixed in version 5.0.12 by the same patch as bug #10055.
[15 Aug 2005 19:29] Mike Hillyer 
Added reference to this bug to 10055 changelog entry.