Bug #12278 Triggers: packet error if select from information_schema

Submitted: 29 Jul 2005 20:48 Modified: 15 Aug 2005 17:29
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.11-beta-debug OS:Linux (SUSE 9.2)
Assigned to: Dmitry Lenev CPU Architecture:Any

[29 Jul 2005 20: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 9:11] Dmitry Lenev
This bug is fixed in version 5.0.12 by the same patch as bug #10055.
[15 Aug 2005 17:29] Mike Hillyer
Added reference to this bug to 10055 changelog entry.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.