LOAD DATA..REPLACE broken?

Bug #313391 reported by Amit Saha on 2009-01-03
2
Affects Status Importance Assigned to Milestone
PBXT
Undecided
Vladimir Kolesnikov

Bug Description

'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'

Related branches

Amit Saha (amit-saha) wrote :
Amit Saha (amit-saha) wrote :

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?

Changed in pbxt:
assignee: nobody → vkolesnikov
status: New → Incomplete
Amit Saha (amit-saha) wrote :

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

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

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

fixed earlier, update status

Changed in pbxt:
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers