{"action":"created","issue":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/869","repository_url":"https://api.github.com/repos/serge-rider/dbeaver","labels_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/869/labels{/name}","comments_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/869/comments","events_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/869/events","html_url":"https://github.com/serge-rider/dbeaver/issues/869","id":184223258,"number":869,"title":"Saving a changed trigger in trigger view is not possible","user":{"login":"GiantCrocodile","id":6271057,"avatar_url":"https://avatars.githubusercontent.com/u/6271057?v=3","gravatar_id":"","url":"https://api.github.com/users/GiantCrocodile","html_url":"https://github.com/GiantCrocodile","followers_url":"https://api.github.com/users/GiantCrocodile/followers","following_url":"https://api.github.com/users/GiantCrocodile/following{/other_user}","gists_url":"https://api.github.com/users/GiantCrocodile/gists{/gist_id}","starred_url":"https://api.github.com/users/GiantCrocodile/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GiantCrocodile/subscriptions","organizations_url":"https://api.github.com/users/GiantCrocodile/orgs","repos_url":"https://api.github.com/users/GiantCrocodile/repos","events_url":"https://api.github.com/users/GiantCrocodile/events{/privacy}","received_events_url":"https://api.github.com/users/GiantCrocodile/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/serge-rider/dbeaver/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"assignees":[{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/serge-rider/dbeaver/milestones/27","html_url":"https://github.com/serge-rider/dbeaver/milestones/3.7.7","labels_url":"https://api.github.com/repos/serge-rider/dbeaver/milestones/27/labels","id":2058347,"number":27,"title":"3.7.7","description":"","creator":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":23,"state":"closed","created_at":"2016-10-10T06:30:46Z","updated_at":"2016-10-24T10:26:32Z","due_on":"2016-10-24T00:00:00Z","closed_at":"2016-10-23T22:45:16Z"},"comments":6,"created_at":"2016-10-20T13:01:30Z","updated_at":"2016-10-24T14:19:47Z","closed_at":null,"body":"MariaDB:\r\n1. Create a trigger\r\n2. Open this trigger in its view and change it somehow\r\n3. save it\r\n\r\nDBeaver will generate a create trigger statement but not dropping the previously generated trigger. Also it does generate BEGIN and END block too which has been greated already by manual create statement so it is twice and trigger creation will fail also."},"comment":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/comments/255753710","html_url":"https://github.com/serge-rider/dbeaver/issues/869#issuecomment-255753710","issue_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/869","id":255753710,"user":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"created_at":"2016-10-24T14:19:47Z","updated_at":"2016-10-24T14:19:47Z","body":"Second \";\" you see in the script isn't actually added to trigger body, it is visible only in script preview.\r\nI'll fix this, apparently this can be confusing."}}
{"actor":{"display_login":"serge-rider"}}