MySQL Bugs: #30358: mysqlimport seems to implicitly enable --ignore when --local is used

Bug #30358	mysqlimport seems to implicitly enable --ignore when --local is used
Submitted:	10 Aug 2007 12:57	Modified:	10 Aug 2007 13:17
Reporter:	Tobias Asplund	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
mysqlimport behaves differently with --local than without.
The flag (or at least one of them) that behaves different is the --ignore option, see below:

How to repeat:
# Cut and paste friendly script
mysql -e "CREATE DATABASE IF NOT EXISTS test"
mysql -e "CREATE TABLE bugtest ( a INT PRIMARY KEY ) ENGINE = MyISAM" test
mysql -e "INSERT INTO bugtest VALUES (1)" test
echo "1" > /tmp/bugtest.csv
mysql -e "SELECT * INTO OUTFILE 'bugtest.csv' FROM bugtest" test
mysqlimport test bugtest.csv
#mysqlimport: Error: Duplicate entry '1' for key 1, when using table: bugtest
mysqlimport --local test /tmp/bugtest.csv
#test.bugtest: Records: 1  Deleted: 0  Skipped: 1  Warnings: 0
rm /tmp/bugtest.csv 
# Also have to delete the bugtest.csv in $DATADIR/test
# Note that even if you run this last one with --help it doesn't show ignore as TRUE

http://dev.mysql.com/doc/refman/5.0/en/load-data.html
says:

With LOCAL, the default behavior is the same as if IGNORE is specified; this is because the server has no way to stop transmission of the file in the middle of the operation.
So, the original submission is !Bg

However, the --help output should still show that ignore is set to TRUE if local is set.

flupps@flupps:~$ mysqlimport --local --help
...
ignore                            FALSE
...

Thank you for the report.

Verified as described in last comment.