[UI] DB engine major version upgrade/downgrade should be disabled
Description
Environment
Attachments
Activity
Tested with Everest v0.0.0-11b6a1d version. The following upgrades are successful
Mysql upgrade from 8.0.25-15.1 to 8.0.36-28.1
Mongodb upgrade from 5.0.11-10 to 5.0.26-22
Mongodb upgrade from 6.0.4-3 to 6.0.15-12
Hence closing this issue.
Tested with Everest v0.0.0-e74de40 version.
Mysql
If the latest version 8.0.36-28.1 is installed, then in edit db, it can’t be downgraded
If 8.0.25-15.1 is installed, then it can be upgraded
If an intermediate version like 8.0.31 is installed, then upgrade is allowed and downgrade is not possible
Mongodb
If 5.0.11-10 is installed, then upgrade is possible within 5.0 versions but not to 6.0 or 7.0 versions
If you upgrade from 5.0.11-10 to 5.0.14-12, then downgrade to 5.0.11-10 is not possible
Similarly if 6.0 version is installed, upgrade to a higher 6.0 version is allowed, but downgrade to a lower version is not allowed. Also changing the version to 5.0 or 7.0 version is not possible.
If 7.0 version is installed, then downgrade to 5.0/6.0 version is not allowed
Postgresql
If 12.17 version is installed then it can’t be upgraded to any other version
If 16.1 is installed, then it can’t be downgraded to any other version
DB engine major version upgrade is not possible for mongodb and postgresql, hence it should not be enabled in database edit. For example if a mongodb is created for 4.4.13-13 version and is upgraded to 5.0.20-17, then it gives this error
So, editing the major version should be disabled here, though minor version upgrade is allowed.
This should be done for both mongodb and postgresql. Major version upgrade in mysql is allowed.
Similarly, downgrade should not be allowed for mysql, mongodb, postgresql.