diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 02:50:21 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 02:50:21 +0000 |
| commit | da8fc943704a221b86f0f6938f4131f0dd679f82 (patch) | |
| tree | bef7144499ea444319403ba8dbf68480ae3a4e39 /tests/fixtures/optimizer/tpc-ds | |
| parent | Adding upstream version 23.10.0. (diff) | |
| download | sqlglot-da8fc943704a221b86f0f6938f4131f0dd679f82.tar.xz sqlglot-da8fc943704a221b86f0f6938f4131f0dd679f82.zip | |
Adding upstream version 23.12.1.upstream/23.12.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 | 15 |
1 files changed, 7 insertions, 8 deletions
diff --git a/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql b/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql index 35fbb70..a357b07 100644 --- a/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql +++ b/tests/fixtures/optimizer/tpc-ds/tpc-ds.sql @@ -822,7 +822,7 @@ WITH "salesreturns" AS ( ), "x" AS ( SELECT 'store channel' AS "channel", - CONCAT('store', "ssr"."s_store_id") AS "id", + 'store' || "ssr"."s_store_id" AS "id", "ssr"."sales" AS "sales", "ssr"."returns1" AS "returns1", "ssr"."profit" - "ssr"."profit_loss" AS "profit" @@ -830,7 +830,7 @@ WITH "salesreturns" AS ( UNION ALL SELECT 'catalog channel' AS "channel", - CONCAT('catalog_page', "csr"."cp_catalog_page_id") AS "id", + 'catalog_page' || "csr"."cp_catalog_page_id" AS "id", "csr"."sales" AS "sales", "csr"."returns1" AS "returns1", "csr"."profit" - "csr"."profit_loss" AS "profit" @@ -838,7 +838,7 @@ WITH "salesreturns" AS ( UNION ALL SELECT 'web channel' AS "channel", - CONCAT('web_site', "wsr"."web_site_id") AS "id", + 'web_site' || "wsr"."web_site_id" AS "id", "wsr"."sales" AS "sales", "wsr"."returns1" AS "returns1", "wsr"."profit" - "wsr"."profit_loss" AS "profit" @@ -10927,7 +10927,7 @@ WITH "date_dim_2" AS ( ), "x" AS ( SELECT 'store channel' AS "channel", - CONCAT('store', "ssr"."store_id") AS "id", + 'store' || "ssr"."store_id" AS "id", "ssr"."sales" AS "sales", "ssr"."returns1" AS "returns1", "ssr"."profit" AS "profit" @@ -10935,7 +10935,7 @@ WITH "date_dim_2" AS ( UNION ALL SELECT 'catalog channel' AS "channel", - CONCAT('catalog_page', "csr"."catalog_page_id") AS "id", + 'catalog_page' || "csr"."catalog_page_id" AS "id", "csr"."sales" AS "sales", "csr"."returns1" AS "returns1", "csr"."profit" AS "profit" @@ -10943,7 +10943,7 @@ WITH "date_dim_2" AS ( UNION ALL SELECT 'web channel' AS "channel", - CONCAT('web_site', "wsr"."web_site_id") AS "id", + 'web_site' || "wsr"."web_site_id" AS "id", "wsr"."sales" AS "sales", "wsr"."returns1" AS "returns1", "wsr"."profit" AS "profit" @@ -11368,7 +11368,7 @@ ORDER BY c_customer_id LIMIT 100; SELECT "customer"."c_customer_id" AS "customer_id", - CONCAT("customer"."c_last_name", ', ', "customer"."c_first_name") AS "customername" + "customer"."c_last_name" || ', ' || "customer"."c_first_name" AS "customername" FROM "customer" AS "customer" JOIN "customer_address" AS "customer_address" ON "customer"."c_current_addr_sk" = "customer_address"."ca_address_sk" @@ -12743,4 +12743,3 @@ ORDER BY "sm_type", "cc_name" LIMIT 100; - |