{"action":"created","issue":{"url":"https://api.github.com/repos/flyway/flyway/issues/995","labels_url":"https://api.github.com/repos/flyway/flyway/issues/995/labels{/name}","comments_url":"https://api.github.com/repos/flyway/flyway/issues/995/comments","events_url":"https://api.github.com/repos/flyway/flyway/issues/995/events","html_url":"https://github.com/flyway/flyway/issues/995","id":69442491,"number":995,"title":"Error setting current schema to \"public\"","user":{"login":"gnomff","id":4885068,"avatar_url":"https://avatars.githubusercontent.com/u/4885068?v=3","gravatar_id":"","url":"https://api.github.com/users/gnomff","html_url":"https://github.com/gnomff","followers_url":"https://api.github.com/users/gnomff/followers","following_url":"https://api.github.com/users/gnomff/following{/other_user}","gists_url":"https://api.github.com/users/gnomff/gists{/gist_id}","starred_url":"https://api.github.com/users/gnomff/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gnomff/subscriptions","organizations_url":"https://api.github.com/users/gnomff/orgs","repos_url":"https://api.github.com/users/gnomff/repos","events_url":"https://api.github.com/users/gnomff/events{/privacy}","received_events_url":"https://api.github.com/users/gnomff/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-19T16:45:18Z","updated_at":"2015-04-20T06:33:37Z","closed_at":null,"body":"With the following settings in flyway-gradle-plugin version 3.2.1\r\n\r\nflyway{\r\n    url = \"jdbc:h2:mem;MODE=MySQL\"\r\n    user = \"sa\"\r\n    schemas = [\"PUBLIC\"]\r\n}\r\nI get the following error: Error setting current schema to \"public\"\r\n\r\nWhat was strange about this error was when I turned on debug I could see the PUBLIC schema get populated with the schema_version table and the migrations ran without error. The plugin reported the error *after* running almost to completion. \r\n\r\nTacking INIT=CREATE SCHEMA IF NOT EXISTS \"public\" to the end of the url worked as a work around."},"comment":{"url":"https://api.github.com/repos/flyway/flyway/issues/comments/94370391","html_url":"https://github.com/flyway/flyway/issues/995#issuecomment-94370391","issue_url":"https://api.github.com/repos/flyway/flyway/issues/995","id":94370391,"user":{"login":"axelfontaine","id":684824,"avatar_url":"https://avatars.githubusercontent.com/u/684824?v=3","gravatar_id":"","url":"https://api.github.com/users/axelfontaine","html_url":"https://github.com/axelfontaine","followers_url":"https://api.github.com/users/axelfontaine/followers","following_url":"https://api.github.com/users/axelfontaine/following{/other_user}","gists_url":"https://api.github.com/users/axelfontaine/gists{/gist_id}","starred_url":"https://api.github.com/users/axelfontaine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/axelfontaine/subscriptions","organizations_url":"https://api.github.com/users/axelfontaine/orgs","repos_url":"https://api.github.com/users/axelfontaine/repos","events_url":"https://api.github.com/users/axelfontaine/events{/privacy}","received_events_url":"https://api.github.com/users/axelfontaine/received_events","type":"User","site_admin":false},"created_at":"2015-04-20T06:33:37Z","updated_at":"2015-04-20T06:33:37Z","body":"There are still some issues with h2 and the various db compatibility modes. In the future we want to provide the possibility to override the db autodetection with a specific db type, which would most likely fix this."}}