Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.0

Bug #1005 affectedRows returns 0 for 'load data infile'
Submitted: 2004-03-12 23:52 UTC
From: rex at seas dot ucla dot edu Assigned: danielc
Status: Closed Package: DB
PHP Version: 4.3.3 OS: SunOS server7 5.8 Generic_1085
Roadmaps: (Not assigned)    

 [2004-03-12 23:52 UTC] rex at seas dot ucla dot edu
Description: ------------ When using the mysql command of "LOAD DATA INFILE" and then checking how many rows were affected, I get a result of always zero. Reproduce code: --------------- $db = DB::connect($dsn); $sql = "load data infile 'test.txt' replace into table test (key,data)"; $result = $db->query($sql); $num_changes = $db->affectedRows(); Expected result: ---------------- The number of rows that are affected by the loading of data from the file.


 [2004-03-13 16:11 UTC] danielc
Good point. LOAD DATA statements now return TRUE from isManip() so should produce a row count from affectedRows(). Thanks.