Bug #17960 Drop user with stange ouptut

• Submitted: 6 Mar 2006 12:31
• Modified: 8 Mar 2006 15:41
• Reporter: Jean-Marie Renouard (OCA)
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• CPU Architecture: Any

[6 Mar 2006 12:31] Jean-Marie Renouard

Description:
mysql> select Host, User from user;
+-----------+------+
| Host      | User |
+-----------+------+
| %         | crl  |
| bladnoch  | root |
| localhost | root |
+-----------+------+
3 rows in set (0.00 sec)

mysql> DROP USER 'crl'@'localhost', 'crl'@'ubiquitoo', 'crl'@'blachnoch', 'crl'@'tamdhu'
    -> ;
ERROR 1396 (HY000): Operation DROP USER failed for 'crl'@'localhost','crl'@'ubiquitoo','crl'@'blachnoch','crl'@'tamdhu'
mysql> DROP USER 'crl'@'%'
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> select Host, User from user;
+-----------+------+
| Host      | User |
+-----------+------+
| bladnoch  | root |
| localhost | root |
+-----------+------+
2 rows in set (0.00 sec)

A user have been deleted but the output logs :
Query OK, 0 rows affected (0.00 sec)

How to repeat:
Play the same test

Suggested fix:
a small fix could be added !

[6 Mar 2006 13:27] Hartmut Holzgraefe

verified on 5.0 and 5.1, but i'm not sure whether this is really a bug,
esp. as GRANT always reports "0 Rows", too

These statements are not operating on tables (ok, internally they are
but that is not really relevant here) so a row count doesn't really make
sense here, the information that the statement succeded should be
sufficient

[6 Mar 2006 13:31] Jean-Marie Renouard

Ok but we have access to mysql database and in a other hand it is a administration statement.

I think it is a conceptual issue not really a bug :)

Enjoy

[8 Mar 2006 15:41] MySQL Verification Team

Thank you for the bug report. How Hartmut commented.