sqlfmt removes Comments when there are multiple C-style comments on one line

[aersam]

Describe the bug
I have the following sql:

SELECT t.customer_sk AS `Customer_IdDWH`, t.customer_id AS `Customer_IdOrig`, t.__identity AS `CustomerCreditLimit_Agg_IdDWH`, t.kreditlimit_intern /* not existing, proposal: credit_limit_intern (92%) */ AS `KreditlimitIntern`, t.kreditlimit_versichert /* not existing */ AS `KreditlimitVersichert`, t.valid_from /* not existing */ AS `ValidFrom`, t.valid_to /* not existing */ AS `ValidTo` FROM `gold`.`dim_customer_credit_limit_agg` AS t

sqlfmt produces this:

select  /* not existing */
    t.customer_sk as `Customer_IdDWH`,
    t.customer_id as `Customer_IdOrig`,
    t.__identity as `CustomerCreditLimit_Agg_IdDWH`,
    t.kreditlimit_intern as `KreditlimitIntern`,
    t.kreditlimit_versichert as `KreditlimitVersichert`,
    t.valid_from as `ValidFrom`,
    t.valid_to as `ValidTo`
from `gold`.`dim_customer_credit_limit_agg` as t  /* not existing */

Some comments are removed entirely, others are just at the wrong place

Expected behavior
The comments should stick where they are. Interestingly, if I first format the SQL above with the VS Code SQLTools and start with this:

SELECT t.customer_sk AS `Customer_IdDWH`,
    t.customer_id AS `Customer_IdOrig`,
    t.__identity AS `CustomerCreditLimit_Agg_IdDWH`,
    t.kreditlimit_intern
    /* not existing, proposal: credit_limit_intern (92%) */
    AS `KreditlimitIntern`,
    t.kreditlimit_versichert
    /* not existing */
    AS `KreditlimitVersichert`,
    t.valid_from
    /* not existing */
    AS `ValidFrom`,
    t.valid_to
    /* not existing */
    AS `ValidTo`
FROM `gold`.`dim_customer_credit_limit_agg` AS t

then it works. Don't know if that helps

Additional context
What is the output of sqlfmt --version?
sqlfmt, version 0.18.0

[tconbeer]

Wow, I'm shocked, but can repro. I'm sure it's because there are multiple comments on one line -- I don't think we have a test case for that, and that's impossible with the typical -- comments. Thanks for the report!

[dnuzz]

This actually causes some real conflicts in a project we have. Following for a fix