LOAD DATA..REPLACE broken?

[Amit Saha]

'The ld_unique_error3' and 'ld_unique_error3_local' test cases (attached) fails with the following:

mysqltest: At line 13: query 'LOAD DATA INFILE '../tmp/t1.dat' REPLACE
INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (@c1,c2)
SET c1 = @c1 % 2' failed: 1032: Can't find record in 't1'

[Vladimir Kolesnikov (vkolesnikov)]

Amit,

thanks for the report. However I cannot repro it because it looks an include file for the test scripts is missing:

mysqltest: At line 5: query 'LOAD DATA LOCAL INFILE 'suite/all/t/load_unique_error1.inc' INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (@c1,c2) SET c1 = @c1 % 2' failed: 2: File 'suite/all/t/load_unique_error1.inc' not found (Errcode: 2)

can you provide this file?

[Amit Saha (amit-saha)]

Sorry for not attaching it. Please find it attached now.

[Vladimir Kolesnikov (vkolesnikov)]

Amit,

thanks. Now I can repro the problem. We have met some issues with REPLACE before. MySQL can map REPLACE into differnet commands (UPDATE vs DELETE/INSERT) depending on some criteria, maybe there's some problem with this...

[Amit Saha (amit-saha)]

On 01/13/09 16:41, Vladimir Kolesnikov wrote:
> Amit,
>
> thanks. Now I can repro the problem. We have met some issues with
> REPLACE before. MySQL can map REPLACE into differnet commands (UPDATE vs
> DELETE/INSERT) depending on some criteria, maybe there's some problem
> with this...
>
> ** Changed in: pbxt
> Status: Incomplete => Confirmed
>

Thanks!

--
http://blogs.sun.com/amitsaha

[Vladimir Kolesnikov (vkolesnikov)]

fixed earlier, update status