- adjust test to correct for SQLAlchemy issue #3766

Change-Id: Iaffc0592be1b7c987444a18846759fa343bb822e

1 files changed, 13 insertions, 5 deletions

diff --git a/tests/test_autogen_render.py b/tests/test_autogen_render.py
index 1ce5d74..64425a9 100644
--- a/tests/test_autogen_render.py
+++ b/tests/test_autogen_render.py
@@ -191,11 +191,19 @@ unique=False, """
         )
         idx = Index('test_lower_code_idx', cast(t.c.code, String))
         op_obj = ops.CreateIndexOp.from_index(idx)
-        eq_ignore_whitespace(
-            autogenerate.render_op_text(self.autogen_context, op_obj),
-            "op.create_index('test_lower_code_idx', 'test', "
-            "[sa.text(!U'CAST(test.code AS CHAR)')], unique=False)"
-        )
+
+        if config.requirements.sqlalchemy_110.enabled:
+            eq_ignore_whitespace(
+                autogenerate.render_op_text(self.autogen_context, op_obj),
+                "op.create_index('test_lower_code_idx', 'test', "
+                "[sa.text(!U'CAST(code AS CHAR)')], unique=False)"
+            )
+        else:
+            eq_ignore_whitespace(
+                autogenerate.render_op_text(self.autogen_context, op_obj),
+                "op.create_index('test_lower_code_idx', 'test', "
+                "[sa.text(!U'CAST(test.code AS CHAR)')], unique=False)"
+            )
 
     @config.requirements.fail_before_sqla_080
     def test_render_add_index_desc(self):