adding a Bin node to emit mysql BINARY keywords

1 files changed, 23 insertions, 0 deletions

diff --git a/test/nodes/test_bin.rb b/test/nodes/test_bin.rb
new file mode 100644
index 0000000000..b06aeb0b0d
--- /dev/null
+++ b/test/nodes/test_bin.rb
@@ -0,0 +1,23 @@
+require 'helper'
+
+module Arel
+  module Nodes
+    class TestBin < MiniTest::Unit::TestCase
+      def test_new
+        assert Arel::Nodes::Bin.new('zomg')
+      end
+
+      def test_default_to_sql
+        viz  = Arel::Visitors::ToSql.new Table.engine
+        node = Arel::Nodes::Bin.new(Arel.sql('zomg'))
+        assert_equal 'zomg', viz.accept(node)
+      end
+
+      def test_mysql_to_sql
+        viz  = Arel::Visitors::MySQL.new Table.engine
+        node = Arel::Nodes::Bin.new(Arel.sql('zomg'))
+        assert_equal 'BINARY zomg', viz.accept(node)
+      end
+    end
+  end
+end