用于测试 SqlAnalyzer1.01 的21个测试用例
感慨：当年看着 https://www.cnblogs.com/heyang78/p/11451814.html 一文望洋兴叹，如今我也自己做出来了！
21.
原文=select name, cnt from (select name from tb order by name,id,age,level) 整理后文本= select name, cnt from ( select name from tb order by name , id , age , level )
20.
原文=select a from tc,(select a1,a2 from (select 1,2,3 from tc where a>2 and b>3 and c>4 group by a,b having a=2 and b=3 order by a,c) tre order by a1) tb order by a 整理后文本= select a from tc, ( select a1, a2 from ( select 1, 2, 3 from tc where a>2 and b>3 and c>4 group by a, b having a=2 and b=3 order by a , c ) tre order by a1 ) tb order by a
19.
原文=select name, cnt from tb where age=41 and age=42 and age=43 and level>9 or salary<30000 group by name,id order by name,id,age,level 整理后文本= select name, cnt from tb where age=41 and age=42 and age=43 and level>9 or salary<30000 group by name, id order by name , id , age , level
18.
原文=select name, cnt from tb where age=41 and age=42 and age=43 and level>9 or salary<30000 order by name,id,age,level 整理后文本= select name, cnt from tb where age=41 and age=42 and age=43 and level>9 or salary<30000 order by name , id , age , level
17.
原文=select name from tb where age=41 and level>9 or salary<30000 order by name,id,age,level 整理后文本= select name from tb where age=41 and level>9 or salary<30000 order by name , id , age , level
16.
原文=select name from tb where age=41 and level>9 or salary<30000 order by name,id desc,age asc 整理后文本= select name from tb where age=41 and level>9 or salary<30000 order by name , id desc, age asc
15.
原文=select name from tb where age=41 and level>9 or salary<30000 order by name asc,id desc,age 整理后文本= select name from tb where age=41 and level>9 or salary<30000 order by name asc, id desc, age
14.
原文=select name from tb where age=41 and level>9 or salary<30000 order by name 整理后文本= select name from tb where age=41 and level>9 or salary<30000 order by name
13.
原文=select name from tb where age=41 and level>9 or salary<30000 整理后文本= select name from tb where age=41 and level>9 or salary<30000
12.
原文=select name from tb where age=41 整理后文本= select name from tb where age=41
11.
原文=select (select f1,f2,f3 from tbable) as x,(select a from tc) as cnt from b 整理后文本= select ( select f1, f2, f3 from tbable) x, ( select a from tc) cnt from b
10.
原文=select name as name,birthday as b,column c from tc c,tb b,(select a1,a2,a3 from (select * from tbc) tbc) ta 整理后文本= select name name, birthday b, column c from tc c, tb b, ( select a1, a2, a3 from ( select * from tbc) tbc) ta
09.
原文=select name as name,birthday as b,column c from (select a,c,b from tb) tb,(select a1,a2,a3 from (select * from (select t1,t2,t3,t4,t5,t6 from (select t1,t2,t3,t4,t5,t6,t7 from table4 ) t2) t1) tbc) ta 整理后文本= select name name, birthday b, column c from ( select a, c, b from tb) tb, ( select a1, a2, a3 from ( select * from ( select t1, t2, t3, t4, t5, t6 from ( select t1, t2, t3, t4, t5, t6, t7 from table4) t2) t1) tbc) ta
08.
原文=select name as name,birthday as b,column c from (select a,c,b from tb) tb,(select a1,a2,a3 from (select * from (select t1,t2,t3,t4,t5,t6 from test) t1) tbc) ta 整理后文本= select name name, birthday b, column c from ( select a, c, b from tb) tb, ( select a1, a2, a3 from ( select * from ( select t1, t2, t3, t4, t5, t6 from test) t1) tbc) ta
07.
原文=select name as name,birthday as b,column c from (select a,c,b from tb) tb,(select a1,a2,a3 from (select * from tbc) tbc) ta 整理后文本= select name name, birthday b, column c from ( select a, c, b from tb) tb, ( select a1, a2, a3 from ( select * from tbc) tbc) ta
06.
原文=select name as name,birthday as b,column c from (select a,c,b from tb) tb,(select a1,a2,a3 from table_a) ta 整理后文本= select name name, birthday b, column c from ( select a, c, b from tb) tb, ( select a1, a2, a3 from table_a) ta
05.
原文=select name as name,birthday as b,column c from (select a,c,b from tb) tb 整理后文本= select name name, birthday b, column c from ( select a, c, b from tb) tb
04.
原文=select name as name,birthday as b,column c from tb 整理后文本= select name name, birthday b, column c from tb
03.
原文=select name name,birthday b,column c from tb 整理后文本= select name name, birthday b, column c from tb
02.
原文=select a,b,c from tb,tc,td,tf f,tg g 整理后文本= select a, b, c from tb, tc, td, tf f, tg g
01.
原文=select a from b 整理后文本= select a from b
虽然还有力有未逮之处，但相对于之前用循环分支和正则表达式去硬解析好多了。
--2020年5月29日--
