formatter doesn't lower some keywords (in, distinct, union, all, and) about jsqlformatter HOT 5 CLOSED

On Mon, 2021-05-17 at 03:30 -0700, Onur Yılmaz wrote: Hi, some keywords aren't being lowered although "options > external formatter > spelling > keywords" is LOWER selected. Here are examples to reproduce the case. Example, raw query-1: SELECT ccp.product_id, COUNT( DISTINCT ccp.campaign_id ) FROM campaign_constraint_product ccp LEFT JOIN campaign c ON c.campaign_id = ccp.campaign_id AND c.status = 1 WHERE product_id IN (414732,530729) GROUP BY ccp.product_id ORDER BY 2 DESC LIMIT 10; Formatted: select ccp.product_id , Count( DISTINCT ccp.campaign_id ) from campaign_constraint_product ccp left join campaign c on c.campaign_id = ccp.campaign_id AND c.status = 1 where product_id IN ( 414732, 530729 ) group by ccp.product_id order by 2 desc limit 10 ; Example, raw query-2: SELECT campaign_id FROM campaign_constraint_product ccp WHERE ccp.product_id = 580696 UNION ALL SELECT campaign_id FROM campaign_action_product cap WHERE cap.product_id =580696; Formatted: select campaign_id from campaign_constraint_product ccp where ccp.product_id = 580696 UNION ALL select campaign_id from campaign_action_product cap where cap.product_id = 580696 ; — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.