{"action":"opened","issue":{"url":"https://api.github.com/repos/EnterpriseDB/mysql_fdw/issues/109","repository_url":"https://api.github.com/repos/EnterpriseDB/mysql_fdw","labels_url":"https://api.github.com/repos/EnterpriseDB/mysql_fdw/issues/109/labels{/name}","comments_url":"https://api.github.com/repos/EnterpriseDB/mysql_fdw/issues/109/comments","events_url":"https://api.github.com/repos/EnterpriseDB/mysql_fdw/issues/109/events","html_url":"https://github.com/EnterpriseDB/mysql_fdw/issues/109","id":157939061,"number":109,"title":"mysql syntax error when using inline tables","user":{"login":"pulitta","id":6448656,"avatar_url":"https://avatars.githubusercontent.com/u/6448656?v=3","gravatar_id":"","url":"https://api.github.com/users/pulitta","html_url":"https://github.com/pulitta","followers_url":"https://api.github.com/users/pulitta/followers","following_url":"https://api.github.com/users/pulitta/following{/other_user}","gists_url":"https://api.github.com/users/pulitta/gists{/gist_id}","starred_url":"https://api.github.com/users/pulitta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pulitta/subscriptions","organizations_url":"https://api.github.com/users/pulitta/orgs","repos_url":"https://api.github.com/users/pulitta/repos","events_url":"https://api.github.com/users/pulitta/events{/privacy}","received_events_url":"https://api.github.com/users/pulitta/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-06-01T15:37:37Z","updated_at":"2016-06-01T15:37:37Z","closed_at":null,"body":"Hi! Can I use inline tables in requests? Now I get an error.\r\n\r\nRequest:\r\n`select \"payment_types\".\"id\" as \"c0\", count(\"transaction\".\"id\") as \"m0\", sum(\"transaction\".\"amount\") as \"m1\" from (SELECT * FROM (VALUES ('free'), ('unpaid'), ('bank_card'), ('cash'), ('debenture')) AS \"t\" (\"id\")) as \"payment_types\", \"transaction\" as \"transaction\" where \"transaction\".\"payment_type\" = \"payment_types\".\"id\" and \"payment_types\".\"id\" = 'bank_card' group by \"payment_types\".\"id\";`\r\n\r\nResponse:\r\nERROR:  failed to prepare the MySQL query: \r\nYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(`payment_type`) = 'bank_card'))' at line 1"}}
{"actor":{"display_login":"pulitta"}}