-
Gopal Shankar authored
This WL implements I_S.VIEW_TABLE_USAGE and I_S.VIEW_ROUTINE_USAGE. Following functional requirements are implemented: FR1: Implement I_S.VIEW_TABLE_USAGE as a system view over mysql.view_table_usage DD table. This I_S view shows the table names that is used by a view. FR2: Implement I_S.VIEW_ROUTINE_USAGE as a system view over mysql.view_routine_usage DD table. This I_S view shows function names that is used by a view. FR3: FR1 and FR2 would show only views that are permitted to the current user executing I_S query. FR4: FR1 should also show the view names that are directly used by the view. FR5: FR1 and FR2 would show dependent table and function names that are permitted to the current user executing I_S query. FR6: Increase the IS_DD_VERSION number as we are adding new I_S tables. - The native function CAN_ACCESS_VIEW() is changed to avoid printing the same warning repeatedly. This is required because optimizer end-up calling the native function to check view access more times than expected. - Due to the bug#28098779, the metadata of I_S view column nullability changes. Recording the result files until the bug is fixed. These changes would be reverted by above bug fix eventually. New test main.dd_is_view_usage is added. Change-Id: Iffc1d1471bd7be8872a7cd77586c66528df4185f
Gopal Shankar authoredThis WL implements I_S.VIEW_TABLE_USAGE and I_S.VIEW_ROUTINE_USAGE. Following functional requirements are implemented: FR1: Implement I_S.VIEW_TABLE_USAGE as a system view over mysql.view_table_usage DD table. This I_S view shows the table names that is used by a view. FR2: Implement I_S.VIEW_ROUTINE_USAGE as a system view over mysql.view_routine_usage DD table. This I_S view shows function names that is used by a view. FR3: FR1 and FR2 would show only views that are permitted to the current user executing I_S query. FR4: FR1 should also show the view names that are directly used by the view. FR5: FR1 and FR2 would show dependent table and function names that are permitted to the current user executing I_S query. FR6: Increase the IS_DD_VERSION number as we are adding new I_S tables. - The native function CAN_ACCESS_VIEW() is changed to avoid printing the same warning repeatedly. This is required because optimizer end-up calling the native function to check view access more times than expected. - Due to the bug#28098779, the metadata of I_S view column nullability changes. Recording the result files until the bug is fixed. These changes would be reverted by above bug fix eventually. New test main.dd_is_view_usage is added. Change-Id: Iffc1d1471bd7be8872a7cd77586c66528df4185f
Loading