CS 4.22.X - Consistency: Mysql Table network_Offerings shows state always in Enable - cosmetic Bug - Non Operational issue

[tatay188]

problem

I found This when I was trying to build Services:

mysql> select * from network_offerings;
column | state | shows always Enabled, Independently of the column | removed | have a Date or have NULL value

Shouldn't the table state change to Disabled when there is a Removed Date or will this trigger a different problem ?

Important I don't see this affects the Operations, then seems is more of a keeping data consistency on DB.

cc @gopalcp

versions

CS 4.22.X

The steps to reproduce the bug

1. Using the UI Disable a network Offering
2. Go to the DB and check the State and Removed columns for the Offering you just Disabled
3. You will find the State is still mark as enabled, and the removed Date was populated.
   ...

What to do about it?

No response