diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-11-01 05:12:38 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-11-01 05:12:38 +0000 |
| commit | 613c2506f59fefeb0c0b921ca361c65e99458139 (patch) | |
| tree | e1207c41ee9b35d77f1608e87e568fe60d701cf6 /tests/fixtures/optimizer/tpc-ds | |
| parent | Adding upstream version 18.17.0. (diff) | |
| download | sqlglot-613c2506f59fefeb0c0b921ca361c65e99458139.tar.xz sqlglot-613c2506f59fefeb0c0b921ca361c65e99458139.zip | |
Adding upstream version 19.0.1.upstream/19.0.1
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/fixtures/optimizer/tpc-ds')
| -rw-r--r-- | tests/fixtures/optimizer/tpc-ds/tpc-ds.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql b/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql index 52ee12c..62f1d79 100644 --- a/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql +++ b/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql @@ -2547,8 +2547,8 @@ JOIN "date_dim" AS "date_dim" ) WHERE "_u_3"."_u_4" IS NULL - AND ARRAY_ANY("_u_0"."_u_2", "_x" -> "cs1"."cs_warehouse_sk" <> "_x") AND NOT "_u_0"."_u_1" IS NULL + AND ARRAY_ANY("_u_0"."_u_2", "_x" -> "cs1"."cs_warehouse_sk" <> "_x") ORDER BY COUNT(DISTINCT "cs1"."cs_order_number") LIMIT 100; @@ -12586,8 +12586,8 @@ JOIN "web_site" AS "web_site" AND "ws1"."ws_web_site_sk" = "web_site"."web_site_sk" WHERE "_u_3"."_u_4" IS NULL - AND ARRAY_ANY("_u_0"."_u_2", "_x" -> "ws1"."ws_warehouse_sk" <> "_x") AND NOT "_u_0"."_u_1" IS NULL + AND ARRAY_ANY("_u_0"."_u_2", "_x" -> "ws1"."ws_warehouse_sk" <> "_x") ORDER BY COUNT(DISTINCT "ws1"."ws_order_number") LIMIT 100; |