Bug #11055 information_schema: routines.sql_data_access has wrong value

Description:
In information_schema.routines, the possible values of the sql_data_access column are:
'NO SQL', 'CONTAINS SQL', 'READS SQL DATA', 'MODIFIES SQL DATA'.
But the value I see is: ''.

How to repeat:
mysql> create procedure pix () modifies sql data set @a = 5;
Query OK, 0 rows affected (0.01 sec)

mysql> select sql_data_access from information_schema.routines where specific_name='pix';
+-----------------+
| sql_data_access |
+-----------------+
|                 |
+-----------------+
1 row in set (0.03 sec)

I was able to reproduce this using 5.0.7 from bk:

mysql> create procedure pix () modifies sql data set @a = 5;
Query OK, 0 rows affected, 2 warnings (0.02 sec)

mysql> select sql_data_access from information_schema.routines where
    -> specific_name='pix';
+-----------------+
| sql_data_access |
+-----------------+
|                 |
+-----------------+
1 row in set (0.00 sec)

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/internals/25677

Fixed in 5.0.8

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/internals/26064

Documented in 5.0.8 changelog.