SQL-Standardizing-ANTLR4/diffSQLs.html at master · zhuxianglei/SQL-Standardizing-ANTLR4 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>
<metahttp-equiv="Content-Type"
content="text/html; charset=utf-8" />
<title></title>
<styletype="text/css">
table.diff {font-family:Courier; border:medium;}
 .diff_header {background-color:#e0e0e0}
td.diff_header {text-align:right}
 .diff_next {background-color:#c0c0c0}
 .diff_add {background-color:#aaffaa}
 .diff_chg {background-color:#ffff77}
 .diff_sub {background-color:#ffaaaa}
</style>
</head>

<body>

<tableclass="diff" id="difflib_chg_to0__top"
cellspacing="0" cellpadding="0" rules="groups" >
<colgroup></colgroup><colgroup></colgroup><colgroup></colgroup>
<colgroup></colgroup><colgroup></colgroup><colgroup></colgroup>

<tbody>
<tr><tdclass="diff_next" id="difflib_chg_to0__1"><ahref="#difflib_chg_to0__0">f</a></td><tdclass="diff_header" id="from0_1">1</td><tdnowrap="nowrap"></td><tdclass="diff_next"><ahref="#difflib_chg_to0__0">f</a></td><tdclass="diff_header" id="to0_1">1</td><tdnowrap="nowrap"></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_2">2</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;CREATE&nbsp;TABLE</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_2">2</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;CREATE&nbsp;TABLE</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__1">n</a></td><tdclass="diff_header" id="from0_3">3</td><tdnowrap="nowrap"><spanclass="diff_sub">CREATE&nbsp;TABLE&nbsp;TEST02</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__1">n</a></td><tdclass="diff_header" id="to0_3">3</td><tdnowrap="nowrap"><spanclass="diff_add">CREATE&nbsp;TABLE&nbsp;T_TEST02/*IPS_SQLCHECK:NO&nbsp;COMMENT*/</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_4">4</td><tdnowrap="nowrap"><spanclass="diff_sub">(&nbsp;SN_KEY&nbsp;INT,</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_4">4</td><tdnowrap="nowrap"><spanclass="diff_add">(&nbsp;SN_KEY&nbsp;&nbsp;&nbsp;&nbsp;INT/*IPS_SQLCHECK:NO&nbsp;COMMENT*/,</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_5">5</td><tdnowrap="nowrap">&nbsp;&nbsp;SN&nbsp;VARCHAR(20)&nbsp;COMMENT&nbsp;'CMT&nbsp;COL&nbsp;SN',</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_5">5</td><tdnowrap="nowrap">&nbsp;&nbsp;SN&nbsp;VARCHAR(20)&nbsp;COMMENT&nbsp;'CMT&nbsp;COL&nbsp;SN',</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__2">n</a></td><tdclass="diff_header" id="from0_6">6</td><tdnowrap="nowrap"><spanclass="diff_sub">&nbsp;&nbsp;PN&nbsp;VARCHAR(20),</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__2">n</a></td><tdclass="diff_header" id="to0_6">6</td><tdnowrap="nowrap"><spanclass="diff_add">&nbsp;&nbsp;PN&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(20)/*IPS_SQLCHECK:NO&nbsp;COMMENT*/,</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_7">7</td><tdnowrap="nowrap"><spanclass="diff_sub">&nbsp;&nbsp;MD&nbsp;VARCHAR(20),</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_7">7</td><tdnowrap="nowrap"><spanclass="diff_add">&nbsp;&nbsp;MD&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(20)/*IPS_SQLCHECK:NO&nbsp;COMMENT*/,</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_8">8</td><tdnowrap="nowrap"><spanclass="diff_sub">&nbsp;&nbsp;DESCP&nbsp;VARCHAR(20),</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_8">8</td><tdnowrap="nowrap"><spanclass="diff_add">&nbsp;&nbsp;DESCP&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(20)/*IPS_SQLCHECK:NO&nbsp;COMMENT*/,</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_9">9</td><tdnowrap="nowrap"><spanclass="diff_sub">&nbsp;&nbsp;INDEX&nbsp;(SN),</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_9">9</td><tdnowrap="nowrap"><spanclass="diff_add">&nbsp;&nbsp;INDEX&nbsp;IDX_TEST02_SN&nbsp;(SN),</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_10">10</td><tdnowrap="nowrap"><spanclass="diff_sub">&nbsp;&nbsp;KEY&nbsp;(PN),</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_10">10</td><tdnowrap="nowrap"><spanclass="diff_add">&nbsp;&nbsp;KEY&nbsp;IDX_TEST02_PN&nbsp;(PN),</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_11">11</td><tdnowrap="nowrap">&nbsp;&nbsp;CONSTRAINT&nbsp;UNIQUE&nbsp;KEY(MD)&nbsp;</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_11">11</td><tdnowrap="nowrap">&nbsp;&nbsp;CONSTRAINT&nbsp;UNIQUE&nbsp;KEY<spanclass="diff_add">&nbsp;UK_TEST02_MD&nbsp;</span>(MD)&nbsp;</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_12">12</td><tdnowrap="nowrap">);</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_12">12</td><tdnowrap="nowrap">);</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_13">13</td><tdnowrap="nowrap"></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_13">13</td><tdnowrap="nowrap"></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_14">14</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;ERROR&nbsp;SYNTAX</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_14">14</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;ERROR&nbsp;SYNTAX</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_15">15</td><tdnowrap="nowrap">CREATE&nbsp;TABLE&nbsp;TEST03</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_15">15</td><tdnowrap="nowrap">CREATE&nbsp;TABLE&nbsp;TEST03</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_16">16</td><tdnowrap="nowrap">(&nbsp;SN_KEY&nbsp;INT,</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_16">16</td><tdnowrap="nowrap">(&nbsp;SN_KEY&nbsp;INT,</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_17">17</td><tdnowrap="nowrap">&nbsp;&nbsp;SN&nbsp;VARCHAR(20),</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_17">17</td><tdnowrap="nowrap">&nbsp;&nbsp;SN&nbsp;VARCHAR(20),</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_18">18</td><tdnowrap="nowrap">&nbsp;&nbsp;PN&nbsp;VARCHAR(20)&nbsp;COMMENT&nbsp;'COL&nbsp;PN',</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_18">18</td><tdnowrap="nowrap">&nbsp;&nbsp;PN&nbsp;VARCHAR(20)&nbsp;COMMENT&nbsp;'COL&nbsp;PN',</td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__2"></td><tdclass="diff_header" id="from0_19">19</td><tdnowrap="nowrap">&nbsp;&nbsp;MD&nbsp;VARCHAR(20),</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_19">19</td><tdnowrap="nowrap">&nbsp;&nbsp;MD&nbsp;VARCHAR(20),</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_20">20</td><tdnowrap="nowrap">&nbsp;&nbsp;DESCP&nbsp;VARCHAR(20),</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_20">20</td><tdnowrap="nowrap">&nbsp;&nbsp;DESCP&nbsp;VARCHAR(20),</td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__3"></td><tdclass="diff_header" id="from0_21">21</td><tdnowrap="nowrap">);</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_21">21</td><tdnowrap="nowrap">);</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_22">22</td><tdnowrap="nowrap"></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_22">22</td><tdnowrap="nowrap"></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_23">23</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;PARTITION&nbsp;TABLE&nbsp;</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_23">23</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;PARTITION&nbsp;TABLE&nbsp;</td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__4"><ahref="#difflib_chg_to0__3">n</a></td><tdclass="diff_header" id="from0_24">24</td><tdnowrap="nowrap"><spanclass="diff_sub">CREATE&nbsp;TABLE&nbsp;TABLE01&nbsp;(</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__3">n</a></td><tdclass="diff_header" id="to0_24">24</td><tdnowrap="nowrap"><spanclass="diff_add">CREATE&nbsp;TABLE&nbsp;T_TABLE01/*IPS_SQLCHECK:NO&nbsp;COMMENT*/&nbsp;(</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_25">25</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;id&nbsp;INT&nbsp;PRIMARY&nbsp;KEY&nbsp;COMMENT&nbsp;'PK',</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_25">25</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;id&nbsp;INT&nbsp;PRIMARY&nbsp;KEY&nbsp;COMMENT&nbsp;'PK',</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__4">n</a></td><tdclass="diff_header" id="from0_26">26</td><tdnowrap="nowrap"><spanclass="diff_sub">&nbsp;&nbsp;&nbsp;&nbsp;year_col&nbsp;INT</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__4">n</a></td><tdclass="diff_header" id="to0_26">26</td><tdnowrap="nowrap"><spanclass="diff_add">&nbsp;&nbsp;&nbsp;&nbsp;YEAR_COL&nbsp;&nbsp;&nbsp;&nbsp;INT/*IPS_SQLCHECK:NO&nbsp;COMMENT*/</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_27">27</td><tdnowrap="nowrap">)</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_27">27</td><tdnowrap="nowrap">)</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_28">28</td><tdnowrap="nowrap">PARTITION&nbsp;BY&nbsp;RANGE&nbsp;(year_col)&nbsp;(</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_28">28</td><tdnowrap="nowrap">PARTITION&nbsp;BY&nbsp;RANGE&nbsp;(year_col)&nbsp;(</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__5">n</a></td><tdclass="diff_header" id="from0_29">29</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">p</span>0&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(1991),</td><tdclass="diff_next"><ahref="#difflib_chg_to0__5">n</a></td><tdclass="diff_header" id="to0_29">29</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">PT_</span>0&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(1991),</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_30">30</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">p</span>1&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(1995),</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_30">30</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">PT_</span>1&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(1995),</td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__5"></td><tdclass="diff_header" id="from0_31">31</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">p</span>2&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(1999),</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_31">31</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">PT_</span>2&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(1999),</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_32">32</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">p</span>3&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(2003)</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_32">32</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;PARTITION&nbsp;<spanclass="diff_chg">PT_</span>3&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(2003)</td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__6"></td><tdclass="diff_header" id="from0_33">33</td><tdnowrap="nowrap">);</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_33">33</td><tdnowrap="nowrap">);</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_34">34</td><tdnowrap="nowrap"></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_34">34</td><tdnowrap="nowrap"></td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__7"></td><tdclass="diff_header" id="from0_35">35</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;ADD&nbsp;COLUMNS</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_35">35</td><tdnowrap="nowrap">--&nbsp;TEST&nbsp;ADD&nbsp;COLUMNS</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__6">n</a></td><tdclass="diff_header" id="from0_36">36</td><tdnowrap="nowrap"><spanclass="diff_sub">ALTER&nbsp;TABLE&nbsp;t1&nbsp;ADD&nbsp;COLUMN&nbsp;(c2&nbsp;INT,C3&nbsp;VARCHAR(10));</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__6">n</a></td><tdclass="diff_header" id="to0_36">36</td><tdnowrap="nowrap"><spanclass="diff_add">ALTER&nbsp;TABLE&nbsp;t1&nbsp;ADD&nbsp;COLUMN&nbsp;(C2&nbsp;&nbsp;&nbsp;&nbsp;INT/*IPS_SQLCHECK:NO&nbsp;COMMENT*/,C3&nbsp;&nbsp;&nbsp;&nbsp;VARCHAR(10)/*IPS_SQLCHECK:NO&nbsp;COMMENT*/),ALGORITHM=INPLACE,LOCK=NONE;</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_37">37</td><tdnowrap="nowrap">--&nbsp;测试增加partition</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_37">37</td><tdnowrap="nowrap">--&nbsp;测试增加partition</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__7">n</a></td><tdclass="diff_header" id="from0_38">38</td><tdnowrap="nowrap">ALTER&nbsp;TABLE&nbsp;t1&nbsp;ADD&nbsp;PARTITION&nbsp;(PARTITION&nbsp;<spanclass="diff_chg">p</span>3&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(2002));</td><tdclass="diff_next"><ahref="#difflib_chg_to0__7">n</a></td><tdclass="diff_header" id="to0_38">38</td><tdnowrap="nowrap">ALTER&nbsp;TABLE&nbsp;t1&nbsp;ADD&nbsp;PARTITION&nbsp;(PARTITION&nbsp;<spanclass="diff_chg">PT_</span>3&nbsp;VALUES&nbsp;LESS&nbsp;THAN&nbsp;(2002))<spanclass="diff_add">,ALGORITHM=INPLACE,LOCK=NONE</span>;</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_39">39</td><tdnowrap="nowrap">--&nbsp;测试索引和约束</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_39">39</td><tdnowrap="nowrap">--&nbsp;测试索引和约束</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__8">n</a></td><tdclass="diff_header" id="from0_40">40</td><tdnowrap="nowrap"><spanclass="diff_sub">ALTER&nbsp;TABLE&nbsp;t2&nbsp;ADD&nbsp;INDEX&nbsp;(d),&nbsp;ADD&nbsp;UNIQUE&nbsp;(a);</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__8">n</a></td><tdclass="diff_header" id="to0_40">40</td><tdnowrap="nowrap"><spanclass="diff_add">ALTER&nbsp;TABLE&nbsp;t2&nbsp;ADD&nbsp;INDEX&nbsp;IDX_T2_D&nbsp;&nbsp;(d),&nbsp;ADD&nbsp;UNIQUE&nbsp;&nbsp;UK_T2_A&nbsp;(a),ALGORITHM=INPLACE,LOCK=NONE;</span></td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__8"></td><tdclass="diff_header" id="from0_41">41</td><tdnowrap="nowrap"><spanclass="diff_sub">ALTER&nbsp;TABLE&nbsp;TEST13&nbsp;ADD&nbsp;FOREIGN&nbsp;KEY(C_10)&nbsp;REFERENCES&nbsp;TEST02(SN_KEY);</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_41">41</td><tdnowrap="nowrap"><spanclass="diff_add">ALTER&nbsp;TABLE&nbsp;TEST13&nbsp;ADD&nbsp;CONSTRAINT&nbsp;FK_TEST13_C_10&nbsp;FOREIGN&nbsp;KEY(C_10)&nbsp;REFERENCES&nbsp;TEST02(SN_KEY),ALGORITHM=INPLACE,LOCK=NONE;</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_42">42</td><tdnowrap="nowrap"><spanclass="diff_sub">ALTER&nbsp;TABLE&nbsp;TEST13&nbsp;ADD&nbsp;UNIQUE&nbsp;INDEX(C);</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_42">42</td><tdnowrap="nowrap"><spanclass="diff_add">ALTER&nbsp;TABLE&nbsp;TEST13&nbsp;ADD&nbsp;UNIQUE&nbsp;INDEX&nbsp;UK_TEST13_C&nbsp;(C),ALGORITHM=INPLACE,LOCK=NONE;</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_43">43</td><tdnowrap="nowrap"><spanclass="diff_sub">ALTER&nbsp;TABLE&nbsp;TEST13&nbsp;add&nbsp;PRIMARY&nbsp;KEY(A);</span></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_43">43</td><tdnowrap="nowrap"><spanclass="diff_add">ALTER&nbsp;TABLE&nbsp;TEST13&nbsp;add&nbsp;PRIMARY&nbsp;KEY(A),ALGORITHM=INPLACE,LOCK=NONE;</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_44">44</td><tdnowrap="nowrap">--&nbsp;测试创建proc&nbsp;function</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_44">44</td><tdnowrap="nowrap">--&nbsp;测试创建proc&nbsp;function</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_45">45</td><tdnowrap="nowrap">delimiter&nbsp;//</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_45">45</td><tdnowrap="nowrap">delimiter&nbsp;//</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__9">n</a></td><tdclass="diff_header" id="from0_46">46</td><tdnowrap="nowrap"><spanclass="diff_sub">CREATE&nbsp;PROCEDURE&nbsp;simpleproc&nbsp;(OUT&nbsp;param1&nbsp;INT)</span></td><tdclass="diff_next"><ahref="#difflib_chg_to0__9">n</a></td><tdclass="diff_header" id="to0_46">46</td><tdnowrap="nowrap"><spanclass="diff_add">CREATE&nbsp;PROCEDURE&nbsp;SP_SIMPLEPROC&nbsp;(OUT&nbsp;param1&nbsp;INT)</span></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_47">47</td><tdnowrap="nowrap">BEGIN</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_47">47</td><tdnowrap="nowrap">BEGIN</td></tr>
<tr><tdclass="diff_next" id="difflib_chg_to0__9"></td><tdclass="diff_header" id="from0_48">48</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;COUNT(*)&nbsp;INTO&nbsp;param1&nbsp;FROM&nbsp;t;</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_48">48</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;COUNT(*)&nbsp;INTO&nbsp;param1&nbsp;FROM&nbsp;t;</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_49">49</td><tdnowrap="nowrap">END;//</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_49">49</td><tdnowrap="nowrap">END;//</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_50">50</td><tdnowrap="nowrap">delimiter&nbsp;;</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_50">50</td><tdnowrap="nowrap">delimiter&nbsp;;</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_51">51</td><tdnowrap="nowrap"></td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_51">51</td><tdnowrap="nowrap"></td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_52">52</td><tdnowrap="nowrap">delimiter&nbsp;$$</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_52">52</td><tdnowrap="nowrap">delimiter&nbsp;$$</td></tr>
<tr><tdclass="diff_next"><ahref="#difflib_chg_to0__top">t</a></td><tdclass="diff_header" id="from0_53">53</td><tdnowrap="nowrap">CREATE&nbsp;FUNCTION&nbsp;`SHORTEN`(S&nbsp;VARCHAR(255),&nbsp;N&nbsp;INT)</td><tdclass="diff_next"><ahref="#difflib_chg_to0__top">t</a></td><tdclass="diff_header" id="to0_53">53</td><tdnowrap="nowrap">CREATE&nbsp;FUNCTION&nbsp;`<spanclass="diff_add">F_</span>SHORTEN`(S&nbsp;VARCHAR(255),&nbsp;N&nbsp;INT)</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_54">54</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;RETURNS&nbsp;varchar(255)</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_54">54</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;RETURNS&nbsp;varchar(255)</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_55">55</td><tdnowrap="nowrap">BEGIN</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_55">55</td><tdnowrap="nowrap">BEGIN</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_56">56</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;IF&nbsp;ISNULL(S)&nbsp;THEN</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_56">56</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;IF&nbsp;ISNULL(S)&nbsp;THEN</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_57">57</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;'';</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_57">57</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;'';</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_58">58</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;END&nbsp;IF;</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_58">58</td><tdnowrap="nowrap">&nbsp;&nbsp;&nbsp;END&nbsp;IF;</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_59">59</td><tdnowrap="nowrap">END;$$</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_59">59</td><tdnowrap="nowrap">END;$$</td></tr>
<tr><tdclass="diff_next"></td><tdclass="diff_header" id="from0_60">60</td><tdnowrap="nowrap">delimiter&nbsp;;</td><tdclass="diff_next"></td><tdclass="diff_header" id="to0_60">60</td><tdnowrap="nowrap">delimiter&nbsp;;</td></tr>
</tbody>
</table>
<tableclass="diff" summary="Legends">
<tr><thcolspan="2"> Legends </th></tr>
<tr><td><tableborder="" summary="Colors">
<tr><th> Colors </th></tr>
<tr><tdclass="diff_add">&nbsp;Added&nbsp;</td></tr>
<tr><tdclass="diff_chg">Changed</td></tr>
<tr><tdclass="diff_sub">Deleted</td></tr>
</table></td>
<td><tableborder="" summary="Links">
<tr><thcolspan="2"> Links </th></tr>
<tr><td>(f)irst change</td></tr>
<tr><td>(n)ext change</td></tr>
<tr><td>(t)op</td></tr>
</table></td></tr>
</table>
</body>

</html>