From 2c95c39e9345ef50a7e9c3ad573857b1d358e04a Mon Sep 17 00:00:00 2001
From: Kazuya NUMATA <numata@gmail.com>
Date: Thu, 25 Dec 2014 12:58:42 +0900
Subject: {Matches,DoesNotMatch} support the ESCAPE clause with PostgreSQL

to_SQL already has supported the ESCAPE clause in #318.
PostgreSQL can use the ESCAPE clause too.
---
 test/visitors/test_postgres.rb | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'test')

diff --git a/test/visitors/test_postgres.rb b/test/visitors/test_postgres.rb
index 368feb5977..d6de216d91 100644
--- a/test/visitors/test_postgres.rb
+++ b/test/visitors/test_postgres.rb
@@ -58,6 +58,13 @@ module Arel
           }
         end
 
+        it "can handle ESCAPE" do
+          node = @table[:name].matches('foo!%', '!')
+          compile(node).must_be_like %{
+            "users"."name" ILIKE 'foo!%' ESCAPE '!'
+          }
+        end
+
         it 'can handle subqueries' do
           subquery = @table.project(:id).where(@table[:name].matches('foo%'))
           node = @attr.in subquery
@@ -75,6 +82,13 @@ module Arel
           }
         end
 
+        it "can handle ESCAPE" do
+          node = @table[:name].does_not_match('foo!%', '!')
+          compile(node).must_be_like %{
+            "users"."name" NOT ILIKE 'foo!%' ESCAPE '!'
+          }
+        end
+
         it 'can handle subqueries' do
           subquery = @table.project(:id).where(@table[:name].does_not_match('foo%'))
           node = @attr.in subquery
-- 
cgit v1.2.3