MySQL Forums
Forum List  »  Perl

Load data is ignoring sql_mode option
Posted by: Cory Twibell
Date: January 09, 2006 06:31PM

All,

Using mysql 5.0.17-pro with perl 5.8 and DBI 3002_4.
My server is started with sql_mode = STRICT_ALL_TABLES;

When doing $dbh->do ( qq(LOAD DATA LOCAL INFILE '<filename>' INTO TABLE $tbl
FIELDS TERMINATED BY ',')) or die $dbh->errstr;

No matter what values I enter in the text file( ie invalid date values, chars as integers), it never seems to fail. I even have no FILE privilege in the mysql.user table. It never fails to load the file... It seems like the mysql.user and sql_mode is just non-existent.

What gives?

Options: ReplyQuote


Subject
Written By
Posted
Load data is ignoring sql_mode option
January 09, 2006 06:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.