From 2567b72f9582c14a591156653e2b656d48200b11 Mon Sep 17 00:00:00 2001
From: Aaron Patterson <aaron.patterson@gmail.com>
Date: Wed, 20 Jul 2011 14:00:06 -0700
Subject: supressing nested parenthesis in multiple unions on mysql. thanks
 jhtwong. fixes #58

---
 lib/arel/visitors/mysql.rb | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

(limited to 'lib/arel')

diff --git a/lib/arel/visitors/mysql.rb b/lib/arel/visitors/mysql.rb
index 763cf11aad..70166a15c5 100644
--- a/lib/arel/visitors/mysql.rb
+++ b/lib/arel/visitors/mysql.rb
@@ -2,6 +2,28 @@ module Arel
   module Visitors
     class MySQL < Arel::Visitors::ToSql
       private
+      def visit_Arel_Nodes_Union o, suppress_parens = false
+        left_result = case o.left
+                      when Arel::Nodes::Union
+                        visit_Arel_Nodes_Union o.left, true
+                      else
+                        visit o.left
+                      end
+
+        right_result = case o.right
+                       when Arel::Nodes::Union
+                         visit_Arel_Nodes_Union o.right, true
+                       else
+                         visit o.right
+                       end
+
+        if suppress_parens
+          "#{left_result} UNION #{right_result}"
+        else
+          "( #{left_result} UNION #{right_result} )"
+        end
+      end
+
       def visit_Arel_Nodes_Bin o
         "BINARY #{visit o.expr}"
       end
-- 
cgit v1.2.3