OSDN > 浏览软件 > Software Development > Collaborative development tools > SQL整形ツール-DML Breaker > SCM > SVN > 提交

SQL整形ツール-DML Breaker

R/O
SSH
HTTPS

format-sql: 提交

Commit MetaInfo

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

Log Message

3.04

更改概述

modified: trunk/test/case2/outHistory.txt (diff)
modified: trunk/test/case2/outPlainText.sql (diff)
modified: trunk/test/case2/outRichText.html (diff)

差异

--- 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
2	2
3	3	【Input Text】
4	4	--#26536

		@@ -208,16 +208,16 @@
208	208	CASE TMI04MNU.DIM_SETTING_FLAG
209	209	WHEN '1' THEN CASE
210	210	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
212	212	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
214	214	ELSE TMI04MNU.DIM_EXE_MNY / TB_RSLT_MNU.CLC_CNT
215	215	END
216	216	ELSE CASE
217	217	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
219	219	WHEN TMI04MNU.EXE_MNY = 0 OR
220		- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
	220	+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
221	221	ELSE TMI04MNU.EXE_MNY / TB_RSLT_MNU.CLC_CNT
222	222	END
223	223	END AS CLICK_PRICE,

		@@ -224,16 +224,16 @@
224	224	CASE TMI04MNU.DIM_SETTING_FLAG
225	225	WHEN '1' THEN CASE
226	226	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
228	228	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
230	230	ELSE TMI04MNU.DIM_REG_MNY / TB_RSLT_MNU.CLC_CNT
231	231	END
232	232	ELSE CASE
233	233	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
235	235	WHEN TMI04MNU.REG_MNY = 0 OR
236		- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
	236	+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
237	237	ELSE TMI04MNU.REG_MNY / TB_RSLT_MNU.CLC_CNT
238	238	END
239	239	END AS REG_CLICK_PRICE,

--- trunk/test/case2/outPlainText.sql (revision 59)

+++ trunk/test/case2/outPlainText.sql (revision 60)

		@@ -201,16 +201,16 @@
201	201	CASE TMI04MNU.DIM_SETTING_FLAG
202	202	WHEN '1' THEN CASE
203	203	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
205	205	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
207	207	ELSE TMI04MNU.DIM_EXE_MNY / TB_RSLT_MNU.CLC_CNT
208	208	END
209	209	ELSE CASE
210	210	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
212	212	WHEN TMI04MNU.EXE_MNY = 0 OR
213		- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
	213	+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
214	214	ELSE TMI04MNU.EXE_MNY / TB_RSLT_MNU.CLC_CNT
215	215	END
216	216	END AS CLICK_PRICE,

		@@ -217,16 +217,16 @@
217	217	CASE TMI04MNU.DIM_SETTING_FLAG
218	218	WHEN '1' THEN CASE
219	219	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
221	221	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
223	223	ELSE TMI04MNU.DIM_REG_MNY / TB_RSLT_MNU.CLC_CNT
224	224	END
225	225	ELSE CASE
226	226	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
228	228	WHEN TMI04MNU.REG_MNY = 0 OR
229		- TB_RSLT_MNU.CLC_CNT = 0 THEN 0
	229	+ TB_RSLT_MNU.CLC_CNT = 0 THEN 0
230	230	ELSE TMI04MNU.REG_MNY / TB_RSLT_MNU.CLC_CNT
231	231	END
232	232	END AS REG_CLICK_PRICE,

--- trunk/test/case2/outRichText.html (revision 59)

+++ trunk/test/case2/outRichText.html (revision 60)

		@@ -218,16 +218,16 @@
218	218	<li class="odd">    <span class="highlight">CASE</span> TMI04MNU.DIM_SETTING_FLAG</li>
219	219	<li class="even">        <span class="highlight">WHEN</span> <span class="string">'1'</span> <span class="highlight">THEN</span> <span class="highlight">CASE</span></li>
220	220	<li class="odd">            <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">                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">            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>
222	222	<li class="odd">            <span class="highlight">WHEN</span> TMI04MNU.DIM_EXE_MNY = 0 <span class="highlight">OR</span></li>
223		-<li class="even">                TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
	223	+<li class="even">            TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
224	224	<li class="odd">            <span class="highlight">ELSE</span> TMI04MNU.DIM_EXE_MNY / TB_RSLT_MNU.CLC_CNT</li>
225	225	<li class="even">            <span class="highlight">END</span></li>
226	226	<li class="odd">        <span class="highlight">ELSE</span> <span class="highlight">CASE</span></li>
227	227	<li class="even">            <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">                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">            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>
229	229	<li class="even">            <span class="highlight">WHEN</span> TMI04MNU.EXE_MNY = 0 <span class="highlight">OR</span></li>
230		-<li class="odd">                TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
	230	+<li class="odd">            TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
231	231	<li class="even">            <span class="highlight">ELSE</span> TMI04MNU.EXE_MNY / TB_RSLT_MNU.CLC_CNT</li>
232	232	<li class="odd">            <span class="highlight">END</span></li>
233	233	<li class="even">        <span class="highlight">END</span> <span class="highlight">AS</span> CLICK_PRICE,</li>

		@@ -234,16 +234,16 @@
234	234	<li class="odd">    <span class="highlight">CASE</span> TMI04MNU.DIM_SETTING_FLAG</li>
235	235	<li class="even">        <span class="highlight">WHEN</span> <span class="string">'1'</span> <span class="highlight">THEN</span> <span class="highlight">CASE</span></li>
236	236	<li class="odd">            <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">                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">            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>
238	238	<li class="odd">            <span class="highlight">WHEN</span> TMI04MNU.DIM_REG_MNY = 0 <span class="highlight">OR</span></li>
239		-<li class="even">                TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
	239	+<li class="even">            TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
240	240	<li class="odd">            <span class="highlight">ELSE</span> TMI04MNU.DIM_REG_MNY / TB_RSLT_MNU.CLC_CNT</li>
241	241	<li class="even">            <span class="highlight">END</span></li>
242	242	<li class="odd">        <span class="highlight">ELSE</span> <span class="highlight">CASE</span></li>
243	243	<li class="even">            <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">                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">            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>
245	245	<li class="even">            <span class="highlight">WHEN</span> TMI04MNU.REG_MNY = 0 <span class="highlight">OR</span></li>
246		-<li class="odd">                TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
	246	+<li class="odd">            TB_RSLT_MNU.CLC_CNT = 0 <span class="highlight">THEN</span> 0</li>
247	247	<li class="even">            <span class="highlight">ELSE</span> TMI04MNU.REG_MNY / TB_RSLT_MNU.CLC_CNT</li>
248	248	<li class="odd">            <span class="highlight">END</span></li>
249	249	<li class="even">        <span class="highlight">END</span> <span class="highlight">AS</span> REG_CLICK_PRICE,</li>

Show on old repository browser