Adds `path` to catalog_resource_components
What does this MR do and why?
down
ci: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 65209
ci: == 20231024173744 AddPathToCatalogResourceComponents: reverting ===============
ci: -- remove_column(:catalog_resource_components, :path, :text)
ci: -> 0.0014s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- transaction_open?(nil)
ci: -> 0.0000s
ci: -- execute(" ALTER TABLE catalog_resource_components\n DROP CONSTRAINT IF EXISTS check_a76bfd47fe\n")
ci: -> 0.0003s
ci: == 20231024173744 AddPathToCatalogResourceComponents: reverted (0.0185s) ======
ci: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 65209
up
main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 66353
main: == 20231024173744 AddPathToCatalogResourceComponents: migrating ===============
main: -- add_column(:catalog_resource_components, :path, :text)
main: -> 0.0029s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- transaction_open?(nil)
main: -> 0.0000s
main: -- execute("ALTER TABLE catalog_resource_components\nADD CONSTRAINT check_a76bfd47fe\nCHECK ( char_length(path) <= 255 )\nNOT VALID;\n")
main: -> 0.0016s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0002s
main: -- execute("ALTER TABLE catalog_resource_components VALIDATE CONSTRAINT check_a76bfd47fe;")
main: -> 0.0014s
main: -- execute("RESET statement_timeout")
main: -> 0.0002s
main: == 20231024173744 AddPathToCatalogResourceComponents: migrated (0.0982s) ======
main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 66353
Resolves: #429256 (closed)
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Laura Montemayor