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

Reply via email to