Skip to content

Commit ed51c85

Browse files
authored
fix DGSZ case (apache#231)
1 parent 993f72f commit ed51c85

2 files changed

Lines changed: 8 additions & 8 deletions

File tree

‎regression-test/suites/usercases/DGSZ/load.groovy‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -141,7 +141,7 @@ suite("load") {
141141
round(
142142
sum(
143143
CASE
144-
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH) THEN yjce
144+
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH) THEN yjce
145145
ELSE 0
146146
END
147147
) / sum(
@@ -157,14 +157,14 @@ suite("load") {
157157
) AS pjjcje,
158158
sum(
159159
CASE
160-
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH)
160+
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH)
161161
AND summary LIKE '%补缴%' THEN 1
162162
ELSE 0
163163
END
164164
) AS bjyfs,
165165
sum(
166166
CASE
167-
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH)
167+
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH)
168168
AND summary LIKE '%缴存%' THEN 1
169169
ELSE 0
170170
END
@@ -173,7 +173,7 @@ suite("load") {
173173
FROM
174174
b_dggjj_grhjmx
175175
WHERE
176-
cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH)
176+
cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH)
177177
GROUP BY
178178
zjhm
179179
) t2 on t1.zjhm = t2.zjhm;

‎regression-test/suites/usercases/DGSZ/sql/q01.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -102,7 +102,7 @@ from
102102
round(
103103
sum(
104104
CASE
105-
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH) THEN yjce
105+
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH) THEN yjce
106106
ELSE 0
107107
END
108108
) / sum(
@@ -118,14 +118,14 @@ from
118118
) AS pjjcje,
119119
sum(
120120
CASE
121-
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH)
121+
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH)
122122
AND summary LIKE '%补缴%' THEN 1
123123
ELSE 0
124124
END
125125
) AS bjyfs,
126126
sum(
127127
CASE
128-
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH)
128+
WHEN cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH)
129129
AND summary LIKE '%缴存%' THEN 1
130130
ELSE 0
131131
END
@@ -134,7 +134,7 @@ from
134134
FROM
135135
b_dggjj_grhjmx
136136
WHERE
137-
cast(concat(ctb_ym, "-01") AS date) >= date_sub(curdate(), INTERVAL 12 MONTH)
137+
cast(concat(ctb_ym, "-01") AS date) >= date_sub("2023-06-30", INTERVAL 12 MONTH)
138138
GROUP BY
139139
zjhm
140140
) t2 on t1.zjhm = t2.zjhm;

0 commit comments

Comments
 (0)