From 9b1749e4fab6dce06687b3610ee6fa049cf2c8f2 Mon Sep 17 00:00:00 2001 From: "olav%bkor.dhs.org" <> Date: Wed, 15 Nov 2006 04:51:04 +0000 Subject: Do commit-time fix: Add comment explaining the sql modes that are removed --- Bugzilla/DB/Mysql.pm | 3 +++ 1 file changed, 3 insertions(+) (limited to 'Bugzilla/DB') diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm index b3b1cba10..d9e6a2510 100644 --- a/Bugzilla/DB/Mysql.pm +++ b/Bugzilla/DB/Mysql.pm @@ -68,6 +68,9 @@ sub new { # Bug 321645 - disable MySQL strict mode, if set my $sql_mode = $self->selectrow_array('SELECT @@sql_mode'); if ($sql_mode) { + # STRICT_TRANS_TABLE or STICT_ALL_TABLES enable MySQL strict mode, + # causing bug 321645. TRADITIONAL sets these modes (among others) as + # well, so it has to be stipped as well my $new_sql_mode = join(",", grep {$_ !~ /^STRICT_(?:TRANS|ALL)_TABLES|TRADITIONAL$/} split(/,/, $sql_mode)); -- cgit v1.2.3-24-g4f1b