{"action":"created","issue":{"url":"https://api.github.com/repos/mcafee/mysql-audit/issues/114","labels_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/114/labels{/name}","comments_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/114/comments","events_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/114/events","html_url":"https://github.com/mcafee/mysql-audit/issues/114","id":89039131,"number":114,"title":"Feature Request: Setting to Remove Derived Asterisk","user":{"login":"utdrmac","id":4413670,"avatar_url":"https://avatars.githubusercontent.com/u/4413670?v=3","gravatar_id":"","url":"https://api.github.com/users/utdrmac","html_url":"https://github.com/utdrmac","followers_url":"https://api.github.com/users/utdrmac/followers","following_url":"https://api.github.com/users/utdrmac/following{/other_user}","gists_url":"https://api.github.com/users/utdrmac/gists{/gist_id}","starred_url":"https://api.github.com/users/utdrmac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utdrmac/subscriptions","organizations_url":"https://api.github.com/users/utdrmac/orgs","repos_url":"https://api.github.com/users/utdrmac/repos","events_url":"https://api.github.com/users/utdrmac/events{/privacy}","received_events_url":"https://api.github.com/users/utdrmac/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-06-17T14:52:54Z","updated_at":"2015-06-17T16:16:26Z","closed_at":null,"body":"If a query is executed with a table that is derived, an * is recorded in the audit event. As this isn't too helpful in a real audit, FR for a setting to ignore/don't-log these.\r\n\r\n```\r\n{\r\n\t\"db\" : \"\",\r\n\t\"name\" : \"*\",\r\n\t\"obj_type\" : \"TABLE\"\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/mcafee/mysql-audit/issues/comments/112865083","html_url":"https://github.com/mcafee/mysql-audit/issues/114#issuecomment-112865083","issue_url":"https://api.github.com/repos/mcafee/mysql-audit/issues/114","id":112865083,"user":{"login":"utdrmac","id":4413670,"avatar_url":"https://avatars.githubusercontent.com/u/4413670?v=3","gravatar_id":"","url":"https://api.github.com/users/utdrmac","html_url":"https://github.com/utdrmac","followers_url":"https://api.github.com/users/utdrmac/followers","following_url":"https://api.github.com/users/utdrmac/following{/other_user}","gists_url":"https://api.github.com/users/utdrmac/gists{/gist_id}","starred_url":"https://api.github.com/users/utdrmac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/utdrmac/subscriptions","organizations_url":"https://api.github.com/users/utdrmac/orgs","repos_url":"https://api.github.com/users/utdrmac/repos","events_url":"https://api.github.com/users/utdrmac/events{/privacy}","received_events_url":"https://api.github.com/users/utdrmac/received_events","type":"User","site_admin":false},"created_at":"2015-06-17T16:16:26Z","updated_at":"2015-06-17T16:16:26Z","body":"SELECT * FROM (SELECT * FROM foo) a;\r\n\r\n```\r\n{\"msg-type\":\"activity\",\"date\":\"1434557705062\",\"thread-id\":\"16728373\",\"query-id\":\"446961855\",\"user\":\"percona\",\"priv_user\":\"percona\",\"host\":\"localhost\",\"cmd\":\"select\",\"objects\":[{\"db\":\"\",\"name\":\"*\",\"obj_type\":\"TABLE\"},{\"db\":\"percona\",\"name\":\"foo\",\"obj_type\":\"TABLE\"}],\"query\":\"SELECT * FROM (SELECT * FROM foo) a\"}\r\n```"}}