Flyway: Cannot create AD account on MSSSQL

[gorille]

Which version and edition of Flyway are you using?

6.0.1

If this is not the latest version, can you reproduce the issue with the latest one as well?

(Many bugs are fixed in newer releases and upgrading will often resolve the issue)

Latest version : N/A

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Command line

Which database are you using (type & version)?

MS SQL SERVER 14

Which operating system are you using?

Windows

What did you do?

(Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)

Try to create a user for a windows account
CREATE USER [JohnDoe] FOR LOGIN [CONTOSO\JohnDoe]

What did you expect to see?

User created in the DB

What did you see instead?

Unknown char \ encountered

Error while parsing the SQL file

Additionnal info:

see issue #2329 and commit fdb6b1b the char "\ " is not part of the allowed char, but it is required in this case by Sql server syntax.

I've looked at the help, here there is no workaround to avoid using theis char in this case

[alextercete]

@gorille Thanks for the report! We'll include a fix for this with the next release.