diff options
Diffstat (limited to 'tests/dialects/test_mysql.py')
| -rw-r--r-- | tests/dialects/test_mysql.py | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/tests/dialects/test_mysql.py b/tests/dialects/test_mysql.py index 84fb3c2..591b5dd 100644 --- a/tests/dialects/test_mysql.py +++ b/tests/dialects/test_mysql.py @@ -155,6 +155,10 @@ class TestMySQL(Validator): """SELECT * FROM foo WHERE 3 MEMBER OF(info->'$.value')""", """SELECT * FROM foo WHERE 3 MEMBER OF(JSON_EXTRACT(info, '$.value'))""", ) + self.validate_identity( + "SELECT 1 AS row", + "SELECT 1 AS `row`", + ) # Index hints self.validate_identity( @@ -334,7 +338,7 @@ class TestMySQL(Validator): write_CC = { "bigquery": "SELECT 0xCC", "clickhouse": "SELECT 0xCC", - "databricks": "SELECT 204", + "databricks": "SELECT X'CC'", "drill": "SELECT 204", "duckdb": "SELECT 204", "hive": "SELECT 204", @@ -355,7 +359,7 @@ class TestMySQL(Validator): write_CC_with_leading_zeros = { "bigquery": "SELECT 0x0000CC", "clickhouse": "SELECT 0x0000CC", - "databricks": "SELECT 204", + "databricks": "SELECT X'0000CC'", "drill": "SELECT 204", "duckdb": "SELECT 204", "hive": "SELECT 204", |