Fix substring -> substr in TPCH query set
@@ -5,12 +5,12 @@ SELECT
FROM
(
SELECT
- substring(c.phone,1,2) AS cntrycode,
+ substr(c.phone,1,2) AS cntrycode,
c.acctbal
FROM
"${database}"."${schema}"."${prefix}customer" c
WHERE
- substring(c.phone,1,2) IN ('13', '31', '23', '29', '30', '18', '17')
+ substr(c.phone,1,2) IN ('13', '31', '23', '29', '30', '18', '17')
AND c.acctbal > (
SELECT
avg(c.acctbal)
@@ -18,7 +18,7 @@ FROM
"${database}"."${schema}"."${prefix}customer" c
WHERE
c.acctbal > 0.00
- AND substring(c.phone,1,2) IN ('13', '31', '23', '29', '30', '18', '17')
+ AND substr(c.phone,1,2) IN ('13', '31', '23', '29', '30', '18', '17')
)
AND NOT EXISTS (
SELECT
