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

Scripts with empty description fail on Oracle #2620

Closed
juliahayward opened this issue Jan 10, 2020 · 1 comment
Closed

Scripts with empty description fail on Oracle #2620

juliahayward opened this issue Jan 10, 2020 · 1 comment

Comments

@juliahayward
Copy link
Member

@juliahayward juliahayward commented Jan 10, 2020

To reproduce:

  • create a script V1.sql (contents are irrelevant, as long as they succeed - eg. SELECT 1 FROM DUAL)
  • migrate

On Oracle - and presumably other databases that conflate null and empty-string - this will fail as Flyway tries to insert a null description into the history table.

@juliahayward
Copy link
Member Author

@juliahayward juliahayward commented Jan 13, 2020

Added to this, when you INSERT empty-string into a Sybase table, it converts it to a single space. This means that when we validate, the saved description no longer matches the original.

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
Development

No branches or pull requests

2 participants