{"action":"created","issue":{"url":"https://api.github.com/repos/tomatophantastico/sparqlmap/issues/14","repository_url":"https://api.github.com/repos/tomatophantastico/sparqlmap","labels_url":"https://api.github.com/repos/tomatophantastico/sparqlmap/issues/14/labels{/name}","comments_url":"https://api.github.com/repos/tomatophantastico/sparqlmap/issues/14/comments","events_url":"https://api.github.com/repos/tomatophantastico/sparqlmap/issues/14/events","html_url":"https://github.com/tomatophantastico/sparqlmap/issues/14","id":219011850,"number":14,"title":"Issue using views","user":{"login":"digamarx","id":4638593,"avatar_url":"https://avatars2.githubusercontent.com/u/4638593?v=3","gravatar_id":"","url":"https://api.github.com/users/digamarx","html_url":"https://github.com/digamarx","followers_url":"https://api.github.com/users/digamarx/followers","following_url":"https://api.github.com/users/digamarx/following{/other_user}","gists_url":"https://api.github.com/users/digamarx/gists{/gist_id}","starred_url":"https://api.github.com/users/digamarx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/digamarx/subscriptions","organizations_url":"https://api.github.com/users/digamarx/orgs","repos_url":"https://api.github.com/users/digamarx/repos","events_url":"https://api.github.com/users/digamarx/events{/privacy}","received_events_url":"https://api.github.com/users/digamarx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-03T17:52:38Z","updated_at":"2017-04-04T09:11:11Z","closed_at":null,"body":"An error is being generated when using views:\r\n\r\n19:43:18,961 [pool-3-thread-1] ERROR  MetaModelSelectiveDump : Error executing:\r\nSELECT subquery.\"parent\", subquery.\"id\" FROM (select id, parent from (select id,\r\n parent from (Select id, Mid(vater, 4, len(vater)) as parent from BioTabelle1) U\r\nNION (Select id, Mid(mutter,4,len(mutter)) as parent from BioTabelle1)) where pa\r\nrent is not null) subquery\r\n\r\nIt seems that the query is been executed with quotation marks.\r\nI tried to execute the query in the DB console with the quotation, and it also generates an error:\r\n\r\n**SELECT subquery.\"parent\", subquery.\"id\" ...**\r\n\r\nThe query without quotation executed successfully:\r\n\r\n**SELECT subquery.parent, subquery.id**"},"comment":{"url":"https://api.github.com/repos/tomatophantastico/sparqlmap/issues/comments/291440441","html_url":"https://github.com/tomatophantastico/sparqlmap/issues/14#issuecomment-291440441","issue_url":"https://api.github.com/repos/tomatophantastico/sparqlmap/issues/14","id":291440441,"user":{"login":"tomatophantastico","id":1636462,"avatar_url":"https://avatars3.githubusercontent.com/u/1636462?v=3","gravatar_id":"","url":"https://api.github.com/users/tomatophantastico","html_url":"https://github.com/tomatophantastico","followers_url":"https://api.github.com/users/tomatophantastico/followers","following_url":"https://api.github.com/users/tomatophantastico/following{/other_user}","gists_url":"https://api.github.com/users/tomatophantastico/gists{/gist_id}","starred_url":"https://api.github.com/users/tomatophantastico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomatophantastico/subscriptions","organizations_url":"https://api.github.com/users/tomatophantastico/orgs","repos_url":"https://api.github.com/users/tomatophantastico/repos","events_url":"https://api.github.com/users/tomatophantastico/events{/privacy}","received_events_url":"https://api.github.com/users/tomatophantastico/received_events","type":"User","site_admin":false},"created_at":"2017-04-04T09:11:11Z","updated_at":"2017-04-04T09:11:11Z","body":"There might be some internal conversion of the query in the underlying database going on, can you try to quote the projected columns in your subquery/view?"}}
{"actor":{"display_login":"tomatophantastico"}}