File tree Expand file tree Collapse file tree
regression-test/suites/usercases/DGSZ Expand file tree Collapse file tree Original file line number Diff line number Diff 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;
Original file line number Diff line number Diff line change 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
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 ;
You can’t perform that action at this time.
0 commit comments