summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB/Mysql.pm
diff options
context:
space:
mode:
Diffstat (limited to 'Bugzilla/DB/Mysql.pm')
-rw-r--r--Bugzilla/DB/Mysql.pm6
1 files changed, 4 insertions, 2 deletions
diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm
index d9e6a2510..3bcd74389 100644
--- a/Bugzilla/DB/Mysql.pm
+++ b/Bugzilla/DB/Mysql.pm
@@ -66,9 +66,11 @@ sub new {
bless ($self, $class);
# Bug 321645 - disable MySQL strict mode, if set
- my $sql_mode = $self->selectrow_array('SELECT @@sql_mode');
+ my ($var, $sql_mode) = $self->selectrow_array(
+ "SHOW VARIABLES LIKE 'sql\\_mode'");
+
if ($sql_mode) {
- # STRICT_TRANS_TABLE or STICT_ALL_TABLES enable MySQL strict mode,
+ # STRICT_TRANS_TABLE or STRICT_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 =