Bug #12877 information_schema.TRIGGERS.ACTION_STATEMENT misses one space

• Submitted: 30 Aug 2005 12:43
• Modified: 1 Sep 2005 13:33
• Reporter: MySQL-Front Team
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.11-beta/BK source 5.0
• OS: Windows (Windows XP/Linux)
• CPU Architecture: Any

[30 Aug 2005 12:43] MySQL-Front Team

Description:
I can't re-open a closed bug. Because of this I open this one.

Please follow my comments of this bug:
http://bugs.mysql.com/bug.php?id=12321

How to repeat:
http://bugs.mysql.com/bug.php?id=12321

[30 Aug 2005 15:06] MySQL Verification Team

I am not sure if that can be considered a bug, instead a feature request
for to have a formated output disregarding the layout of the create
command, how can see below:

mysql> CREATE TRIGGER testref BEFORE INSERT ON test1
    ->   FOR EACH ROW BEGIN
    ->     INSERT INTO test2 SET a2 = NEW.a1;
    ->     DELETE FROM test3 WHERE a3 = NEW.a1;
    ->     UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
    ->   END
    -> |
Query OK, 0 rows affected (0.03 sec)

mysql> SELECT ACTION_STATEMENT FROM information_schema.TRIGGERS;
+-----------------------------------------------------------------
| ACTION_STATEMENT
+-----------------------------------------------------------------
|  BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END |
|  SET NEW.f1=999

mysql> DELIMITER |
mysql>
mysql> CREATE TRIGGER testref BEFORE INSERT ON test1
    ->   FOR EACH ROW
    ->   BEGIN
    ->     INSERT INTO test2 SET a2 = NEW.a1;
    ->     DELETE FROM test3 WHERE a3 = NEW.a1;
    ->     UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
    ->   END
    -> |
Query OK, 0 rows affected (0.02 sec)

mysql> DELIMITER ;
mysql> SELECT ACTION_STATEMENT FROM information_schema.TRIGGERS;
+-----------------------------------------------------------------
| ACTION_STATEMENT
+-----------------------------------------------------------------
|
  BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END |
|  SET NEW.f1=999
+-----------------------------------------------------------------
2 rows in set (0.03 sec)

[30 Aug 2005 18:11] MySQL-Front Team

Please feel free to handle this bug like you want - it's your decision how you handle my present (report of a >bug<)...