INSERT INTO ... SELECT not inserting all rows

Dear All

I'm trying to insert a bunch of data from TableA in TableB by doing

SELECT INTO TableB (fieldA, fieldB, ...)
SELECT fieldA, fieldB, ... FROM TableA GROUP BY fieldA, fieldC, ...
ON DUPLICATE KEY UPDATE fieldZ =3D VALUES(fieldZ);

On my PC this works fine. But on the Server, not all rows get inserted.

When I execute the Query multiple times, the following output is =
generated (there is the same data in the Tables on the Server and the =
PC):

===3DServer===3D
Run 1:
Query OK, 54 rows affected (0.11 sec)
Records: 864 Duplicates: 27 Warnings: 0
Run 2:
Query OK, 130 rows affected (0.07 sec)
Records: 864 Duplicates: 65 Warnings: 0


===3DPC===3D
Run 1:
Query OK, 558 rows affected (0.30 sec)
Records: 864 Duplicates: 232 Warnings: 0
Run 2:
Query OK, 0 rows affected (0.08 sec)
Records: 864 Duplicates: 0 Warnings: 0


On the PC, all data is inserted and the second run doesn't affect any =
rows. But on the Server, this is not the case.

Can someone help me to debug the problem further? Is there a known issue =
for the used mysql version? Do I have to tune the configuration?

The strange thing is, that I didn't notice any error-message in the logs =
or the query window.


Mysql versions used:
PC: Ver 5.0.51b-community-nt for Win32 on ia32 (MySQL Community Edition =
(GPL))
Server: mysqld Ver 5.0.38-Ubuntu_0ubuntu1-log for pc-linux-gnu on i486 =
(Ubuntu 7.04 distribution)

Thank you very much for any assistance and Kind regards

Andreas=A0Müller


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg