{"action":"created","issue":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/2319","repository_url":"https://api.github.com/repos/Starcounter/Starcounter","labels_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/2319/labels{/name}","comments_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/2319/comments","events_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/2319/events","html_url":"https://github.com/Starcounter/Starcounter/issues/2319","id":45479036,"number":2319,"title":"No query after semicolon should be allowed","user":{"login":"k-rus","id":1726044,"avatar_url":"https://avatars.githubusercontent.com/u/1726044?v=3","gravatar_id":"","url":"https://api.github.com/users/k-rus","html_url":"https://github.com/k-rus","followers_url":"https://api.github.com/users/k-rus/followers","following_url":"https://api.github.com/users/k-rus/following{/other_user}","gists_url":"https://api.github.com/users/k-rus/gists{/gist_id}","starred_url":"https://api.github.com/users/k-rus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k-rus/subscriptions","organizations_url":"https://api.github.com/users/k-rus/orgs","repos_url":"https://api.github.com/users/k-rus/repos","events_url":"https://api.github.com/users/k-rus/events{/privacy}","received_events_url":"https://api.github.com/users/k-rus/received_events","type":"User","site_admin":false},"labels":[{"id":4413435,"url":"https://api.github.com/repos/Starcounter/Starcounter/labels/bug","name":"bug","color":"e11d21","default":true},{"id":105466877,"url":"https://api.github.com/repos/Starcounter/Starcounter/labels/NewSQL","name":"NewSQL","color":"009800","default":false},{"id":34566885,"url":"https://api.github.com/repos/Starcounter/Starcounter/labels/SQL","name":"SQL","color":"000000","default":false}],"state":"open","locked":false,"assignee":{"login":"andan342","id":6973101,"avatar_url":"https://avatars.githubusercontent.com/u/6973101?v=3","gravatar_id":"","url":"https://api.github.com/users/andan342","html_url":"https://github.com/andan342","followers_url":"https://api.github.com/users/andan342/followers","following_url":"https://api.github.com/users/andan342/following{/other_user}","gists_url":"https://api.github.com/users/andan342/gists{/gist_id}","starred_url":"https://api.github.com/users/andan342/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andan342/subscriptions","organizations_url":"https://api.github.com/users/andan342/orgs","repos_url":"https://api.github.com/users/andan342/repos","events_url":"https://api.github.com/users/andan342/events{/privacy}","received_events_url":"https://api.github.com/users/andan342/received_events","type":"User","site_admin":false},"assignees":[{"login":"andan342","id":6973101,"avatar_url":"https://avatars.githubusercontent.com/u/6973101?v=3","gravatar_id":"","url":"https://api.github.com/users/andan342","html_url":"https://github.com/andan342","followers_url":"https://api.github.com/users/andan342/followers","following_url":"https://api.github.com/users/andan342/following{/other_user}","gists_url":"https://api.github.com/users/andan342/gists{/gist_id}","starred_url":"https://api.github.com/users/andan342/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andan342/subscriptions","organizations_url":"https://api.github.com/users/andan342/orgs","repos_url":"https://api.github.com/users/andan342/repos","events_url":"https://api.github.com/users/andan342/events{/privacy}","received_events_url":"https://api.github.com/users/andan342/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/Starcounter/Starcounter/milestones/56","html_url":"https://github.com/Starcounter/Starcounter/milestone/56","labels_url":"https://api.github.com/repos/Starcounter/Starcounter/milestones/56/labels","id":685034,"number":56,"title":"NewSQL","description":"","creator":{"login":"dan31","id":7162535,"avatar_url":"https://avatars.githubusercontent.com/u/7162535?v=3","gravatar_id":"","url":"https://api.github.com/users/dan31","html_url":"https://github.com/dan31","followers_url":"https://api.github.com/users/dan31/followers","following_url":"https://api.github.com/users/dan31/following{/other_user}","gists_url":"https://api.github.com/users/dan31/gists{/gist_id}","starred_url":"https://api.github.com/users/dan31/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dan31/subscriptions","organizations_url":"https://api.github.com/users/dan31/orgs","repos_url":"https://api.github.com/users/dan31/repos","events_url":"https://api.github.com/users/dan31/events{/privacy}","received_events_url":"https://api.github.com/users/dan31/received_events","type":"User","site_admin":false},"open_issues":29,"closed_issues":21,"state":"open","created_at":"2014-06-09T08:40:57Z","updated_at":"2016-11-16T18:59:27Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2014-10-10T13:14:46Z","updated_at":"2016-12-14T09:58:13Z","closed_at":null,"body":"`;` is used to separate multiple queries in a single string. The following statement parses fine:\n\n``` sql\nSELECT a[MyNamespace.Father].Name FROM Person a WHERE a.Name = 'Alice';\nSELECT a[MyNamespace.Father].Name FROM Person a WHERE a.Name = 'Alice'\n```\n\nNotice that the last statement does not contain `;` at the end. It is common to present `;` at the end, but it does not work currently. So the following two queries will fail to parse:\n\n``` sql\nSELECT a[MyNamespace.Father].Name FROM Person a WHERE a.Name = 'Alice';\nSELECT a[MyNamespace.Father].Name FROM Person a WHERE a.Name = 'Alice';\n```\n\nand\n\n``` sql\nSELECT a[MyNamespace.Father].Name FROM Person a WHERE a.Name = 'Alice';\n```\n"},"comment":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/comments/266992440","html_url":"https://github.com/Starcounter/Starcounter/issues/2319#issuecomment-266992440","issue_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/2319","id":266992440,"user":{"login":"k-rus","id":1726044,"avatar_url":"https://avatars.githubusercontent.com/u/1726044?v=3","gravatar_id":"","url":"https://api.github.com/users/k-rus","html_url":"https://github.com/k-rus","followers_url":"https://api.github.com/users/k-rus/followers","following_url":"https://api.github.com/users/k-rus/following{/other_user}","gists_url":"https://api.github.com/users/k-rus/gists{/gist_id}","starred_url":"https://api.github.com/users/k-rus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k-rus/subscriptions","organizations_url":"https://api.github.com/users/k-rus/orgs","repos_url":"https://api.github.com/users/k-rus/repos","events_url":"https://api.github.com/users/k-rus/events{/privacy}","received_events_url":"https://api.github.com/users/k-rus/received_events","type":"User","site_admin":false},"created_at":"2016-12-14T09:58:13Z","updated_at":"2016-12-14T09:58:13Z","body":"The implementation of rules is not simple/natural enough. Separate issue created: https://git.starcounter.org/BlueStar/level0/issues/164\r\n\r\nThe result will be published here."}}
{"actor":{"display_login":"k-rus"}}