Bug #35297 SHOW CREATE EVENT does not show the DEFINER

Description:
SHOW CREATE EVENT output does not include the DEFINER clause, even if is specified in the CREATE EVENT statement.

How to repeat:
Test script:

DROP EVENT IF EXISTS myevent;
CREATE DEFINER = CURRENT_USER EVENT myevent
ON SCHEDULE EVERY 15 SECOND DO SET @x = 1;
SHOW CREATE EVENT myevent\G
SELECT * FROM mysql.event WHERE name = 'myevent'\G

Result of running script:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 80
Server version: 5.1.24-rc-debug-log 

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DROP EVENT IF EXISTS myevent;
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE DEFINER = CURRENT_USER EVENT myevent
    -> ON SCHEDULE EVERY 15 SECOND DO SET @x = 1;
Query OK, 0 rows affected (0.02 sec)

mysql> SHOW CREATE EVENT myevent\G
*************************** 1. row ***************************
               Event: myevent
            sql_mode: 
           time_zone: SYSTEM
        Create Event: CREATE EVENT `myevent` ON SCHEDULE EVERY 15 SECOND STARTS '2008-03-14 11:11:18' ON COMPLETION NOT PRESERVE ENABLE DO SET @x = 1
character_set_client: latin1
collation_connection: latin1_swedish_ci
  Database Collation: latin1_swedish_ci
1 row in set (0.00 sec)

mysql> SELECT * FROM mysql.event WHERE name = 'myevent'\G
*************************** 1. row ***************************
                  db: test
                name: myevent
                body: SET @x = 1
             definer: paul@localhost
          execute_at: NULL
      interval_value: 15
      interval_field: SECOND
             created: 2008-03-14 11:11:18
            modified: 2008-03-14 11:11:18
       last_executed: 2008-03-14 16:11:18
              starts: 2008-03-14 16:11:18
                ends: NULL
              status: ENABLED
       on_completion: DROP
            sql_mode: 
             comment: 
          originator: 1
           time_zone: SYSTEM
character_set_client: latin1
collation_connection: latin1_swedish_ci
        db_collation: latin1_swedish_ci
           body_utf8: SET @x = 1
1 row in set (0.01 sec)

Note that the event table does include the definer, so the information is available.

Thank you for the bug report.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70468

Pushed into 6.0-runtime.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/70757

2756 Konstantin Osipov	2009-03-28
      Bug#35297 SHOW CREATE EVENT does not show the DEFINER:
      update test result after a merge from now.
      modified:
        mysql-test/suite/backup/r/backup_client.result
        mysql-test/suite/backup/r/backup_objects_dependency.result

Pushed into 6.0.11-alpha (revid:davi.arnaut@sun.com-20090331130058-yonsevjt1833wt5o) (version source revid:kostja@sun.com-20090328084255-sz9v2o9kmpfe7g17) (merge vers: 6.0.11-alpha) (pib:6)

Bug #44011 was marked as duplicate of this one.

Noted in 6.0.11 changelog.

SHOW CREATE EVENT output did not include the DEFINER clause.

Pushed into 6.0.14-alpha (revid:alik@sun.com-20091031081410-qkxmjsdzjmj840aq) (version source revid:guilhem@mysql.com-20091010123356-qfouds7ucvkvbczt) (merge vers: 6.0.14-alpha) (pib:13)

Already fixed in earlier 6.0.x.

Setting report to NDI pending push to 5.5.x.

Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:mikael@mysql.com-20091102100915-a2nbfxaqprpgptfw) (merge vers: 5.5.0-beta) (pib:13)

Noted in 5.5.0 changelog.