adding a Bin node to emit mysql BINARY keywords

3 files changed, 9 insertions, 0 deletions

diff --git a/lib/arel/nodes/unary.rb b/lib/arel/nodes/unary.rb
index 1b1dcb1053..1c834913fa 100644
--- a/lib/arel/nodes/unary.rb
+++ b/lib/arel/nodes/unary.rb
@@ -10,6 +10,7 @@ module Arel
     end
 
     %w{
+      Bin
       Group
       Grouping
       Having
diff --git a/lib/arel/visitors/mysql.rb b/lib/arel/visitors/mysql.rb
index 4f029245ac..763cf11aad 100644
--- a/lib/arel/visitors/mysql.rb
+++ b/lib/arel/visitors/mysql.rb
@@ -2,6 +2,10 @@ module Arel
   module Visitors
     class MySQL < Arel::Visitors::ToSql
       private
+      def visit_Arel_Nodes_Bin o
+        "BINARY #{visit o.expr}"
+      end
+
       def visit_Arel_Nodes_Lock o
         visit o.expr
       end
diff --git a/lib/arel/visitors/to_sql.rb b/lib/arel/visitors/to_sql.rb
index d1175df2a0..061e46a436 100644
--- a/lib/arel/visitors/to_sql.rb
+++ b/lib/arel/visitors/to_sql.rb
@@ -133,6 +133,10 @@ key on UpdateManager using UpdateManager#key=
         ].compact.join ' '
       end
 
+      def visit_Arel_Nodes_Bin o
+        visit o.expr
+      end
+
       def visit_Arel_Nodes_With o
         "WITH #{o.children.map { |x| visit x }.join(', ')}"
       end