{"action":"created","issue":{"url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7214","repository_url":"https://api.github.com/repos/jOOQ/jOOQ","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7214/labels{/name}","comments_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7214/comments","events_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7214/events","html_url":"https://github.com/jOOQ/jOOQ/issues/7214","id":299333775,"number":7214,"title":"MySQL 5.7.21, jOOQ 3.10.5, routines are not generating","user":{"login":"aram535","id":3215912,"avatar_url":"https://avatars2.githubusercontent.com/u/3215912?v=4","gravatar_id":"","url":"https://api.github.com/users/aram535","html_url":"https://github.com/aram535","followers_url":"https://api.github.com/users/aram535/followers","following_url":"https://api.github.com/users/aram535/following{/other_user}","gists_url":"https://api.github.com/users/aram535/gists{/gist_id}","starred_url":"https://api.github.com/users/aram535/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aram535/subscriptions","organizations_url":"https://api.github.com/users/aram535/orgs","repos_url":"https://api.github.com/users/aram535/repos","events_url":"https://api.github.com/users/aram535/events{/privacy}","received_events_url":"https://api.github.com/users/aram535/received_events","type":"User","site_admin":false},"labels":[{"id":9935134,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/C:%20Code%20Generation","name":"C: Code Generation","color":"0000aa","default":false},{"id":9935137,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/C:%20DB:%20MySQL","name":"C: DB: MySQL","color":"0000aa","default":false},{"id":9935166,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/P:%20Medium","name":"P: Medium","color":"ffaaaa","default":false},{"id":9935130,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/T:%20Defect","name":"T: Defect","color":"cccccc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/140","html_url":"https://github.com/jOOQ/jOOQ/milestone/140","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/140/labels","id":2289955,"number":140,"title":"Version 3.11.0","description":"","creator":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars2.githubusercontent.com/u/734593?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"open_issues":625,"closed_issues":365,"state":"open","created_at":"2017-01-31T16:47:44Z","updated_at":"2018-02-27T16:19:45Z","due_on":null,"closed_at":null},"comments":9,"created_at":"2018-02-22T12:24:51Z","updated_at":"2018-02-27T16:53:27Z","closed_at":null,"author_association":"NONE","body":"### Expected behavior and actual behavior:\r\n\r\nRoutines should be available after code generation\r\n\r\n### Steps to reproduce the problem:\r\n\r\nHave a small project that I can share with you. However, this is enough to see the issue\r\n\r\n```\r\nCREATE SCHEMA TESTDB;\r\nCREATE PROCEDURE `TESTDB`.`foo` .... \r\nSELECT DISTINCT db from `mysql`.`proc`;\r\n\r\n```\r\n\r\n### Versions:\r\n\r\n- jOOQ: 3.10.5\r\n- Java: Oracle 1.8.0_161_b12\r\n- Database (include vendor): MySQL 5.7.21\r\n- JDBC Driver (include name if inofficial driver): 6.0.6\r\n\r\nMySQL's fault on this one... the proc names are being stored as lowercase no matter what the name of the database is. \r\n\r\nWorkaround -- remove the inputSchema and generate all schemas and the routines are generated OR exclude rather than include schemas."},"comment":{"url":"https://api.github.com/repos/jOOQ/jOOQ/issues/comments/368946766","html_url":"https://github.com/jOOQ/jOOQ/issues/7214#issuecomment-368946766","issue_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7214","id":368946766,"user":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars2.githubusercontent.com/u/734593?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"created_at":"2018-02-27T16:53:27Z","updated_at":"2018-02-27T16:53:27Z","author_association":"OWNER","body":"I see, thanks for the clarification. Yes, that docker command would be really great, thanks for offering it!"}}
{"actor":{"display_login":"lukaseder"}}