diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-12-19 11:01:55 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-12-19 11:01:55 +0000 |
| commit | f1c2dbe3b17a0d5edffbb65b85b642d0bb2756c5 (patch) | |
| tree | 5dce0fe2a11381761496eb973c20750f44db56d5 /sqlglot/dialects/tsql.py | |
| parent | Releasing debian version 20.1.0-1. (diff) | |
| download | sqlglot-f1c2dbe3b17a0d5edffbb65b85b642d0bb2756c5.tar.xz sqlglot-f1c2dbe3b17a0d5edffbb65b85b642d0bb2756c5.zip | |
Merging upstream version 20.3.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/tsql.py')
| -rw-r--r-- | sqlglot/dialects/tsql.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqlglot/dialects/tsql.py b/sqlglot/dialects/tsql.py index c3d4f0a..165a703 100644 --- a/sqlglot/dialects/tsql.py +++ b/sqlglot/dialects/tsql.py @@ -701,6 +701,13 @@ class TSQL(Dialect): exp.VolatileProperty: exp.Properties.Location.UNSUPPORTED, } + def set_operation(self, expression: exp.Union, op: str) -> str: + limit = expression.args.get("limit") + if limit: + return self.sql(expression.limit(limit.pop(), copy=False)) + + return super().set_operation(expression, op) + def setitem_sql(self, expression: exp.SetItem) -> str: this = expression.this if isinstance(this, exp.EQ) and not isinstance(this.left, exp.Parameter): |