From fb7e79eb4c8d6e22b7324de4bb1ea9cd11b8da7c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Fri, 7 Apr 2023 14:35:04 +0200 Subject: Merging upstream version 11.5.2. Signed-off-by: Daniel Baumann --- sqlglot/optimizer/simplify.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'sqlglot/optimizer/simplify.py') diff --git a/sqlglot/optimizer/simplify.py b/sqlglot/optimizer/simplify.py index 1ed3ca2..28ae86d 100644 --- a/sqlglot/optimizer/simplify.py +++ b/sqlglot/optimizer/simplify.py @@ -347,8 +347,9 @@ def _simplify_binary(expression, a, b): if isinstance(expression, exp.Mul): return exp.Literal.number(a * b) if isinstance(expression, exp.Div): + # engines have differing int div behavior so intdiv is not safe if isinstance(a, int) and isinstance(b, int): - return exp.Literal.number(a // b) + return None return exp.Literal.number(a / b) boolean = eval_boolean(expression, a, b) @@ -491,7 +492,7 @@ def _flat_simplify(expression, simplifier, root=True): if result: queue.remove(b) - queue.append(result) + queue.appendleft(result) break else: operands.append(a) -- cgit v1.2.3