summaryrefslogtreecommitdiffstats
path: root/tests/dialects/test_starrocks.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/dialects/test_starrocks.py')
-rw-r--r--tests/dialects/test_starrocks.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/tests/dialects/test_starrocks.py b/tests/dialects/test_starrocks.py
index b33231c..96e20da 100644
--- a/tests/dialects/test_starrocks.py
+++ b/tests/dialects/test_starrocks.py
@@ -10,3 +10,11 @@ class TestMySQL(Validator):
def test_time(self):
self.validate_identity("TIMESTAMP('2022-01-01')")
+
+ def test_regex(self):
+ self.validate_all(
+ "SELECT REGEXP_LIKE(abc, '%foo%')",
+ write={
+ "starrocks": "SELECT REGEXP(abc, '%foo%')",
+ },
+ )