2052126 - Migration 5.0 -> Harmony: BugmailFilter extension expects components.id to be a SMALLSERIAL

Status: NEW

(Bugzilla :: Extensions, defect)

Description

[Dave Miller [:justdave]]

The injected schema code in the BugmailFilter extension expects the columns that reference components.id to be INT2, which is the case in Harmony's schema, but an upgraded schema from Bugzilla 5.0 has an INT3 instead, which causes the install process for the BugmailFilter extension (enabled by default in Harmony) to crash during checksetup.

The ComponentWatching extension actually has code in it to check what type the parent schema is using and use that instead of hard-coding it. BugmailFilter should do the same (and that'll keep it working with older Harmony installs or BMO, too).

So BugmailFilter needs to:

1. Use whatever type components.id currently is on its columns that reference it in the initial schema
2. Detect if that type has changed on an existing install and modify it to continue matching if necessary.

Comment 1

[BMO Github Automation]

Attachment: [bugzilla/harmony] Bug 2052126: BugmailFilter extension: smart handling of compoents.id type (#158)