This bug is found using Java and the MM.MySQL driver, but I do not think it is actually caused by the JDBC driver but rather comes from the MySQL daemon. However, I am sending to both lists in case it is a driver problem.

The Last Insert ID can, of course, be retrieved by executing the query SELECT LAST_INSERT_ID(). However, MM.MySQL also offers the shortcut Statement.getLastInsertID(), which I prefer to use believing it to be quicker. This normally works. However, it seems to fail after executing a command of the form INSERT INTO table VALUES (...), (...), ..., (...) After executing this command, getLastInsertID() returns a value of 0, whereas SELECT LAST INSERT_ID returns the correct value.

I attach a Java test program which demonstrates the fault. It should be compiled then run using java AITest <hostname - often 127.0.0.1> <databasename - usually test> <username> {<password>}

(See attached file: AITest.java)

OS: Windows 2000 MySQL: 4.0.2-alpha-max-nt, binary download MM.MySQL: 1-14 Java: j2sdk 1.4.0_01

Alec Cawley

mysql, query