That's odd. I use MySQL as well and don't have this problem. I have version 4.0.20a-win. I'm on Win XP for development (Linux in production, although I haven't run the tests there recently).
What version of MySQL do you have? I agree it looks like a mysql bug, like it's caching the data. What if you quit the client after you recreate the database and then come back and do a select? *** Can anyone else run the MiddleKit test suite and report back? -Chuck On Sun, 6 Feb 2005 18:30:47 -0500, Winston Wolff wrote: >�Hello Chuck- > >�I'm getting errors. �Below is the output from the MKBasic test, as >�well as my LocalConfig.py. > >�All the tests complain about this: �ERROR 1062 (23000) at line 25: >�Duplicate entry '1' for key 1. �I think the problem is actually a >�bug in MySQL. �If you delete a database, and then recreate the >�database and recreate the tables, then the old data that was in >�that table is "magically" back there. �In other words: > >�mysql>�use MKBasic >�mysql>�select * from _MKClassIds; >�mysql>�drop database if exists MKBasic; >�mysql>�create database MKBasic; >�mysql>�use MKBasic; >�mysql>�show tables; >�Empty set (0.00 sec) > >�At this point we have dropped and recreated the database. �As soon >�as we recreate the table, the old data magically reappears: > >�mysql>�create table _MKClassIds ( >�->�id int not null primary key, >�->�name varchar(100) >�->�); >�Query OK, 0 rows affected (0.00 sec) >�mysql>�select * from _MKClassIds; >�+----+--------+ >�| id | name � | >�+----+--------+ >�| �1 | Thing �| >�| �2 | Person | >�+----+--------+ >�2 rows in set (0.00 sec) ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ Webware-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/webware-devel
