From 4d029e0d69cca6a7bf0458b9bf3f3f1f0945e467 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Fr=C3=A9d=C3=A9ric=20Buclin?= Date: Wed, 25 Dec 2013 09:59:34 +0100 Subject: [PATCH] Bug 870369: An error about longdescs.comment_id is thrown by MySQL 5.1 and older when upgrading to 4.4 if sql_auto_is_null = 1 r=wicked a=sgreen --- Bugzilla/DB/Mysql.pm | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm index e9ed13b2bc..c7ce1927a1 100644 --- a/Bugzilla/DB/Mysql.pm +++ b/Bugzilla/DB/Mysql.pm @@ -92,6 +92,10 @@ sub new { # into bugs_fulltext). $self->do('SET SESSION group_concat_max_len = 128000000'); + # MySQL 5.5.2 and older have this variable set to true, which causes + # trouble, see bug 870369. + $self->do('SET SESSION sql_auto_is_null = 0'); + return $self; } -- 2.47.2