{"action":"created","issue":{"url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4595","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4595/labels{/name}","comments_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4595/comments","events_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4595/events","html_url":"https://github.com/jOOQ/jOOQ/issues/4595","id":109620576,"number":4595,"title":"forcedType match fails for exact table and column","user":{"login":"axelfontaine","id":684824,"avatar_url":"https://avatars.githubusercontent.com/u/684824?v=3","gravatar_id":"","url":"https://api.github.com/users/axelfontaine","html_url":"https://github.com/axelfontaine","followers_url":"https://api.github.com/users/axelfontaine/followers","following_url":"https://api.github.com/users/axelfontaine/following{/other_user}","gists_url":"https://api.github.com/users/axelfontaine/gists{/gist_id}","starred_url":"https://api.github.com/users/axelfontaine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/axelfontaine/subscriptions","organizations_url":"https://api.github.com/users/axelfontaine/orgs","repos_url":"https://api.github.com/users/axelfontaine/repos","events_url":"https://api.github.com/users/axelfontaine/events{/privacy}","received_events_url":"https://api.github.com/users/axelfontaine/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/C:%20Code%20Generation","name":"C: Code Generation","color":"0000aa"},{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/P:%20Medium","name":"P: Medium","color":"ffaaaa"},{"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/T:%20Defect","name":"T: Defect","color":"cccccc"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/111","html_url":"https://github.com/jOOQ/jOOQ/milestones/Version%203.7.0","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/111/labels","id":900413,"number":111,"title":"Version 3.7.0","description":"","creator":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars.githubusercontent.com/u/734593?v=3","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":42,"closed_issues":231,"state":"open","created_at":"2014-12-11T12:56:14Z","updated_at":"2015-10-03T16:21:37Z","due_on":null,"closed_at":null},"comments":6,"created_at":"2015-10-03T12:22:12Z","updated_at":"2015-10-03T16:40:41Z","closed_at":null,"body":"I have a table `app` that has a column `name` on which I want to force the type using a converter. This should only apply to this exact column.\r\n\r\nI have tried various expressions with no luck: `.*\\.app\\.name` and `app\\.name`\r\n\r\n```\r\n<forcedType>\r\n     <name>AppNameType</name>\r\n     <expression>.*\\.app\\.name</expression>\r\n     <types>text</types>\r\n</forcedType>\r\n```\r\n\r\nWhat am I doing wrong? I couldn't find an example of this type of match in the manual. Sorry if I missed something obvious.\r\n\r\nI am using jOOQ 3.6.4"},"comment":{"url":"https://api.github.com/repos/jOOQ/jOOQ/issues/comments/145263662","html_url":"https://github.com/jOOQ/jOOQ/issues/4595#issuecomment-145263662","issue_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/4595","id":145263662,"user":{"login":"axelfontaine","id":684824,"avatar_url":"https://avatars.githubusercontent.com/u/684824?v=3","gravatar_id":"","url":"https://api.github.com/users/axelfontaine","html_url":"https://github.com/axelfontaine","followers_url":"https://api.github.com/users/axelfontaine/followers","following_url":"https://api.github.com/users/axelfontaine/following{/other_user}","gists_url":"https://api.github.com/users/axelfontaine/gists{/gist_id}","starred_url":"https://api.github.com/users/axelfontaine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/axelfontaine/subscriptions","organizations_url":"https://api.github.com/users/axelfontaine/orgs","repos_url":"https://api.github.com/users/axelfontaine/repos","events_url":"https://api.github.com/users/axelfontaine/events{/privacy}","received_events_url":"https://api.github.com/users/axelfontaine/received_events","type":"User","site_admin":false},"created_at":"2015-10-03T16:40:40Z","updated_at":"2015-10-03T16:40:40Z","body":"For reference here are some more, all working fine:\r\n\r\n```\r\n<forcedType>\r\n     <name>OsType</name>\r\n     <expression>.*\\.os</expression>\r\n     <types>text</types>\r\n</forcedType>\r\n<forcedType>\r\n    <name>Plan</name>\r\n    <expression>.*plan.*</expression>\r\n    <types>text</types>\r\n</forcedType>\r\n<forcedType>\r\n    <name>VersionType</name>\r\n    <expression>.*version(_number)?</expression>\r\n    <types>text</types>\r\n</forcedType>\r\n```"}}