{"action":"created","issue":{"url":"https://api.github.com/repos/tempesta-tech/mariadb/issues/219","repository_url":"https://api.github.com/repos/tempesta-tech/mariadb","labels_url":"https://api.github.com/repos/tempesta-tech/mariadb/issues/219/labels{/name}","comments_url":"https://api.github.com/repos/tempesta-tech/mariadb/issues/219/comments","events_url":"https://api.github.com/repos/tempesta-tech/mariadb/issues/219/events","html_url":"https://github.com/tempesta-tech/mariadb/issues/219","id":239501089,"number":219,"title":"Remove implicit versioning when created from SELECT","user":{"login":"midenok","id":3307037,"avatar_url":"https://avatars1.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":446169241,"url":"https://api.github.com/repos/tempesta-tech/mariadb/labels/stacks","name":"stacks","color":"000000","default":false},{"id":442030504,"url":"https://api.github.com/repos/tempesta-tech/mariadb/labels/task","name":"task","color":"0e8a16","default":false}],"state":"open","locked":false,"assignee":{"login":"midenok","id":3307037,"avatar_url":"https://avatars1.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://avatars1.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/tempesta-tech/mariadb/milestones/11","html_url":"https://github.com/tempesta-tech/mariadb/milestone/11","labels_url":"https://api.github.com/repos/tempesta-tech/mariadb/milestones/11/labels","id":2318021,"number":11,"title":"0.11: Multi-schema SELECT","description":"* SELECT by current and historical identifiers;\r\n* traverse DDL table;\r\n* resultset connection;\r\n* Verbose DDL traverse.","creator":{"login":"midenok","id":3307037,"avatar_url":"https://avatars1.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":14,"closed_issues":8,"state":"open","created_at":"2017-02-13T08:37:01Z","updated_at":"2017-06-29T16:35:09Z","due_on":"2017-08-31T07:00:00Z","closed_at":null},"comments":2,"created_at":"2017-06-29T14:36:01Z","updated_at":"2017-06-30T14:25:24Z","closed_at":null,"body":"Related to #157.\r\n\r\n```sql\r\n create or replace table t2 (\r\n y int,\r\n st SYS_TRX_TYPE generated always as row start,\r\n en SYS_TRX_TYPE generated always as row end,\r\n period for system_time (st, en)\r\n ) with system versioning;\r\n create or replace table t3 select * from t2;\r\n```\r\n**t3** is expected to be not versioned.\r\n\r\n**t3**  should be versioned by explicit clause:\r\n```sql\r\n create or replace table t3 with system versioning select * from t2;\r\n```"},"comment":{"url":"https://api.github.com/repos/tempesta-tech/mariadb/issues/comments/312281304","html_url":"https://github.com/tempesta-tech/mariadb/issues/219#issuecomment-312281304","issue_url":"https://api.github.com/repos/tempesta-tech/mariadb/issues/219","id":312281304,"user":{"login":"midenok","id":3307037,"avatar_url":"https://avatars1.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},"created_at":"2017-06-30T14:25:24Z","updated_at":"2017-06-30T14:25:24Z","body":"#### `select_create::field` set\r\n```\r\n#0  select_create::prepare (this=0x7fff8c012040, values=..., u=0x7fff8c0046e0) at /home/midenok/src/mariadb/midenok/src/sql/sql_insert.cc:4420\r\n#1  0x0000555555b98f29 in JOIN::prepare (this=0x7fff8c012138, tables_init=0x7fff8c011808, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fff8c004e40, unit_arg=0x7fff8c0046e0) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:1370\r\n#2  0x0000555555ba22f7 in mysql_select (thd=0x7fff8c000b00, tables=0x7fff8c011808, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7fff8c012040, unit=0x7fff8c0046e0, select_lex=0x7fff8c004e40) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:3993\r\n#3  0x0000555555b94bfa in handle_select (thd=0x7fff8c000b00, lex=0x7fff8c004618, result=0x7fff8c012040, setup_tables_done_option=0) at /home/midenok/src/mariadb/midenok/src/sql/sql_select.cc:363\r\n#4  0x0000555555b58d62 in mysql_execute_command (thd=0x7fff8c000b00) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:4044\r\n#5  0x0000555555b6316e in mysql_parse (thd=0x7fff8c000b00, rawbuf=0x7fff8c010f58 \"create or replace table t2 with system versioning as select * from t1\", length=69, parser_state=0x7fffe574c6b0, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/midenok/src/sql/sql_parse.cc:7902\r\n```"}}
{"actor":{"display_login":"midenok"}}