{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/3506","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/3506/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/3506/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/3506/events","html_url":"https://github.com/metabase/metabase/issues/3506","id":182303273,"number":3506,"title":"MySQL TINYINT(1) columns are always interpreted as booleans","user":{"login":"hugocar","id":19691106,"avatar_url":"https://avatars.githubusercontent.com/u/19691106?v=3","gravatar_id":"","url":"https://api.github.com/users/hugocar","html_url":"https://github.com/hugocar","followers_url":"https://api.github.com/users/hugocar/followers","following_url":"https://api.github.com/users/hugocar/following{/other_user}","gists_url":"https://api.github.com/users/hugocar/gists{/gist_id}","starred_url":"https://api.github.com/users/hugocar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hugocar/subscriptions","organizations_url":"https://api.github.com/users/hugocar/orgs","repos_url":"https://api.github.com/users/hugocar/repos","events_url":"https://api.github.com/users/hugocar/events{/privacy}","received_events_url":"https://api.github.com/users/hugocar/received_events","type":"User","site_admin":false},"labels":[{"id":172924550,"url":"https://api.github.com/repos/metabase/metabase/labels/Bug","name":"Bug","color":"CC333F","default":false},{"id":300015465,"url":"https://api.github.com/repos/metabase/metabase/labels/Database/MySQL","name":"Database/MySQL","color":"782E53","default":false},{"id":316506011,"url":"https://api.github.com/repos/metabase/metabase/labels/Limitation","name":"Limitation","color":"CC333F","default":false},{"id":314265356,"url":"https://api.github.com/repos/metabase/metabase/labels/Metadata/Sync","name":"Metadata/Sync","color":"6899FC","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":24,"created_at":"2016-10-11T15:54:18Z","updated_at":"2016-11-16T01:30:01Z","closed_at":null,"body":"> ### Bugs\n> \n> If you're filing an issue about a bug please include as much information\n> as you can including the following.\n\nOn a table \"user\" there is a colonne \"gender\" \nthe value is 1 for men and 2 for women (I disapprove of this data model but this not the issue here)\n\nMetabase sees it as a boolean : \n\nin results : \n<img width=\"1198\" alt=\"capture d ecran 2016-10-11 a 5 35 10 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/19277397/db5cf382-8fd9-11e6-84a4-06de6be2c1fd.png\">\n\nin filters : \n<img width=\"322\" alt=\"capture d ecran 2016-10-11 a 5 41 30 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/19277437/fd04468e-8fd9-11e6-8044-d41fa226257f.png\">\n\ndespite being provided a data model form the admin panel : \n\n<img width=\"906\" alt=\"capture d ecran 2016-10-11 a 5 42 15 pm\" src=\"https://cloud.githubusercontent.com/assets/19691106/19277466/1483c122-8fda-11e6-945d-817dcc39a9af.png\">\n\n> - Your browser and the version: Firefox up to date\n> - Your operating system: MacOS\n> - Your databases: MySQL\n> - Metabase version: (e.x. 0.19.3)\n> - Metabase hosting environment: Linux Java\n> - Metabase internal database:MySQL\n> - _Repeatable steps to reproduce the issue_\n\nTo reproduce you would need to create a table with a column filled only with 1 and 2 \nCREATE TABLE `user` (\n  `gender` tinyint(1) NOT NULL DEFAULT '1',\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin\"\n\n> ## Thanks for being part of the Metabase project!\n\nThank you guys\n"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/260826133","html_url":"https://github.com/metabase/metabase/issues/3506#issuecomment-260826133","issue_url":"https://api.github.com/repos/metabase/metabase/issues/3506","id":260826133,"user":{"login":"tlrobinson","id":18193,"avatar_url":"https://avatars.githubusercontent.com/u/18193?v=3","gravatar_id":"","url":"https://api.github.com/users/tlrobinson","html_url":"https://github.com/tlrobinson","followers_url":"https://api.github.com/users/tlrobinson/followers","following_url":"https://api.github.com/users/tlrobinson/following{/other_user}","gists_url":"https://api.github.com/users/tlrobinson/gists{/gist_id}","starred_url":"https://api.github.com/users/tlrobinson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tlrobinson/subscriptions","organizations_url":"https://api.github.com/users/tlrobinson/orgs","repos_url":"https://api.github.com/users/tlrobinson/repos","events_url":"https://api.github.com/users/tlrobinson/events{/privacy}","received_events_url":"https://api.github.com/users/tlrobinson/received_events","type":"User","site_admin":false},"created_at":"2016-11-16T01:30:01Z","updated_at":"2016-11-16T01:30:01Z","body":"@camsaul Not if you set `?tinyInt1isBit=false`, right?"}}
{"actor":{"display_login":"tlrobinson"}}