Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot create AD account on MSSSQL #2500

Closed
gorille opened this issue Sep 9, 2019 · 1 comment

Comments

@gorille
Copy link

@gorille gorille commented Sep 9, 2019

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

This comment has been minimized.

Copy link
Member

@alextercete alextercete commented Sep 12, 2019

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

@juliahayward juliahayward added this to the Flyway 6.0.3 milestone Sep 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
3 participants
You can’t perform that action at this time.