[GH-ISSUE #652] When formatting, nvl will automatically add spaces #4695

New Issue

GiteaMirror · 2026-06-13T13:01:59-05:00

GiteaMirror commented

2026-06-13 13:01:59 -05:00

Originally created by @louqiang on GitHub (Jan 21, 2021).
Original GitHub issue: https://github.com/semver/semver/issues/652

Enter SQL：
select b.company_no,
b.phone_no_2
from temp_tb_dwd_cu_912688web_company_basic_s_4 b
where nvl(phone_no_2,'') <> '';
Output SQL：
SELECT b.company_no, b.phone_no_2
FROM temp_tb_dwd_cu_912688web_company_basic_s_4 b
WHERE NVL (phone_no_2, '') <> '';

Originally created by @louqiang on GitHub (Jan 21, 2021). Original GitHub issue: https://github.com/semver/semver/issues/652 Enter SQL： select b.company_no, b.phone_no_2 from temp_tb_dwd_cu_912688web_company_basic_s_4 b where nvl(phone_no_2,'') <> ''; Output SQL： SELECT b.company_no, b.phone_no_2 FROM temp_tb_dwd_cu_912688web_company_basic_s_4 b WHERE NVL (phone_no_2, '') <> '';

GiteaMirror closed this issue

2026-06-13 13:01:59 -05:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/semver#4695