{"action":"created","issue":{"url":"https://api.github.com/repos/acarl005/join-monster/issues/344","repository_url":"https://api.github.com/repos/acarl005/join-monster","labels_url":"https://api.github.com/repos/acarl005/join-monster/issues/344/labels{/name}","comments_url":"https://api.github.com/repos/acarl005/join-monster/issues/344/comments","events_url":"https://api.github.com/repos/acarl005/join-monster/issues/344/events","html_url":"https://github.com/acarl005/join-monster/issues/344","id":356122734,"node_id":"MDU6SXNzdWUzNTYxMjI3MzQ=","number":344,"title":"Ambiguous Table Alias","user":{"login":"ssedrick","id":8585377,"node_id":"MDQ6VXNlcjg1ODUzNzc=","avatar_url":"https://avatars3.githubusercontent.com/u/8585377?v=4","gravatar_id":"","url":"https://api.github.com/users/ssedrick","html_url":"https://github.com/ssedrick","followers_url":"https://api.github.com/users/ssedrick/followers","following_url":"https://api.github.com/users/ssedrick/following{/other_user}","gists_url":"https://api.github.com/users/ssedrick/gists{/gist_id}","starred_url":"https://api.github.com/users/ssedrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ssedrick/subscriptions","organizations_url":"https://api.github.com/users/ssedrick/orgs","repos_url":"https://api.github.com/users/ssedrick/repos","events_url":"https://api.github.com/users/ssedrick/events{/privacy}","received_events_url":"https://api.github.com/users/ssedrick/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-08-31T21:02:09Z","updated_at":"2018-10-30T18:21:05Z","closed_at":null,"author_association":"NONE","body":"Sqlite3 is throwing this error: `Error ambiguous column name: informatio.id`\r\n\r\nI'm dealing with a table \"InformationItem\" and a many-to-many table called \"InformationItemHasGroup\". Join Monster creates the aliases \"informatio\" and \"Informatio\" respectively.\r\nSqlite3 is case INsensitive when it comes to resolving aliases. Thus `informatio` and `Informatio` are equivalent in Sqlite3, causing the error.\r\n\r\nIs there a way around this that I haven't found in the docs?\r\n\r\nAs I see it, there are either two ways of dealing with this. Either changing the alias scheme to not use capitalization as a way of generating a unique alias, or allow an field attribute of `alias` that can be specified by the user."},"comment":{"url":"https://api.github.com/repos/acarl005/join-monster/issues/comments/434414882","html_url":"https://github.com/acarl005/join-monster/issues/344#issuecomment-434414882","issue_url":"https://api.github.com/repos/acarl005/join-monster/issues/344","id":434414882,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNDQxNDg4Mg==","user":{"login":"GlennMatthys","id":31989842,"node_id":"MDQ6VXNlcjMxOTg5ODQy","avatar_url":"https://avatars0.githubusercontent.com/u/31989842?v=4","gravatar_id":"","url":"https://api.github.com/users/GlennMatthys","html_url":"https://github.com/GlennMatthys","followers_url":"https://api.github.com/users/GlennMatthys/followers","following_url":"https://api.github.com/users/GlennMatthys/following{/other_user}","gists_url":"https://api.github.com/users/GlennMatthys/gists{/gist_id}","starred_url":"https://api.github.com/users/GlennMatthys/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GlennMatthys/subscriptions","organizations_url":"https://api.github.com/users/GlennMatthys/orgs","repos_url":"https://api.github.com/users/GlennMatthys/repos","events_url":"https://api.github.com/users/GlennMatthys/events{/privacy}","received_events_url":"https://api.github.com/users/GlennMatthys/received_events","type":"User","site_admin":false},"created_at":"2018-10-30T18:21:04Z","updated_at":"2018-10-30T18:21:04Z","author_association":"COLLABORATOR","body":"Can you submit a database schema and some code that produces this error?"}}
{"actor":{"display_login":"GlennMatthys"}}