Create regression prevention tests for hardcoding a schema in SQL migrations #12640
Closed as not planned
Description
We recently saw issues where a user could not upgrade Coder when using a custom scheme in the DB.
- migration fails with relation "public.template_versions" does not exist #12619
- DB schema-hardcoding in migration prevents updating to >2.9.0 #12631
To prevent this from happening in the future, we should add tests.
@matifali we should make tests preventing this from happening in the future.
Originally posted by @kylecarbs in #12631 (comment)