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

CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction #2242

Closed
AlBa231 opened this issue Dec 13, 2018 · 1 comment
Closed

Comments

@AlBa231
Copy link

@AlBa231 AlBa231 commented Dec 13, 2018

Which version and edition of Flyway are you using?

Flyway Community Edition 5.2.4 by Boxfuse

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 Express 14.0.3015

Which operating system are you using?

Windows 10

What did you do?

create script file with content
CREATE FULLTEXT CATALOG comments_catalog;

run command
flyway migrate

What did you expect to see?

Script executed without errors.

What did you see instead?
ERROR: 
Migration V11__CommentsIndex.sql failed
-----------------------------------------
SQL State  : S0000
Error Code : 574
Message    : CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction.
Location   : ...\sql\V11__CommentsIndex.sql (...\sql\V11__CommentsIndex.sql)
Line       : 1
Statement  : 
CREATE FULLTEXT CATALOG comments_catalog;
@axelfontaine axelfontaine added this to the Flyway 6.0.0 milestone Jan 4, 2019
axelfontaine pushed a commit to flyway/flywaydb.org that referenced this issue Feb 11, 2019
@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Feb 11, 2019

Thanks for reporting. Fixed.

dohrayme pushed a commit to dohrayme/flyway that referenced this issue Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants