Hi Thomas, well, yes it is a bug in handling multiple boolean values if more than one of them are evaluated to a null condition. You can overcome this problem by using the following syntax - I hope it is an applicable solution for you.
import table testtab update duplicates data instream file 'test.dat' NULL 'NULL' id 1 field1 2 DEFAULT NULL field2 3 DEFAULT NULL If you're familiar with ADABAS this DEFAULT NULL should be known. You need to mark all columns that you expect NULL values for with DEFAULT NULL. This will work if you have the same NULL value representation for all fields in your data file. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]