{"action":"created","issue":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/83","repository_url":"https://api.github.com/repos/natsys/mariadb_10.2","labels_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/83/labels{/name}","comments_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/83/comments","events_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/83/events","html_url":"https://github.com/natsys/mariadb_10.2/issues/83","id":192733695,"number":83,"title":"Postpone or renounce versioned DDL feature","user":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"labels":[{"id":388954541,"url":"https://api.github.com/repos/natsys/mariadb_10.2/labels/talk","name":"talk","color":"ffff66","default":false}],"state":"open","locked":false,"assignee":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"assignees":[{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/milestones/6","html_url":"https://github.com/natsys/mariadb_10.2/milestones/0.6:%20InnoDB%20partitioning,%20DDL%20Survival","labels_url":"https://api.github.com/repos/natsys/mariadb_10.2/milestones/6/labels","id":2120718,"number":6,"title":"0.6: InnoDB partitioning, DDL Survival","description":"","creator":{"login":"midenok","id":3307037,"avatar_url":"https://avatars.githubusercontent.com/u/3307037?v=3","gravatar_id":"","url":"https://api.github.com/users/midenok","html_url":"https://github.com/midenok","followers_url":"https://api.github.com/users/midenok/followers","following_url":"https://api.github.com/users/midenok/following{/other_user}","gists_url":"https://api.github.com/users/midenok/gists{/gist_id}","starred_url":"https://api.github.com/users/midenok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midenok/subscriptions","organizations_url":"https://api.github.com/users/midenok/orgs","repos_url":"https://api.github.com/users/midenok/repos","events_url":"https://api.github.com/users/midenok/events{/privacy}","received_events_url":"https://api.github.com/users/midenok/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2016-11-08T02:08:38Z","updated_at":"2016-12-01T01:51:02Z","due_on":"2017-01-16T00:00:00Z","closed_at":null},"comments":2,"created_at":"2016-12-01T01:50:33Z","updated_at":"2016-12-07T14:36:19Z","closed_at":null,"body":"Due to complex logic especially in case of `select * from t1 for system_time all` and doubtful advantages propose to renounce *versioned DDL* or postpone to 2.0 until feedback from users. \r\n\r\nInstead of *versioned DDL* propose to add 3 modes of ALTER TABLE:\r\n1. if history is influenced (like when dropping a field), extract history to a separate table;\r\n2. do nothing special about history (the table will contain modified history).\r\n3. combine 1. and 2."},"comment":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/comments/265462669","html_url":"https://github.com/natsys/mariadb_10.2/issues/83#issuecomment-265462669","issue_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/83","id":265462669,"user":{"login":"kevgs","id":2688122,"avatar_url":"https://avatars.githubusercontent.com/u/2688122?v=3","gravatar_id":"","url":"https://api.github.com/users/kevgs","html_url":"https://github.com/kevgs","followers_url":"https://api.github.com/users/kevgs/followers","following_url":"https://api.github.com/users/kevgs/following{/other_user}","gists_url":"https://api.github.com/users/kevgs/gists{/gist_id}","starred_url":"https://api.github.com/users/kevgs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kevgs/subscriptions","organizations_url":"https://api.github.com/users/kevgs/orgs","repos_url":"https://api.github.com/users/kevgs/repos","events_url":"https://api.github.com/users/kevgs/events{/privacy}","received_events_url":"https://api.github.com/users/kevgs/received_events","type":"User","site_admin":false},"created_at":"2016-12-07T14:36:19Z","updated_at":"2016-12-07T14:36:19Z","body":"**Current status.**\r\n\r\nALTER works, but it works on a single table. On column ADD/DROP/MODIFY history get lost both in InnoDB and other engines. So, it works as in 2. item of an initial post here.\r\n\r\nNote on InnoDB. It implements ALTER queries internally (instead of in SQL level). And it implements both `INPLACE` and `COPY` algorithms. These queries do not work and temporarily disallowed and should be implemented in future.\r\n```sql\r\nALTER TABLE t WITH SYSTEM VERSIONING, ALGORITHM=INPLACE;\r\nALTER TABLE t WITHOUT SYSTEM VERSIONING, ALGORITHM=INPLACE;\r\n```"}}
{"actor":{"display_login":"kevgs"}}