clarkyu2016/sql-beautify

关键词小写转换bug

Closed this issue · 1 comments

版本: v0.3.16
关键词设置转换为小写时,部分关键字没有转换

转换前:

SELECT * 
FROM (
	SELECT C.lv_col, '1' AS match_col
	FROM (SELECT '1' AS a) B
	LATERAL VIEW explode(split('abcd',';')) C AS lv_col
    ) A
LEFT JOIN (
	SELECT '1' AS match_col
	FROM (SELECT 'a' AS b ) E
	LEFT JOIN (SELECT 'a' AS c) F
	ON E.b = F.c
    ) D
ON A.match_col = D.match_col;

转换后:

select  *
from
(
    select  C.lv_col,
            '1' as match_col
    FROM
    (
        select  '1' as a
    ) B LATERAL VIEW explode(split('abcd', ';')) C as lv_col
) A
left join
(
    select  '1' as match_col
    FROM
    (
        select  'a' as b
    ) E
    LEFT JOIN
    (
        select  'a' as c
    ) F
    on E.b = F.c
) D
on A.match_col = D.match_col;

0.3.20版本已经修复