| 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: | |
| Category: | MySQL Server: Embedded Library ( libmysqld ) | Severity: | S2 (Serious) |
| Version: | 5.0 | OS: | |
| Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
[15 Mar 2005 16:06]
MySQL Verification Team
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.

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