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

DROP FULLTEXT INDEX statement cannot be used inside a user transaction. #2071

Closed
mehta-m opened this issue Jul 6, 2018 · 3 comments
Closed

DROP FULLTEXT INDEX statement cannot be used inside a user transaction. #2071

mehta-m opened this issue Jul 6, 2018 · 3 comments

Comments

@mehta-m
Copy link

@mehta-m mehta-m commented Jul 6, 2018

Flyway Version: 4.2.0
Commandline
Microsoft Sql Server 2012
OS: Windows Server 2012 R2

What did you do?

I've a migration where I've only 1 statement: DROP FULLTEXT INDEX on SomeTable Name
On running the migrate command I get an error: Error Message: DROP FULLTEXT INDEX statement cannot be used inside a user transaction.
Now I understand that for each migration Flyway automatically starts a transaction. So how do i execute this script outside of a transaction.

What did you expect to see?
What did you see instead?
@axelfontaine axelfontaine added this to the Flyway 5.2.0 milestone Jul 6, 2018
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Jul 6, 2018
@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Jul 6, 2018

Thanks. Good catch. Fixed.

@mehta-m
Copy link
Author

@mehta-m mehta-m commented Jul 9, 2018

Thank you Axel. When can i expect 5.2.0 version to be available ?

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
You can’t perform that action at this time.