{"action":"created","issue":{"url":"https://api.github.com/repos/flyway/flyway/issues/1817","repository_url":"https://api.github.com/repos/flyway/flyway","labels_url":"https://api.github.com/repos/flyway/flyway/issues/1817/labels{/name}","comments_url":"https://api.github.com/repos/flyway/flyway/issues/1817/comments","events_url":"https://api.github.com/repos/flyway/flyway/issues/1817/events","html_url":"https://github.com/flyway/flyway/issues/1817","id":271815184,"number":1817,"title":"Original build script no longer executes under flyway command line version 4.2.0","user":{"login":"Rob34","id":11665005,"avatar_url":"https://avatars2.githubusercontent.com/u/11665005?v=4","gravatar_id":"","url":"https://api.github.com/users/Rob34","html_url":"https://github.com/Rob34","followers_url":"https://api.github.com/users/Rob34/followers","following_url":"https://api.github.com/users/Rob34/following{/other_user}","gists_url":"https://api.github.com/users/Rob34/gists{/gist_id}","starred_url":"https://api.github.com/users/Rob34/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rob34/subscriptions","organizations_url":"https://api.github.com/users/Rob34/orgs","repos_url":"https://api.github.com/users/Rob34/repos","events_url":"https://api.github.com/users/Rob34/events{/privacy}","received_events_url":"https://api.github.com/users/Rob34/received_events","type":"User","site_admin":false},"labels":[{"id":44945609,"url":"https://api.github.com/repos/flyway/flyway/labels/d:%20DB2","name":"d: DB2","color":"009800","default":false},{"id":164837567,"url":"https://api.github.com/repos/flyway/flyway/labels/s:%20waiting%20for%20feedback","name":"s: waiting for feedback","color":"FF8C00","default":false},{"id":22191326,"url":"https://api.github.com/repos/flyway/flyway/labels/t:%20bug","name":"t: bug","color":"fc2929","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-11-07T12:31:49Z","updated_at":"2017-11-09T10:38:54Z","closed_at":null,"author_association":"NONE","body":"###### What version of Flyway are you using?\r\n\r\n4.2.0\r\n\r\n###### Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin, SBT plugin, ANT tasks)\r\n\r\nCommand-line\r\n\r\n###### What database are you using (type & version)?\r\n\r\ndb2 10.5 fp6\r\n\r\n###### What operating system are you using?\r\n\r\naix 7.1\r\n\r\n###### What did you do?\r\n(Please include the content causing the issue, any relevant configuration settings, and the command you ran)\r\n\r\nStarted the process of upgrading flyway from 2.3 to 4.2. However, the initial tests to clean and migrate existing scripts are failing when running truncate. The same scripts have been running successfully for a couple of years under 2.3. \r\n\r\nThe error indicates that the ddl is not being auto committed in 4.2.\r\n\r\n###### What did you expect to see?\r\n\r\nThe truncate statement to execute successfully as it does in 2.3.\r\n\r\n###### What did you see instead?\r\n\r\nMigration fails at the truncate statement.\r\n\r\nAttached is the snippet of debug out from both releases of flyway migrate.\r\n[Flyway_Issue.txt](https://github.com/flyway/flyway/files/1449957/Flyway_Issue.txt)\r\n"},"comment":{"url":"https://api.github.com/repos/flyway/flyway/issues/comments/343115472","html_url":"https://github.com/flyway/flyway/issues/1817#issuecomment-343115472","issue_url":"https://api.github.com/repos/flyway/flyway/issues/1817","id":343115472,"user":{"login":"Rob34","id":11665005,"avatar_url":"https://avatars2.githubusercontent.com/u/11665005?v=4","gravatar_id":"","url":"https://api.github.com/users/Rob34","html_url":"https://github.com/Rob34","followers_url":"https://api.github.com/users/Rob34/followers","following_url":"https://api.github.com/users/Rob34/following{/other_user}","gists_url":"https://api.github.com/users/Rob34/gists{/gist_id}","starred_url":"https://api.github.com/users/Rob34/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rob34/subscriptions","organizations_url":"https://api.github.com/users/Rob34/orgs","repos_url":"https://api.github.com/users/Rob34/repos","events_url":"https://api.github.com/users/Rob34/events{/privacy}","received_events_url":"https://api.github.com/users/Rob34/received_events","type":"User","site_admin":false},"created_at":"2017-11-09T10:38:54Z","updated_at":"2017-11-09T10:38:54Z","author_association":"NONE","body":"Thread has been updated as requested.\n\n*Robert Ord*\nPrincipal DBA\nM: 07968 939689 W: *www.camelotgroup.co.uk <http://www.camelotgroup.co.uk/>*\n[image: Camelot Logo] <http://www.camelotgroup.co.uk>\n\nOn 8 November 2017 at 18:47, Axel Fontaine <notifications@github.com> wrote:\n\n> Please share the smallest possible SQL file which triggers this issue, so\n> we can reproduce it.\n>\n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/flyway/flyway/issues/1817#issuecomment-342919620>, or mute\n> the thread\n> <https://github.com/notifications/unsubscribe-auth/ALH-bZuRrfs1xr4DxzbwDGYS5ESRMWsVks5s0fctgaJpZM4QUt6b>\n> .\n>\n\n-- \nThis e-mail is subject to our Legal Notice which you can view here: Camelot’s \nLegal Notice <http://www.camelotgroup.co.uk/camelotemaildisclaimer1>\n"}}
{"actor":{"display_login":"Rob34"}}