* fix(schema): avoid sweeping dirty data during migrations * fix: guard schema migration dirty commits (bd-wisp-g6c0g) * fix(storage): preserve mixed issue and wisp reads * fix(schema): unstage old tables before migrations * test(dolt): add generated column cascade repro * Repair PR 3991 rebase against current storage schema
22 lines
859 B
Go
22 lines
859 B
Go
package doctor
|
|
|
|
// Keep in sync with issueops.DepTargetExpr.
|
|
const doctorDependencyTargetExpr = "COALESCE(depends_on_issue_id, depends_on_wisp_id, depends_on_external)"
|
|
|
|
func doctorDependencyUnionSQL() string {
|
|
return `
|
|
SELECT 'dependencies' AS dep_table, issue_id, ` + doctorDependencyTargetExpr + ` AS depends_on_id, type
|
|
FROM dependencies
|
|
UNION ALL
|
|
SELECT 'wisp_dependencies' AS dep_table, issue_id, ` + doctorDependencyTargetExpr + ` AS depends_on_id, type
|
|
FROM wisp_dependencies`
|
|
}
|
|
|
|
func doctorDependencyUnionWithThreadSQL() string {
|
|
return `
|
|
SELECT 'dependencies' AS dep_table, issue_id, ` + doctorDependencyTargetExpr + ` AS depends_on_id, type, thread_id
|
|
FROM dependencies
|
|
UNION ALL
|
|
SELECT 'wisp_dependencies' AS dep_table, issue_id, ` + doctorDependencyTargetExpr + ` AS depends_on_id, type, thread_id
|
|
FROM wisp_dependencies`
|
|
}
|