summaryrefslogtreecommitdiffstats
path: root/tests/test_diff.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2023-04-03 07:31:50 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2023-04-03 07:31:50 +0000
commit1fb60a37d31eacbac62ddafde51b829522925694 (patch)
tree5c04a33630f7a2cd4cff248e965053f97ec3e4ac /tests/test_diff.py
parentAdding upstream version 11.4.1. (diff)
downloadsqlglot-1fb60a37d31eacbac62ddafde51b829522925694.tar.xz
sqlglot-1fb60a37d31eacbac62ddafde51b829522925694.zip
Adding upstream version 11.4.5.upstream/11.4.5
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/test_diff.py')
-rw-r--r--tests/test_diff.py13
1 files changed, 13 insertions, 0 deletions
diff --git a/tests/test_diff.py b/tests/test_diff.py
index 372af70..d5fa163 100644
--- a/tests/test_diff.py
+++ b/tests/test_diff.py
@@ -155,6 +155,19 @@ class TestDiff(unittest.TestCase):
with self.assertRaises(ValueError):
diff(expr_src, expr_tgt, matchings=[(expr_src, expr_tgt), (expr_src, expr_tgt)])
+ def test_identifier(self):
+ expr_src = parse_one("SELECT a FROM tbl")
+ expr_tgt = parse_one("SELECT a, tbl.b from tbl")
+
+ self._validate_delta_only(
+ diff(expr_src, expr_tgt),
+ [
+ Insert(expression=exp.to_identifier("b")),
+ Insert(expression=exp.to_column("tbl.b")),
+ Insert(expression=exp.to_identifier("tbl")),
+ ],
+ )
+
def _validate_delta_only(self, actual_diff, expected_delta):
actual_delta = _delta_only(actual_diff)
self.assertEqual(set(actual_delta), set(expected_delta))