{"action":"created","issue":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/4","repository_url":"https://api.github.com/repos/natsys/mariadb_10.2","labels_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/4/labels{/name}","comments_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/4/comments","events_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/4/events","html_url":"https://github.com/natsys/mariadb_10.2/issues/4","id":175220702,"number":4,"title":"Select from view over versioned table returns empty resultset","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":[{"url":"https://api.github.com/repos/natsys/mariadb_10.2/labels/bug","name":"bug","color":"ee0701"}],"state":"closed","locked":false,"assignee":{"login":"hagrid-the-developer","id":2307024,"avatar_url":"https://avatars.githubusercontent.com/u/2307024?v=3","gravatar_id":"","url":"https://api.github.com/users/hagrid-the-developer","html_url":"https://github.com/hagrid-the-developer","followers_url":"https://api.github.com/users/hagrid-the-developer/followers","following_url":"https://api.github.com/users/hagrid-the-developer/following{/other_user}","gists_url":"https://api.github.com/users/hagrid-the-developer/gists{/gist_id}","starred_url":"https://api.github.com/users/hagrid-the-developer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hagrid-the-developer/subscriptions","organizations_url":"https://api.github.com/users/hagrid-the-developer/orgs","repos_url":"https://api.github.com/users/hagrid-the-developer/repos","events_url":"https://api.github.com/users/hagrid-the-developer/events{/privacy}","received_events_url":"https://api.github.com/users/hagrid-the-developer/received_events","type":"User","site_admin":false},"assignees":[{"login":"hagrid-the-developer","id":2307024,"avatar_url":"https://avatars.githubusercontent.com/u/2307024?v=3","gravatar_id":"","url":"https://api.github.com/users/hagrid-the-developer","html_url":"https://github.com/hagrid-the-developer","followers_url":"https://api.github.com/users/hagrid-the-developer/followers","following_url":"https://api.github.com/users/hagrid-the-developer/following{/other_user}","gists_url":"https://api.github.com/users/hagrid-the-developer/gists{/gist_id}","starred_url":"https://api.github.com/users/hagrid-the-developer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hagrid-the-developer/subscriptions","organizations_url":"https://api.github.com/users/hagrid-the-developer/orgs","repos_url":"https://api.github.com/users/hagrid-the-developer/repos","events_url":"https://api.github.com/users/hagrid-the-developer/events{/privacy}","received_events_url":"https://api.github.com/users/hagrid-the-developer/received_events","type":"User","site_admin":false},{"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/1","html_url":"https://github.com/natsys/mariadb_10.2/milestones/0.1%20Dummy%20SQL","labels_url":"https://api.github.com/repos/natsys/mariadb_10.2/milestones/1/labels","id":1986781,"number":1,"title":"0.1 Dummy SQL","description":"Version with standard syntax. Only whole table can be versioned, table doesn't contain more partitions, there are no hidden columns, no columns without versioning. We use timestamps, not transaction ids. We don't support \"BETWEEN...END\", \"FROM...TO\". We store timestamps, not transaction ids. Feature is implemented on SQL level.","creator":{"login":"krizhanovsky","id":884694,"avatar_url":"https://avatars.githubusercontent.com/u/884694?v=3","gravatar_id":"","url":"https://api.github.com/users/krizhanovsky","html_url":"https://github.com/krizhanovsky","followers_url":"https://api.github.com/users/krizhanovsky/followers","following_url":"https://api.github.com/users/krizhanovsky/following{/other_user}","gists_url":"https://api.github.com/users/krizhanovsky/gists{/gist_id}","starred_url":"https://api.github.com/users/krizhanovsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krizhanovsky/subscriptions","organizations_url":"https://api.github.com/users/krizhanovsky/orgs","repos_url":"https://api.github.com/users/krizhanovsky/repos","events_url":"https://api.github.com/users/krizhanovsky/events{/privacy}","received_events_url":"https://api.github.com/users/krizhanovsky/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":1,"state":"open","created_at":"2016-09-06T17:17:47Z","updated_at":"2016-09-08T14:13:50Z","due_on":"2016-09-16T00:00:00Z","closed_at":null},"comments":23,"created_at":"2016-09-06T11:10:28Z","updated_at":"2016-09-08T14:13:50Z","closed_at":"2016-09-08T14:13:50Z","body":"<a href=\"https://github.com/hagrid-the-developer\"><img src=\"https://avatars.githubusercontent.com/u/2307024?v=3\" align=\"left\" width=\"96\" height=\"96\" hspace=\"10\"></img></a> **Issue by [hagrid-the-developer](https://github.com/hagrid-the-developer)**\n_Monday Sep 05, 2016 at 08:12 GMT_\n_Originally opened as https://github.com/natsys/mariadb/issues/3_\n\n----\n\nIt seems that when one creates system versioned table, creates view over it, runs some insert(s) over the table and/or view and then runs select over the view, then select over view in mysql/mariadb client returns correct values. On the other hand in tests it returns empty set.\r\n\r\nEg. in mysql client:\r\n\r\n    > CREATE TABLE t1(x INT UNSIGNED, y INT UNSIGNED, Sys_start TIMESTAMP(6) GENERATED  ALWAYS AS ROW START, Sys_end TIMESTAMP(6) GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME (Sys_start, Sys_end)) WITH SYSTEM VERSIONING;\r\n    Query OK, 0 rows affected (0.28 sec)\r\n\r\n    > create view vt1 as select x, y from t1;\r\n    Query OK, 0 rows affected (0.05 sec)\r\n\r\n    > insert into t1(x, y) values(1,10);\r\n    Query OK, 1 row affected (0.04 sec)\r\n\r\n    > select * from t1;\r\n     +------+------+----------------------------+----------------------------+\r\n     | x    | y    | Sys_start                  | Sys_end                    |\r\n     +------+------+----------------------------+----------------------------+\r\n     |    1 |   10 | 2016-09-05 10:01:44.392996 | 2038-01-19 04:14:07.000000 |\r\n    +------+------+----------------------------+----------------------------+\r\n    1 row in set (0.01 sec)\r\n\r\n    > select * from vt1;\r\n    +------+------+\r\n    | x    | y    |\r\n    +------+------+\r\n    |    1 |   10 |\r\n    +------+------+\r\n    1 row in set (0.01 sec)\r\n\r\nBut in tests, similar statements lead to empty result for select over view, eg. see [insert test](https://github.com/natsys/mariadb_10.2/blob/df/syntax/mysql-test/r/insert.result#L755-L764) .\n"},"comment":{"url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/comments/245610753","html_url":"https://github.com/natsys/mariadb_10.2/issues/4#issuecomment-245610753","issue_url":"https://api.github.com/repos/natsys/mariadb_10.2/issues/4","id":245610753,"user":{"login":"hagrid-the-developer","id":2307024,"avatar_url":"https://avatars.githubusercontent.com/u/2307024?v=3","gravatar_id":"","url":"https://api.github.com/users/hagrid-the-developer","html_url":"https://github.com/hagrid-the-developer","followers_url":"https://api.github.com/users/hagrid-the-developer/followers","following_url":"https://api.github.com/users/hagrid-the-developer/following{/other_user}","gists_url":"https://api.github.com/users/hagrid-the-developer/gists{/gist_id}","starred_url":"https://api.github.com/users/hagrid-the-developer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hagrid-the-developer/subscriptions","organizations_url":"https://api.github.com/users/hagrid-the-developer/orgs","repos_url":"https://api.github.com/users/hagrid-the-developer/repos","events_url":"https://api.github.com/users/hagrid-the-developer/events{/privacy}","received_events_url":"https://api.github.com/users/hagrid-the-developer/received_events","type":"User","site_admin":false},"created_at":"2016-09-08T14:13:50Z","updated_at":"2016-09-08T14:13:50Z","body":"Tests from commit fc75ca2d3624b019fee720afae160174cfbc71d0 passed and also test for insert now works correctly (selects over views return some values) so closing."}}
{"actor":{"display_login":"hagrid-the-developer"}}