Bug #9200 DROP USER crashes the embedded server
Submitted: 15 Mar 2005 15:49 Modified: 7 May 2005 8:04
Reporter: Matthias Leich Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S2 (Serious)
Version:5.0 OS:
Assigned to: Alexey Botchkov CPU Architecture:Any

[15 Mar 2005 15:49] Matthias Leich
Description:
The statement "DROP USER <any name>" crashes the embedded library 
version of mysqltest   with the following message
mysqltest_embedded: sql_parse.cc:4443: 
             bool mysql_execute_command(THD*): Assertion `0' failed.
mysqltest returned unexpected code 134, it has probably crashed

My environment:
   - Intel PC with Linux(SuSE 9.1)
   - MySQL compiled from source
        Version 5.0 ChangeSet@1.1801.1.18, 2005-03-15

Version 4.1 ChangeSet@1.2112, 2005-03-14 works correct and gives
query 'DROP USER Oscar' failed: 1268: Can't drop one or more of the requested users

How to repeat:
Please execute the statement above within  libmysqld/examples/mysqltest_embedded
[15 Mar 2005 16:06] Miguel Solorzano
mysql> drop user 'miguel';
mysql: sql_parse.cc:4443: bool mysql_execute_command(THD*): Assertion `0' failed.
Aborted
miguel@hegel:~/dbs/mysql-5.0/libmysqld/examples$
[7 May 2005 8:04] Alexey Botchkov
Default compilation of the embedded server doesn't have privilege control at all.
(you need --with-embedded-privilege-control option for configure to enable that).
So DROP USER command just doesn't supposed to work.
In debug build running of DROP USER falls on DBUG_ASSERT, in release build
it just doesn't nothing - think that is reasonable behaviour.