Skip to content

Case When格式化问题 #48

@ztmszml

Description

@ztmszml

原sql语句
SELECT
a.a1,
a.a2,
case WHEN exists(SELECT b1 FROM b WHERE b1 =100) then 0 ELSE 1 END AS b2
FROM a

在格式化后
SELECT a.a1,
--------- a.a2,
---------CASE WHEN exists(
SELECT b1
FROM b
WHERE b1 = 100) THEN 0 ELSE 1 END AS b2
FROM a

可否优化exists后括号内子查询的缩进,如
SELECT a.a1,
---------a.a2,
---------CASE WHEN exists
---------(
------------SELECT b1
------------FROM b
------------WHERE b1 = 100
---------) THEN 0 ELSE 1 END AS b2
FROM a

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions