{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/5886","repository_url":"https://api.github.com/repos/apache/incubator-superset","labels_url":"https://api.github.com/repos/apache/incubator-superset/issues/5886/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-superset/issues/5886/comments","events_url":"https://api.github.com/repos/apache/incubator-superset/issues/5886/events","html_url":"https://github.com/apache/incubator-superset/issues/5886","id":359918772,"node_id":"MDU6SXNzdWUzNTk5MTg3NzI=","number":5886,"title":"Superset ignore case-sensitivity of time column names with Postgresql","user":{"login":"victornoel","id":160975,"node_id":"MDQ6VXNlcjE2MDk3NQ==","avatar_url":"https://avatars0.githubusercontent.com/u/160975?v=4","gravatar_id":"","url":"https://api.github.com/users/victornoel","html_url":"https://github.com/victornoel","followers_url":"https://api.github.com/users/victornoel/followers","following_url":"https://api.github.com/users/victornoel/following{/other_user}","gists_url":"https://api.github.com/users/victornoel/gists{/gist_id}","starred_url":"https://api.github.com/users/victornoel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/victornoel/subscriptions","organizations_url":"https://api.github.com/users/victornoel/orgs","repos_url":"https://api.github.com/users/victornoel/repos","events_url":"https://api.github.com/users/victornoel/events{/privacy}","received_events_url":"https://api.github.com/users/victornoel/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2018-09-13T14:22:38Z","updated_at":"2018-09-23T10:57:34Z","closed_at":null,"author_association":"NONE","body":"Make sure these boxes are checked before submitting your issue - thank you!\r\n\r\n- [x] I have checked the superset logs for python stacktraces and included it here as text if any\r\n- [x] I have reproduced the issue with at least the latest released version of superset\r\n- [x] I have checked the issue tracker for the same issue and I haven't found one similar\r\n - A closed issue seems to be related: #2588 but was closed because inactivity.\r\n\r\n### Superset version\r\n\r\nCurrent master: 85692612d6f1438d8b19f51aefae92a240bc3cf3\r\n\r\n### Expected results\r\n\r\nA table with column name where case is important (for example `invoiceDate`) should be usable without any problem.\r\n\r\n### Actual results\r\n\r\nWhen creating a chart with such a table, I get the following error:\r\n```\r\ncolumn \"invoicedate\" does not exist LINE 1: SELECT DATE_TRUNC('day', invoiceDate) AT TIME ZONE 'UTC' AS ... ^ HINT: Perhaps you meant to reference the column \"InvoiceLine.invoiceDate\".\r\n```\r\n\r\nIt seems to happens because of the `Time Column` case sensitivity in combination with a `Time Grain` (here `day`).\r\n\r\n### Steps to reproduce\r\n\r\nImport a table with case-sensitive names."},"comment":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/comments/423808073","html_url":"https://github.com/apache/incubator-superset/issues/5886#issuecomment-423808073","issue_url":"https://api.github.com/repos/apache/incubator-superset/issues/5886","id":423808073,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMzgwODA3Mw==","user":{"login":"victornoel","id":160975,"node_id":"MDQ6VXNlcjE2MDk3NQ==","avatar_url":"https://avatars0.githubusercontent.com/u/160975?v=4","gravatar_id":"","url":"https://api.github.com/users/victornoel","html_url":"https://github.com/victornoel","followers_url":"https://api.github.com/users/victornoel/followers","following_url":"https://api.github.com/users/victornoel/following{/other_user}","gists_url":"https://api.github.com/users/victornoel/gists{/gist_id}","starred_url":"https://api.github.com/users/victornoel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/victornoel/subscriptions","organizations_url":"https://api.github.com/users/victornoel/orgs","repos_url":"https://api.github.com/users/victornoel/repos","events_url":"https://api.github.com/users/victornoel/events{/privacy}","received_events_url":"https://api.github.com/users/victornoel/received_events","type":"User","site_admin":false},"created_at":"2018-09-23T10:57:34Z","updated_at":"2018-09-23T10:57:34Z","author_association":"NONE","body":"@villebro thanks for the explanation :)\r\nSo I will let you decide what is the best answer to this bug then!"}}
{"actor":{"display_login":"victornoel"}}