Provide an option to tell mysql "set option SQL_BIG_TABLES=1". This

is necessary for very big queries, but it will slow things up some
otherwise.

2 files changed, 8 insertions, 0 deletions

diff --git a/buglist.cgi b/buglist.cgi
index bd83f34ed..4727afca6 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -461,6 +461,9 @@ if ($serverpush) {
     }
 }
 
+if (Param('expectbigqueries')) {
+    SendSQL("set option SQL_BIG_TABLES=1");
+}
 SendSQL($query);
 
 my $count = 0;
diff --git a/defparams.pl b/defparams.pl
index f5b3d4198..ac19dcf09 100644
--- a/defparams.pl
+++ b/defparams.pl
@@ -292,5 +292,10 @@ DefParam("usebrowserinfo",
 	 "b",
 	 1);
 
+DefParam("expectbigqueries",
+         "If this is on, then we will tell mysql to <tt>set option SQL_BIG_TABLES=1</tt> before doing queries on bugs.  This will be a little slower, but one will not get the error <tt>The table ### is full</tt> for big queries that require a big temporary table.",
+         "b",
+         0);
+
 1;