[Bug] The "issue-author-association" field in the cloud based clickhouse database only has the "COLLABORATOR" type, and querying other types cannot obtain results.

[zhingoll]

Current Behavior

May I ask if the "issue author association" field here represents the relationship between the user who opened the issue and the repository? If so, but I tried to query other relationships and did not get any results.

However, the column "issue-comment-author-association" can reflect the actual situation very well.

Is this a bug or my misunderstanding?

Expected Behavior

If "issue author association" represents the relationship between the user who opened the issue and the repository, then it should be able to reflect the actual relationship between the user who performed the behavior and the current repository, just like the column "issue_comment-author-association".For example, like the following:

Any Additional Comments?

I have been searching for some indicators that can be used to distinguish between peripheral developers (possibly newcomers) and core developers (possibly veterans) for a certain repository recently, so I have this confusion while following Github event information.

[frank-zsy]

Sure, I found that this is a bug in the importer program, I will fix this soon and re-import the GitHub log recently. Thanks for the report.

[frank-zsy]

The re-import process has been started and will finish in about 3 days. The reason that all the value is COLLABORATOR is that this value is the default value for this column, but in the new data, NONE will be the default value instead to avoid ambiguity.

[frank-zsy]

The issue about the data has been fixed and the data now is up-to-date with new format.