{"action":"created","issue":{"url":"https://api.github.com/repos/mozafari/verdictdb/issues/314","repository_url":"https://api.github.com/repos/mozafari/verdictdb","labels_url":"https://api.github.com/repos/mozafari/verdictdb/issues/314/labels{/name}","comments_url":"https://api.github.com/repos/mozafari/verdictdb/issues/314/comments","events_url":"https://api.github.com/repos/mozafari/verdictdb/issues/314/events","html_url":"https://github.com/mozafari/verdictdb/pull/314","id":383951022,"node_id":"MDExOlB1bGxSZXF1ZXN0MjMzMjk1ODA0","number":314,"title":"Joezhong fix 312","user":{"login":"Beastjoe","id":20832758,"node_id":"MDQ6VXNlcjIwODMyNzU4","avatar_url":"https://avatars3.githubusercontent.com/u/20832758?v=4","gravatar_id":"","url":"https://api.github.com/users/Beastjoe","html_url":"https://github.com/Beastjoe","followers_url":"https://api.github.com/users/Beastjoe/followers","following_url":"https://api.github.com/users/Beastjoe/following{/other_user}","gists_url":"https://api.github.com/users/Beastjoe/gists{/gist_id}","starred_url":"https://api.github.com/users/Beastjoe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Beastjoe/subscriptions","organizations_url":"https://api.github.com/users/Beastjoe/orgs","repos_url":"https://api.github.com/users/Beastjoe/repos","events_url":"https://api.github.com/users/Beastjoe/events{/privacy}","received_events_url":"https://api.github.com/users/Beastjoe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-11-24T02:05:07Z","updated_at":"2018-11-24T02:34:14Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/mozafari/verdictdb/pulls/314","html_url":"https://github.com/mozafari/verdictdb/pull/314","diff_url":"https://github.com/mozafari/verdictdb/pull/314.diff","patch_url":"https://github.com/mozafari/verdictdb/pull/314.patch"},"body":"Related issue #312 \r\n\r\nAdd a field \"primarykeyColumnName\" when creating scramble tables. If scramble tables have primary keys, it will use this field to add primary key."},"comment":{"url":"https://api.github.com/repos/mozafari/verdictdb/issues/comments/441338500","html_url":"https://github.com/mozafari/verdictdb/pull/314#issuecomment-441338500","issue_url":"https://api.github.com/repos/mozafari/verdictdb/issues/314","id":441338500,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTMzODUwMA==","user":{"login":"pyongjoo","id":1316874,"node_id":"MDQ6VXNlcjEzMTY4NzQ=","avatar_url":"https://avatars3.githubusercontent.com/u/1316874?v=4","gravatar_id":"","url":"https://api.github.com/users/pyongjoo","html_url":"https://github.com/pyongjoo","followers_url":"https://api.github.com/users/pyongjoo/followers","following_url":"https://api.github.com/users/pyongjoo/following{/other_user}","gists_url":"https://api.github.com/users/pyongjoo/gists{/gist_id}","starred_url":"https://api.github.com/users/pyongjoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pyongjoo/subscriptions","organizations_url":"https://api.github.com/users/pyongjoo/orgs","repos_url":"https://api.github.com/users/pyongjoo/repos","events_url":"https://api.github.com/users/pyongjoo/events{/privacy}","received_events_url":"https://api.github.com/users/pyongjoo/received_events","type":"User","site_admin":false},"created_at":"2018-11-24T02:34:14Z","updated_at":"2018-11-24T02:34:14Z","author_association":"CONTRIBUTOR","body":"Can you double-check the relationship between the partitoning key and the primary key? I just found the following query on [mysql's website](https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html):\r\n\r\n```sql\r\nCREATE TABLE t5 (\r\n    col1 INT NOT NULL,\r\n    col2 DATE NOT NULL,\r\n    col3 INT NOT NULL,\r\n    col4 INT NOT NULL,\r\n    PRIMARY KEY(col1, col2)\r\n)\r\nPARTITION BY HASH(col3)\r\nPARTITIONS 4;\r\n```\r\n\r\n"}}
{"actor":{"display_login":"pyongjoo"}}