• R/O
  • SSH
  • HTTPS

format-sql: 提交


Commit MetaInfo

修订版60 (tree)
时间2018-02-17 13:51:28
作者h-sasaki

Log Message

3.04

更改概述

差异

--- trunk/test/case2/outHistory.txt (revision 59)
+++ trunk/test/case2/outHistory.txt (revision 60)
@@ -1,4 +1,4 @@
1-2018/2/17 0:55:45
1+‎2018‎年‎2‎月‎17‎日‎ ‎13‎:‎43‎:‎12
22
33 【Input Text】
44 --#26536
@@ -208,16 +208,16 @@
208208 CASE TMI04MNU.DIM_SETTING_FLAG
209209 WHEN '1' THEN CASE
210210 WHEN TMI04MNU.DIM_EXE_MNY IS NULL OR
211- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
211+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
212212 WHEN TMI04MNU.DIM_EXE_MNY = 0 OR
213- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
213+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
214214 ELSE TMI04MNU.DIM_EXE_MNY / TB_RSLT_MNU.CLC_CNT
215215 END
216216 ELSE CASE
217217 WHEN TMI04MNU.EXE_MNY IS NULL OR
218- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
218+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
219219 WHEN TMI04MNU.EXE_MNY = 0 OR
220- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
220+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
221221 ELSE TMI04MNU.EXE_MNY / TB_RSLT_MNU.CLC_CNT
222222 END
223223 END AS CLICK_PRICE,
@@ -224,16 +224,16 @@
224224 CASE TMI04MNU.DIM_SETTING_FLAG
225225 WHEN '1' THEN CASE
226226 WHEN TMI04MNU.DIM_REG_MNY IS NULL OR
227- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
227+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
228228 WHEN TMI04MNU.DIM_REG_MNY = 0 OR
229- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
229+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
230230 ELSE TMI04MNU.DIM_REG_MNY / TB_RSLT_MNU.CLC_CNT
231231 END
232232 ELSE CASE
233233 WHEN TMI04MNU.REG_MNY IS NULL OR
234- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
234+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
235235 WHEN TMI04MNU.REG_MNY = 0 OR
236- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
236+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
237237 ELSE TMI04MNU.REG_MNY / TB_RSLT_MNU.CLC_CNT
238238 END
239239 END AS REG_CLICK_PRICE,
--- trunk/test/case2/outPlainText.sql (revision 59)
+++ trunk/test/case2/outPlainText.sql (revision 60)
@@ -201,16 +201,16 @@
201201 CASE TMI04MNU.DIM_SETTING_FLAG
202202 WHEN '1' THEN CASE
203203 WHEN TMI04MNU.DIM_EXE_MNY IS NULL OR
204- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
204+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
205205 WHEN TMI04MNU.DIM_EXE_MNY = 0 OR
206- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
206+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
207207 ELSE TMI04MNU.DIM_EXE_MNY / TB_RSLT_MNU.CLC_CNT
208208 END
209209 ELSE CASE
210210 WHEN TMI04MNU.EXE_MNY IS NULL OR
211- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
211+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
212212 WHEN TMI04MNU.EXE_MNY = 0 OR
213- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
213+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
214214 ELSE TMI04MNU.EXE_MNY / TB_RSLT_MNU.CLC_CNT
215215 END
216216 END AS CLICK_PRICE,
@@ -217,16 +217,16 @@
217217 CASE TMI04MNU.DIM_SETTING_FLAG
218218 WHEN '1' THEN CASE
219219 WHEN TMI04MNU.DIM_REG_MNY IS NULL OR
220- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
220+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
221221 WHEN TMI04MNU.DIM_REG_MNY = 0 OR
222- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
222+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
223223 ELSE TMI04MNU.DIM_REG_MNY / TB_RSLT_MNU.CLC_CNT
224224 END
225225 ELSE CASE
226226 WHEN TMI04MNU.REG_MNY IS NULL OR
227- TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
227+ TB_RSLT_MNU.CLC_CNT IS NULL THEN NULL
228228 WHEN TMI04MNU.REG_MNY = 0 OR
229- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
229+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
230230 ELSE TMI04MNU.REG_MNY / TB_RSLT_MNU.CLC_CNT
231231 END
232232 END AS REG_CLICK_PRICE,
--- trunk/test/case2/outRichText.html (revision 59)
+++ trunk/test/case2/outRichText.html (revision 60)
@@ -218,16 +218,16 @@
218218 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">CASE</span> TMI04MNU.DIM_SETTING_FLAG</li>
219219 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> <span class="string">'1'</span> <span class="highlight">THEN</span> <span class="highlight">CASE</span></li>
220220 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.DIM_EXE_MNY <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">OR</span></li>
221-<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
221+<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
222222 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.DIM_EXE_MNY = 0 <span class="highlight">OR</span></li>
223-<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
223+<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
224224 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">ELSE</span> TMI04MNU.DIM_EXE_MNY / TB_RSLT_MNU.CLC_CNT</li>
225225 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">END</span></li>
226226 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">ELSE</span> <span class="highlight">CASE</span></li>
227227 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.EXE_MNY <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">OR</span></li>
228-<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
228+<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
229229 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.EXE_MNY = 0 <span class="highlight">OR</span></li>
230-<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
230+<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
231231 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">ELSE</span> TMI04MNU.EXE_MNY / TB_RSLT_MNU.CLC_CNT</li>
232232 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">END</span></li>
233233 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">END</span> <span class="highlight">AS</span> CLICK_PRICE,</li>
@@ -234,16 +234,16 @@
234234 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">CASE</span> TMI04MNU.DIM_SETTING_FLAG</li>
235235 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> <span class="string">'1'</span> <span class="highlight">THEN</span> <span class="highlight">CASE</span></li>
236236 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.DIM_REG_MNY <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">OR</span></li>
237-<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
237+<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
238238 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.DIM_REG_MNY = 0 <span class="highlight">OR</span></li>
239-<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
239+<li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
240240 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">ELSE</span> TMI04MNU.DIM_REG_MNY / TB_RSLT_MNU.CLC_CNT</li>
241241 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">END</span></li>
242242 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">ELSE</span> <span class="highlight">CASE</span></li>
243243 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.REG_MNY <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">OR</span></li>
244-<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
244+<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT <span class="highlight">IS</span> <span class="highlight">NULL</span> <span class="highlight">THEN</span> <span class="highlight">NULL</span></li>
245245 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">WHEN</span> TMI04MNU.REG_MNY = 0 <span class="highlight">OR</span></li>
246-<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
246+<li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
247247 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">ELSE</span> TMI04MNU.REG_MNY / TB_RSLT_MNU.CLC_CNT</li>
248248 <li class="odd">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">END</span></li>
249249 <li class="even">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="highlight">END</span> <span class="highlight">AS</span> REG_CLICK_PRICE,</li>
Show on old repository browser