{"action":"created","issue":{"url":"https://api.github.com/repos/javalite/activejdbc/issues/414","repository_url":"https://api.github.com/repos/javalite/activejdbc","labels_url":"https://api.github.com/repos/javalite/activejdbc/issues/414/labels{/name}","comments_url":"https://api.github.com/repos/javalite/activejdbc/issues/414/comments","events_url":"https://api.github.com/repos/javalite/activejdbc/issues/414/events","html_url":"https://github.com/javalite/activejdbc/issues/414","id":99304376,"number":414,"title":"BUG: Migrations containing strings that span more than one line and have \\; fail to run","user":{"login":"lemmingapex","id":121667,"avatar_url":"https://avatars.githubusercontent.com/u/121667?v=3","gravatar_id":"","url":"https://api.github.com/users/lemmingapex","html_url":"https://github.com/lemmingapex","followers_url":"https://api.github.com/users/lemmingapex/followers","following_url":"https://api.github.com/users/lemmingapex/following{/other_user}","gists_url":"https://api.github.com/users/lemmingapex/gists{/gist_id}","starred_url":"https://api.github.com/users/lemmingapex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lemmingapex/subscriptions","organizations_url":"https://api.github.com/users/lemmingapex/orgs","repos_url":"https://api.github.com/users/lemmingapex/repos","events_url":"https://api.github.com/users/lemmingapex/events{/privacy}","received_events_url":"https://api.github.com/users/lemmingapex/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"ipolevoy","id":500941,"avatar_url":"https://avatars.githubusercontent.com/u/500941?v=3","gravatar_id":"","url":"https://api.github.com/users/ipolevoy","html_url":"https://github.com/ipolevoy","followers_url":"https://api.github.com/users/ipolevoy/followers","following_url":"https://api.github.com/users/ipolevoy/following{/other_user}","gists_url":"https://api.github.com/users/ipolevoy/gists{/gist_id}","starred_url":"https://api.github.com/users/ipolevoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ipolevoy/subscriptions","organizations_url":"https://api.github.com/users/ipolevoy/orgs","repos_url":"https://api.github.com/users/ipolevoy/repos","events_url":"https://api.github.com/users/ipolevoy/events{/privacy}","received_events_url":"https://api.github.com/users/ipolevoy/received_events","type":"User","site_admin":false},"milestone":null,"comments":40,"created_at":"2015-08-05T21:37:45Z","updated_at":"2016-03-09T22:22:19Z","closed_at":null,"body":"All of the statements below are valid, but only the first half run correctly when using the migrator:\r\n\r\n<pre>\r\nINSERT INTO `mytable` (`STATUS`, `SOMEVARCHAR`) VALUES('works as expected', 'good\\;');\r\nINSERT INTO `mytable` (`STATUS`, `SOMEVARCHAR`) VALUES('works as expected', 'good\\;good');\r\nINSERT INTO `mytable` (`STATUS`, `SOMEVARCHAR`) VALUES('works as expected', 'goodgood\r\n');\r\n\r\nINSERT INTO `mytable` (`STATUS`, `SOMEVARCHAR`) VALUES('fails unexpectedly', 'broken\\;\r\n');\r\nINSERT INTO `mytable` (`STATUS`, `SOMEVARCHAR`) VALUES('fails unexpectedly', 'still\\;broken\r\n');\r\nINSERT INTO `mytable` (`STATUS`, `SOMEVARCHAR`) VALUES('fails unexpectedly', '\\;\r\n');\r\n</pre>\r\n\r\nA string should be able to contain '\\;' without having to be on the same line as the end of statement default delimiter (;).\r\n\r\nThe problem seems to exist in Migration.java when attempting to check for the end of an line.  The escaped semi-colon '\\;', a valid varchar character, need also be checked."},"comment":{"url":"https://api.github.com/repos/javalite/activejdbc/issues/comments/194536564","html_url":"https://github.com/javalite/activejdbc/issues/414#issuecomment-194536564","issue_url":"https://api.github.com/repos/javalite/activejdbc/issues/414","id":194536564,"user":{"login":"ipolevoy","id":500941,"avatar_url":"https://avatars.githubusercontent.com/u/500941?v=3","gravatar_id":"","url":"https://api.github.com/users/ipolevoy","html_url":"https://github.com/ipolevoy","followers_url":"https://api.github.com/users/ipolevoy/followers","following_url":"https://api.github.com/users/ipolevoy/following{/other_user}","gists_url":"https://api.github.com/users/ipolevoy/gists{/gist_id}","starred_url":"https://api.github.com/users/ipolevoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ipolevoy/subscriptions","organizations_url":"https://api.github.com/users/ipolevoy/orgs","repos_url":"https://api.github.com/users/ipolevoy/repos","events_url":"https://api.github.com/users/ipolevoy/events{/privacy}","received_events_url":"https://api.github.com/users/ipolevoy/received_events","type":"User","site_admin":false},"created_at":"2016-03-09T22:22:19Z","updated_at":"2016-03-09T22:22:19Z","body":"@Typografikon , no problem. I will let it hang till you test it. However, internal tests passes (see above) . \r\n"}}