[Solved] Columns per line in IN list, multi lines

2 Posts
2 Users
0 Likes
184 Views
(@george)
Member
Joined: 1 year ago
Posts: 2
Topic starter  

I am not sure if this is a bug or I am just not understanding the setting, but when using the "Columns per Line in IN list" I am only having the first line format multiple values on one line, then it reverts to a list

 

Original code

SELECT
   count(*)
FROM table
WHERE 1=1
   AND column IN ('one', 'two', 'three', 'four', 'five', 'six', 'seven')
;

 

Formatted code

SELECT
   COUNT(*)
FROM TABLE
WHERE
   1=1
   AND column IN ('one','two','three'
               , 'four'
               , 'five'
               , 'six'
               , 'seven')
;

 

What I would expect

SELECT
   COUNT(*)
FROM TABLE
WHERE
   1=1
   AND column IN ('one','two','three'
               , 'four', 'five', 'six'
               , 'seven')
;

 


   
Quote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

This issue has been solved in the new Release


   
ReplyQuote
Share: