StringManipulation icon indicating copy to clipboard operation
StringManipulation copied to clipboard

"Align to column by ," doesn't align correctly

Open m-titov opened this issue 8 years ago • 4 comments

Example:

Before:

INSERT INTO address (id , address1 , address2 ) VALUES (@club_address+1 ,'56 passage de la Coupole' , '92400 La Défense 6 Courbevoie') , (@club_address+2 ,'9 Esplanade du Général de Gaulle', '92800 Puteaux' ) ;

after: apply this function to all lines except first:

INSERT INTO address (id , address1 , address2 ) VALUES (@club_address+1 , '56 passage de la Coupole' , '92400 La Défense 6 Courbevoie') , (@club_address+2 , '9 Esplanade du Général de Gaulle' , '92800 Puteaux' ) ;

Please fix.

m-titov avatar Feb 13 '17 12:02 m-titov

works fine for me:

INSERT INTO address
(id              , address1                           , address2 ) VALUES
(@club_address+1 , '56 passage de la Coupole'         , '92400 La Défense 6 Courbevoie') ,
(@club_address+2 , '9 Esplanade du Général de Gaulle' , '92800 Puteaux' ) ;

krasa avatar Feb 13 '17 12:02 krasa

hm.. It doesn't work as expected when file has sql extension...

m-titov avatar Feb 13 '17 14:02 m-titov

maybe something in tab/space code style config? I aligned many sql files by it....

krasa avatar Feb 13 '17 14:02 krasa

Maybe because of this https://youtrack.jetbrains.com/issue/DBE-4050

m-titov avatar Feb 15 '17 14:02 m-titov