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

Tables fail to deploy on MySQL #108

Open
kjsanger opened this issue Apr 24, 2019 · 0 comments
Open

Tables fail to deploy on MySQL #108

kjsanger opened this issue Apr 24, 2019 · 0 comments

Comments

@kjsanger
Copy link
Member

Tables having a default value of CURRENT_TIME for a timestamp fail to deploy on MySQL because the function is quoted. This looks like a bug in sql-translator which is a regression on a bug fixed in 2008.

 perl -MWTSI::DNAP::Warehouse::Schema -e 'my $s = WTSI::DNAP::Warehouse::Schema->connect("dbi:mysql:dbname=mlwarehouse;host=xxx.xxx.xxx.xxx", $user, $passord); $s->deploy'

My workaround is to scrape the invalid DDL from STDERR and fix it manually.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant