Inconsistencies in some `server_status` columns data format
Most of the inconsistencies involve columns that should contain an array of strings:
-
verified_hostname
,unverified_host_names
should contain an array of strings but some rows contain"null"
, we should make those valuesNULL
or[]
. -
diff_or_addresses
should contain an array of strings but some rows containNULL
,[]
and empty strings, we should standardize the column so that it's easier to parse. -
unreachable_or_address
should contain an array of strings but a lot of rows contain an empty string, we should make those empty stringNULL
or[]
. -
effective_family
,declared_family
should contain an array of strings but some rows contain a single effective family value, we should standardize that column so that it's easier to parse (i.e1111111111111111111111111111111111111111
should be["1111111111111111111111111111111111111111"]
).