ad_bugs和ad_applied_patches的区别

转一段网友回复：

Hi there,

It is just a quick idea. I have suspicious that ad_applied_patches
contains information about patches that you applied on the system,
ad_bugs has information about all bugs and patches that have been
included in the patches you applied.

For example you apply merged patch merge123 it contains 5 patches
10001 10002 10003 …
ad_applied_patches – will have one record about merge123
ad_bugs – 5 records

Another example: you apply maintenance patch which includes 51 other
patches. In that case
ad_applied_patches – will have one record about maintenance patch
ad_bugs – 51 + 1

I hope my thought is clear for you.

PS Anyway I use ad_bugs table in order to find out do I have one or
another patch to apply.

Jurijs

—————————–

select count(bug_number) from apps.ad_bugs; bug_number 对应 patch号

ad_applied_patches是你自己adpatch打的那些（包括merge），但是安装的时候已经包含的patch,这个表不会记录，

所以如果要查询某个patch是否已经applied，还是ad_bugs。