Wrong formatting with comments.

[Shu-Ji]

-- comment 111
SELECT * from tb1;
-- comment 222
SELECT * from tb2;

Formatting Request:

{
    "jsonrpc": "2.0",
    "method": "textDocument/formatting",
    "params": {
        "textDocument": {
            "uri": "file:///workspace/mysql.sql"
        },
        "options": {
            "tabSize": 4,
            "insertSpaces": true
        }
    },
    "id": 1703824210
}

Original code:

lsp-server result:

{
    "id": 1703824210,
    "result": [
        {
            "range": {
                "start": {
                    "line": 0,
                    "character": 14
                },
                "end": {
                    "line": 3,
                    "character": 18
                }
            },
            "newText": "SELECT\n    *\nFROM\n    tb1;SELECT\n        *\n    FROM\n        tb2;"
        }
    ],
    "jsonrpc": "2.0"
}

Formatted code:

Problem:

1. Comments were removed.
2. The second SELECT is on wrong line.

[mattn]

@lighttiger2505 from my understanding, sqls does not support multiple SQL statements. right?

[Shu-Ji]

@lighttiger2505 from my understanding, sqls does not support multiple SQL statements. right?

Even one statement will not work(Comment will be removed after formatting):

-- comment 111
SELECT * from tb1;

[mattn]

addressed in #123

[mattn]

fixed in #123