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 Webware-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-devel