{"action":"opened","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/8510","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/8510/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/8510/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/8510/events","html_url":"https://github.com/metabase/metabase/issues/8510","id":359581012,"node_id":"MDU6SXNzdWUzNTk1ODEwMTI=","number":8510,"title":"Self-referencing columns broken on Oracle and Redshift","user":{"login":"senior","id":215910,"node_id":"MDQ6VXNlcjIxNTkxMA==","avatar_url":"https://avatars3.githubusercontent.com/u/215910?v=4","gravatar_id":"","url":"https://api.github.com/users/senior","html_url":"https://github.com/senior","followers_url":"https://api.github.com/users/senior/followers","following_url":"https://api.github.com/users/senior/following{/other_user}","gists_url":"https://api.github.com/users/senior/gists{/gist_id}","starred_url":"https://api.github.com/users/senior/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/senior/subscriptions","organizations_url":"https://api.github.com/users/senior/orgs","repos_url":"https://api.github.com/users/senior/repos","events_url":"https://api.github.com/users/senior/events{/privacy}","received_events_url":"https://api.github.com/users/senior/received_events","type":"User","site_admin":false},"labels":[{"id":172924550,"node_id":"MDU6TGFiZWwxNzI5MjQ1NTA=","url":"https://api.github.com/repos/metabase/metabase/labels/Bug","name":"Bug","color":"CC333F","default":false},{"id":429236460,"node_id":"MDU6TGFiZWw0MjkyMzY0NjA=","url":"https://api.github.com/repos/metabase/metabase/labels/Database/Oracle","name":"Database/Oracle","color":"402E78","default":false},{"id":300015740,"node_id":"MDU6TGFiZWwzMDAwMTU3NDA=","url":"https://api.github.com/repos/metabase/metabase/labels/Database/Redshift","name":"Database/Redshift","color":"402E78","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-09-12T17:32:00Z","updated_at":"2018-09-12T17:32:00Z","closed_at":null,"author_association":"MEMBER","body":"While putting together a test to reproduce https://github.com/metabase/metabase/issues/8371 I found that Metabase doesn't currently allow self-referencing columns with Oracle and Redshift. For Oracle at least, it might be due to my usage of a limit clause. When we have a limit with Oracle, we wrap the query with another query that includes the `rownum` limit.\r\n\r\nFor now I have disabled running the tests on those two backends (will include a link to the code once it's up) as it was broken before `0.30.1` which was referenced in https://github.com/metabase/metabase/issues/8371"}}
{"actor":{"display_login":"senior"}}