{"action":"created","issue":{"url":"https://api.github.com/repos/h2database/h2database/issues/997","repository_url":"https://api.github.com/repos/h2database/h2database","labels_url":"https://api.github.com/repos/h2database/h2database/issues/997/labels{/name}","comments_url":"https://api.github.com/repos/h2database/h2database/issues/997/comments","events_url":"https://api.github.com/repos/h2database/h2database/issues/997/events","html_url":"https://github.com/h2database/h2database/issues/997","id":306520225,"number":997,"title":"Can not delete from tables with enums","user":{"login":"Goldenflamer","id":6607912,"avatar_url":"https://avatars0.githubusercontent.com/u/6607912?v=4","gravatar_id":"","url":"https://api.github.com/users/Goldenflamer","html_url":"https://github.com/Goldenflamer","followers_url":"https://api.github.com/users/Goldenflamer/followers","following_url":"https://api.github.com/users/Goldenflamer/following{/other_user}","gists_url":"https://api.github.com/users/Goldenflamer/gists{/gist_id}","starred_url":"https://api.github.com/users/Goldenflamer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Goldenflamer/subscriptions","organizations_url":"https://api.github.com/users/Goldenflamer/orgs","repos_url":"https://api.github.com/users/Goldenflamer/repos","events_url":"https://api.github.com/users/Goldenflamer/events{/privacy}","received_events_url":"https://api.github.com/users/Goldenflamer/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-03-19T15:49:21Z","updated_at":"2018-03-19T18:24:06Z","closed_at":null,"author_association":"NONE","body":"Todays new release brought in a very critical bug fully stopping me from working with H2. (Version 1.4.197)\r\n\r\nYou can no longer delete from tables with enums. This makes the new release completly useless.\r\n\r\nError: Empty enums are not allowed; SQL statement:\r\nDELETE FROM PERSON_TABLE;\r\n\r\nAlso filtering for a specific enum type does not work.\r\nEmpty enums are not allowed; SQL statement:\r\nDELETE FROM PERSON_TABLE WHERE LICENSE='A' [22032-197] 22032/22032"},"comment":{"url":"https://api.github.com/repos/h2database/h2database/issues/comments/374316079","html_url":"https://github.com/h2database/h2database/issues/997#issuecomment-374316079","issue_url":"https://api.github.com/repos/h2database/h2database/issues/997","id":374316079,"user":{"login":"Goldenflamer","id":6607912,"avatar_url":"https://avatars0.githubusercontent.com/u/6607912?v=4","gravatar_id":"","url":"https://api.github.com/users/Goldenflamer","html_url":"https://github.com/Goldenflamer","followers_url":"https://api.github.com/users/Goldenflamer/followers","following_url":"https://api.github.com/users/Goldenflamer/following{/other_user}","gists_url":"https://api.github.com/users/Goldenflamer/gists{/gist_id}","starred_url":"https://api.github.com/users/Goldenflamer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Goldenflamer/subscriptions","organizations_url":"https://api.github.com/users/Goldenflamer/orgs","repos_url":"https://api.github.com/users/Goldenflamer/repos","events_url":"https://api.github.com/users/Goldenflamer/events{/privacy}","received_events_url":"https://api.github.com/users/Goldenflamer/received_events","type":"User","site_admin":false},"created_at":"2018-03-19T18:24:06Z","updated_at":"2018-03-19T18:24:06Z","author_association":"NONE","body":"It is really a strange problem as it just worked fine, but after restarting the connection I get the error again.\r\n\r\nLeere Aufzählungen sind nicht erlaubt\r\nEmpty enums are not allowed; SQL statement:\r\nDELETE FROM VEHICLE_HAS_LICENSE [22032-197] 22032/22032 (Hilfe)\r\norg.h2.jdbc.JdbcSQLException: Leere Aufzählungen sind nicht erlaubt\r\nEmpty enums are not allowed; SQL statement:\r\nDELETE FROM VEHICLE_HAS_LICENSE [22032-197] \r\n    at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) \r\n    at org.h2.message.DbException.get(DbException.java:179) \r\n    at org.h2.message.DbException.get(DbException.java:155) \r\n    at org.h2.message.DbException.get(DbException.java:144) \r\n    at org.h2.value.ValueEnum.check(ValueEnum.java:38) \r\n    at org.h2.value.ValueEnum.check(ValueEnum.java:49) \r\n    at org.h2.value.ValueEnum.get(ValueEnum.java:71) \r\n    at org.h2.value.Value.convertTo(Value.java:980) \r\n    at org.h2.value.Value.convertTo(Value.java:617) \r\n    at org.h2.value.Value.convertTo(Value.java:592) \r\n    at org.h2.mvstore.db.MVSecondaryIndex.convertToKey(MVSecondaryIndex.java:326) \r\n    at org.h2.mvstore.db.MVSecondaryIndex.remove(MVSecondaryIndex.java:243) \r\n    at org.h2.mvstore.db.MVTable.removeRow(MVTable.java:706) \r\n    at org.h2.command.dml.Delete.update(Delete.java:102) \r\n    at org.h2.command.CommandContainer.update(CommandContainer.java:102) \r\n    at org.h2.command.Command.executeUpdate(Command.java:261) \r\n    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:233) \r\n    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:1077) \r\n    at org.h2.server.web.WebApp.getResult(WebApp.java:1386) \r\n    at org.h2.server.web.WebApp.query(WebApp.java:1060) \r\n    at org.h2.server.web.WebApp$1.next(WebApp.java:1022) \r\n    at org.h2.server.web.WebApp$1.next(WebApp.java:1009) \r\n    at org.h2.server.web.WebThread.process(WebThread.java:165) \r\n    at org.h2.server.web.WebThread.run(WebThread.java:90) \r\n    at java.base/java.lang.Thread.run(Unknown Source) "}}
{"actor":{"display_login":"Goldenflamer"}}