MySql bug

At 16:15 27/12/2002 +0100, you wrote:
Hi,
>Hi!
>
>I have noticed a bug in embedded version of MySql
>(using the version 4.0.6, windows platform, dll version of libmysqld).
>
>Problem is that query "DROP TABLE IF EXISTS table_name" causes application
>crash when the table does not exist.
>Can you please verify or fix this ?

First I would like to ask you when you find an issue with MySQL
send also for bugs@lists.mysql.com the report and when possible
with a test case, more information you find in our Manual. The
reason for this is that there are in MySQL specialized developers
for some specified stuff (the embedded server is one of them),
also the fix should be scheduled and more fast resolved when
all the team know the bug.

Just now I am making testing with 4.0.7 and tested the above
issue:

C:\mysql\Embedded\DLL\release>mysql-server
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.7-gamma-embedded

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

mysql> use test;
Database changed
mysql> create table mytable (id int);
Query OK, 0 rows affected (0.02 sec)

mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
Empty set (0.01 sec)

mysql> drop table if exists mytable;
Query OK, 0 rows affected (0.00 sec)

Please if possible test the application with 4.0.7 (if you
have problem with slow internet connection I can send you
in separate e-mail only the libmysqld.dll). If the issue
continue, what language application are you using ?
Is possible you send me the standalone binary or a small
application which can reproduce the crash ?

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ S=E3o Paulo - Brazil
<___/ www.mysql.com=20


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13366@lists.mysql.com
To unsubscribe, e-mail