summaryrefslogtreecommitdiff
path: root/test/dialect/mysql/test_reflection.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/dialect/mysql/test_reflection.py')
-rw-r--r--test/dialect/mysql/test_reflection.py17
1 files changed, 15 insertions, 2 deletions
diff --git a/test/dialect/mysql/test_reflection.py b/test/dialect/mysql/test_reflection.py
index f815a7b3c..8f093f134 100644
--- a/test/dialect/mysql/test_reflection.py
+++ b/test/dialect/mysql/test_reflection.py
@@ -1285,8 +1285,6 @@ class ReflectionTest(fixtures.TestBase, AssertsCompiledSQL):
class RawReflectionTest(fixtures.TestBase):
- __backend__ = True
-
def setup_test(self):
dialect = mysql.dialect()
self.parser = _reflection.MySQLTableDefinitionParser(
@@ -1412,3 +1410,18 @@ class RawReflectionTest(fixtures.TestBase):
"SET NULL",
),
)
+
+ @testing.combinations(
+ (
+ "CREATE ALGORITHM=UNDEFINED DEFINER=`scott`@`%` "
+ "SQL SECURITY DEFINER VIEW `v1` AS SELECT",
+ True,
+ ),
+ ("CREATE VIEW `v1` AS SELECT", True),
+ ("CREATE TABLE `v1`", False),
+ ("CREATE TABLE `VIEW`", False),
+ ("CREATE TABLE `VIEW_THINGS`", False),
+ ("CREATE TABLE `A VIEW`", False),
+ )
+ def test_is_view(self, sql: str, expected: bool) -> None:
+ is_(self.parser._check_view(sql), expected)