From 58c11f70074708344e433080e47621091a6dcd84 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Fri, 7 Apr 2023 14:35:01 +0200
Subject: Adding upstream version 11.5.2.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 tests/fixtures/optimizer/simplify.sql | 16 +++++++++++-----
 1 file changed, 11 insertions(+), 5 deletions(-)

(limited to 'tests/fixtures/optimizer/simplify.sql')

diff --git a/tests/fixtures/optimizer/simplify.sql b/tests/fixtures/optimizer/simplify.sql
index 08e8700..54ec64b 100644
--- a/tests/fixtures/optimizer/simplify.sql
+++ b/tests/fixtures/optimizer/simplify.sql
@@ -282,6 +282,9 @@ x * (1 - y);
 -1 + 3;
 2;
 
+1 - 2 - 4;
+-5;
+
 -(-1);
 1;
 
@@ -307,19 +310,22 @@ x * (1 - y);
 0.0219;
 
 1 / 3;
-0;
+1 / 3;
+
+1 / 3.0;
+0.3333333333333333333333333333;
 
 20.0 / 6;
 3.333333333333333333333333333;
 
 10 / 5;
-2;
+10 / 5;
 
 (1.0 * 3) * 4 - 2 * (5 / 2);
-8.0;
+12.0 - 2 * (5 / 2);
 
 6 - 2 + 4 * 2 + a;
-a + 12;
+12 + a;
 
 a + 1 + 1 + 2;
 a + 4;
@@ -376,7 +382,7 @@ interval '1' year + date '1998-01-01';
 CAST('1999-01-01' AS DATE);
 
 interval '1' year + date '1998-01-01' + 3 * 7 * 4;
-84 + CAST('1999-01-01' AS DATE);
+CAST('1999-01-01' AS DATE) + 84;
 
 date '1998-12-01' - interval '90' foo;
 CAST('1998-12-01' AS DATE) - INTERVAL '90' foo;
-- 
cgit v1.2.3