{"action":"created","issue":{"url":"https://api.github.com/repos/dbeaver/dbeaver/issues/1624","repository_url":"https://api.github.com/repos/dbeaver/dbeaver","labels_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/1624/labels{/name}","comments_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/1624/comments","events_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/1624/events","html_url":"https://github.com/dbeaver/dbeaver/issues/1624","id":225765198,"node_id":"MDU6SXNzdWUyMjU3NjUxOTg=","number":1624,"title":"Can't insert/update boolean data.","user":{"login":"hunsakerbn","id":4139627,"node_id":"MDQ6VXNlcjQxMzk2Mjc=","avatar_url":"https://avatars0.githubusercontent.com/u/4139627?v=4","gravatar_id":"","url":"https://api.github.com/users/hunsakerbn","html_url":"https://github.com/hunsakerbn","followers_url":"https://api.github.com/users/hunsakerbn/followers","following_url":"https://api.github.com/users/hunsakerbn/following{/other_user}","gists_url":"https://api.github.com/users/hunsakerbn/gists{/gist_id}","starred_url":"https://api.github.com/users/hunsakerbn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hunsakerbn/subscriptions","organizations_url":"https://api.github.com/users/hunsakerbn/orgs","repos_url":"https://api.github.com/users/hunsakerbn/repos","events_url":"https://api.github.com/users/hunsakerbn/events{/privacy}","received_events_url":"https://api.github.com/users/hunsakerbn/received_events","type":"User","site_admin":false},"labels":[{"id":275893721,"node_id":"MDU6TGFiZWwyNzU4OTM3MjE=","url":"https://api.github.com/repos/dbeaver/dbeaver/labels/bug","name":"bug","color":"b60205","default":true},{"id":277685174,"node_id":"MDU6TGFiZWwyNzc2ODUxNzQ=","url":"https://api.github.com/repos/dbeaver/dbeaver/labels/can't%20reproduce","name":"can't reproduce","color":"bfdadc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2017-05-02T17:28:48Z","updated_at":"2018-10-09T10:04:35Z","closed_at":null,"author_association":"NONE","body":"In PostgreSQL, given the following table:\r\ncreate table btest (\r\n  id integer not null,\r\n  bflag boolean\r\n);\r\n\r\nI should be able to insert a new row with the bflag column set to either null, true or false.\r\nHowever a new row value defaults to false, but null in inserted.  Selecting true still inserts a null.\r\nWhen trying to modify the column after insert DBeaver thinks nothing has modified, as the 'save' buttom remains greyed out, unless I also modify the 'id' column.  Howver, the boolean column is still unmodified after the save and remains null.  If I try to modify an existing row that has  either a true or false value already set, Again, the save button remains greyed out and I cannot save the change. Also there is no way to select null as an option to replace the exiting value.\r\n\r\nThis is in DBeaver enterprise Version 4.0.5 on MacOS Sierra."},"comment":{"url":"https://api.github.com/repos/dbeaver/dbeaver/issues/comments/428135284","html_url":"https://github.com/dbeaver/dbeaver/issues/1624#issuecomment-428135284","issue_url":"https://api.github.com/repos/dbeaver/dbeaver/issues/1624","id":428135284,"node_id":"MDEyOklzc3VlQ29tbWVudDQyODEzNTI4NA==","user":{"login":"ufon","id":4355972,"node_id":"MDQ6VXNlcjQzNTU5NzI=","avatar_url":"https://avatars2.githubusercontent.com/u/4355972?v=4","gravatar_id":"","url":"https://api.github.com/users/ufon","html_url":"https://github.com/ufon","followers_url":"https://api.github.com/users/ufon/followers","following_url":"https://api.github.com/users/ufon/following{/other_user}","gists_url":"https://api.github.com/users/ufon/gists{/gist_id}","starred_url":"https://api.github.com/users/ufon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ufon/subscriptions","organizations_url":"https://api.github.com/users/ufon/orgs","repos_url":"https://api.github.com/users/ufon/repos","events_url":"https://api.github.com/users/ufon/events{/privacy}","received_events_url":"https://api.github.com/users/ufon/received_events","type":"User","site_admin":false},"created_at":"2018-10-09T10:04:35Z","updated_at":"2018-10-09T10:04:35Z","author_association":"NONE","body":"same situation +1"}}
{"actor":{"display_login":"ufon"}}