From 7dcfc49b349377b86f4d7d0e0c804f4d19282d15 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Thu, 24 Jun 2010 12:45:37 -0400
Subject: [PATCH] fix test

---
 test/sql/test_compiler.py | 55 ++++++++++++++++++++++++++++++---------
 1 file changed, 43 insertions(+), 12 deletions(-)

diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py
index 9e85d2c744..b7e5d09531 100644
--- a/test/sql/test_compiler.py
+++ b/test/sql/test_compiler.py
@@ -633,18 +633,49 @@ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") A
 
     def test_like(self):
         for expr, check, dialect in [
-            (table1.c.myid.like('somstr'), "mytable.myid LIKE :myid_1", None),
-            (~table1.c.myid.like('somstr'), "mytable.myid NOT LIKE :myid_1", None),
-            (table1.c.myid.like('somstr', escape='\\'), "mytable.myid LIKE :myid_1 ESCAPE '\\'", None),
-            (~table1.c.myid.like('somstr', escape='\\'), "mytable.myid NOT LIKE :myid_1 ESCAPE '\\'", None),
-            (table1.c.myid.ilike('somstr', escape='\\'), "lower(mytable.myid) LIKE lower(:myid_1) ESCAPE '\\'", None),
-            (~table1.c.myid.ilike('somstr', escape='\\'), "lower(mytable.myid) NOT LIKE lower(:myid_1) ESCAPE '\\'", None),
-            (table1.c.myid.ilike('somstr', escape='\\'), "mytable.myid ILIKE %(myid_1)s ESCAPE '\\'", postgresql.PGDialect()),
-            (~table1.c.myid.ilike('somstr', escape='\\'), "mytable.myid NOT ILIKE %(myid_1)s ESCAPE '\\'", postgresql.PGDialect()),
-            (table1.c.name.ilike('%something%'), "lower(mytable.name) LIKE lower(:name_1)", None),
-            (table1.c.name.ilike('%something%'), "mytable.name ILIKE %(name_1)s", postgresql.PGDialect()),
-            (~table1.c.name.ilike('%something%'), "lower(mytable.name) NOT LIKE lower(:name_1)", None),
-            (~table1.c.name.ilike('%something%'), "mytable.name NOT ILIKE %(name_1)s", postgresql.PGDialect()),
+            (
+                table1.c.myid.like('somstr'), 
+                "mytable.myid LIKE :myid_1", None),
+            (
+                ~table1.c.myid.like('somstr'), 
+                "mytable.myid NOT LIKE :myid_1", None),
+            (
+                table1.c.myid.like('somstr', escape='\\'), 
+                "mytable.myid LIKE :myid_1 ESCAPE '\\'", 
+                None),
+            (
+                ~table1.c.myid.like('somstr', escape='\\'), 
+                "mytable.myid NOT LIKE :myid_1 ESCAPE '\\'", 
+                None),
+            (
+                table1.c.myid.ilike('somstr', escape='\\'), 
+                "lower(mytable.myid) LIKE lower(:myid_1) ESCAPE '\\'", 
+                None),
+            (
+                ~table1.c.myid.ilike('somstr', escape='\\'), 
+                "lower(mytable.myid) NOT LIKE lower(:myid_1) ESCAPE '\\'", 
+                None),
+            (
+                table1.c.myid.ilike('somstr', escape='\\'), 
+                    "mytable.myid ILIKE %(myid_1)s ESCAPE '\\\\'", 
+                    postgresql.PGDialect()),
+            (
+                ~table1.c.myid.ilike('somstr', escape='\\'), 
+                "mytable.myid NOT ILIKE %(myid_1)s ESCAPE '\\\\'", 
+                postgresql.PGDialect()),
+            (
+                table1.c.name.ilike('%something%'), 
+                "lower(mytable.name) LIKE lower(:name_1)", None),
+            (
+                table1.c.name.ilike('%something%'), 
+                "mytable.name ILIKE %(name_1)s", postgresql.PGDialect()),
+            (
+                ~table1.c.name.ilike('%something%'), 
+                "lower(mytable.name) NOT LIKE lower(:name_1)", None),
+            (
+                ~table1.c.name.ilike('%something%'), 
+                "mytable.name NOT ILIKE %(name_1)s", 
+                postgresql.PGDialect()),
         ]:
             self.assert_compile(expr, check, dialect=dialect)
     
-- 
2.47.3