{"action":"created","issue":{"url":"https://api.github.com/repos/links-lang/links/issues/27","repository_url":"https://api.github.com/repos/links-lang/links","labels_url":"https://api.github.com/repos/links-lang/links/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/links-lang/links/issues/27/comments","events_url":"https://api.github.com/repos/links-lang/links/issues/27/events","html_url":"https://github.com/links-lang/links/issues/27","id":143950512,"number":27,"title":"Table column names with underscores","user":{"login":"fehrenbach","id":203168,"avatar_url":"https://avatars.githubusercontent.com/u/203168?v=3","gravatar_id":"","url":"https://api.github.com/users/fehrenbach","html_url":"https://github.com/fehrenbach","followers_url":"https://api.github.com/users/fehrenbach/followers","following_url":"https://api.github.com/users/fehrenbach/following{/other_user}","gists_url":"https://api.github.com/users/fehrenbach/gists{/gist_id}","starred_url":"https://api.github.com/users/fehrenbach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fehrenbach/subscriptions","organizations_url":"https://api.github.com/users/fehrenbach/orgs","repos_url":"https://api.github.com/users/fehrenbach/repos","events_url":"https://api.github.com/users/fehrenbach/events{/privacy}","received_events_url":"https://api.github.com/users/fehrenbach/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/links-lang/links/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"fehrenbach","id":203168,"avatar_url":"https://avatars.githubusercontent.com/u/203168?v=3","gravatar_id":"","url":"https://api.github.com/users/fehrenbach","html_url":"https://github.com/fehrenbach","followers_url":"https://api.github.com/users/fehrenbach/followers","following_url":"https://api.github.com/users/fehrenbach/following{/other_user}","gists_url":"https://api.github.com/users/fehrenbach/gists{/gist_id}","starred_url":"https://api.github.com/users/fehrenbach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fehrenbach/subscriptions","organizations_url":"https://api.github.com/users/fehrenbach/orgs","repos_url":"https://api.github.com/users/fehrenbach/repos","events_url":"https://api.github.com/users/fehrenbach/events{/privacy}","received_events_url":"https://api.github.com/users/fehrenbach/received_events","type":"User","site_admin":false},"assignees":[{"login":"fehrenbach","id":203168,"avatar_url":"https://avatars.githubusercontent.com/u/203168?v=3","gravatar_id":"","url":"https://api.github.com/users/fehrenbach","html_url":"https://github.com/fehrenbach","followers_url":"https://api.github.com/users/fehrenbach/followers","following_url":"https://api.github.com/users/fehrenbach/following{/other_user}","gists_url":"https://api.github.com/users/fehrenbach/gists{/gist_id}","starred_url":"https://api.github.com/users/fehrenbach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fehrenbach/subscriptions","organizations_url":"https://api.github.com/users/fehrenbach/orgs","repos_url":"https://api.github.com/users/fehrenbach/repos","events_url":"https://api.github.com/users/fehrenbach/events{/privacy}","received_events_url":"https://api.github.com/users/fehrenbach/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/links-lang/links/milestones/1","html_url":"https://github.com/links-lang/links/milestones/Gorgie","labels_url":"https://api.github.com/repos/links-lang/links/milestones/1/labels","id":1916143,"number":1,"title":"Gorgie","description":"","creator":{"login":"jgbm","id":1005589,"avatar_url":"https://avatars.githubusercontent.com/u/1005589?v=3","gravatar_id":"","url":"https://api.github.com/users/jgbm","html_url":"https://github.com/jgbm","followers_url":"https://api.github.com/users/jgbm/followers","following_url":"https://api.github.com/users/jgbm/following{/other_user}","gists_url":"https://api.github.com/users/jgbm/gists{/gist_id}","starred_url":"https://api.github.com/users/jgbm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jgbm/subscriptions","organizations_url":"https://api.github.com/users/jgbm/orgs","repos_url":"https://api.github.com/users/jgbm/repos","events_url":"https://api.github.com/users/jgbm/events{/privacy}","received_events_url":"https://api.github.com/users/jgbm/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":1,"state":"open","created_at":"2016-08-01T16:08:06Z","updated_at":"2016-09-15T14:27:15Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2016-03-28T10:56:56Z","updated_at":"2016-09-16T10:06:38Z","closed_at":null,"body":"(in the shredding branch)\r\n\r\nUnderscores have special meaning in shredding/nested-records queries. Links gets confused when columns have underscores in their names.\r\n\r\n```\r\nvar agencies =\r\n  table \"agencies\"\r\n  with (oid: Int,\r\n        id: Int,\r\n        name: String,\r\n        based_in: String,\r\n        phone: String)\r\n  where oid readonly\r\n  tablekeys [[\"oid\"], [\"id\"]]\r\n  from db;\r\n```\r\n\r\nGenerated query:\r\n```sql\r\nselect (0) as \"1_1\",(t1778.\"2\") as \"1_2\",(t1776.\"based_in\") as \"2_a_data_based_in\",(t1776.\"id\") as \"2_a_data_id\",(t1776.\"name\") as \"2_a_data_name\",(t1776.\"oid\") as \"2_a_data_oid\",(t1776.\"phone\") as \"2_a_data_phone\",(t1776.\"oid\") as \"2_a_prov_row\",('agencies') as \"2_a_prov_table\" from (select (1) as \"2\") as t1778,agencies as t1776\r\n```\r\n\r\n> *** Fatal error : Internal error: NotFound \"based\" (in Map.find) while interpreting."},"comment":{"url":"https://api.github.com/repos/links-lang/links/issues/comments/247564681","html_url":"https://github.com/links-lang/links/issues/27#issuecomment-247564681","issue_url":"https://api.github.com/repos/links-lang/links/issues/27","id":247564681,"user":{"login":"jamescheney","id":2305781,"avatar_url":"https://avatars.githubusercontent.com/u/2305781?v=3","gravatar_id":"","url":"https://api.github.com/users/jamescheney","html_url":"https://github.com/jamescheney","followers_url":"https://api.github.com/users/jamescheney/followers","following_url":"https://api.github.com/users/jamescheney/following{/other_user}","gists_url":"https://api.github.com/users/jamescheney/gists{/gist_id}","starred_url":"https://api.github.com/users/jamescheney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamescheney/subscriptions","organizations_url":"https://api.github.com/users/jamescheney/orgs","repos_url":"https://api.github.com/users/jamescheney/repos","events_url":"https://api.github.com/users/jamescheney/events{/privacy}","received_events_url":"https://api.github.com/users/jamescheney/received_events","type":"User","site_admin":false},"created_at":"2016-09-16T10:06:38Z","updated_at":"2016-09-16T10:06:38Z","body":"Assigned to Stefan to look at this as per Sept. 2 meeting."}}
{"actor":{"display_login":"jamescheney"}}