We just upgraded our website this weekend from Commerce 9.11, to 11.1.1. After this upgrade, we've had a large increase in CatalogContentProperty rows and we looked into this.
Apparently Epsierver 11.1.1 now inserts blank rows with no values for every single non-translated properties, where as it used to not insert any records for non-translated properties.
Not sure who at Episerver thought it was a good idea to create blank new rows for every single property, on every translation, for every product that was published, but this is going to cause our CatalogContentProperty table of 1.5 million records to quickly bloat to somewhere around 5+ million very rapidly.
Is this a bug? Or is this just terrible design?
I don't recognize that behavior - the non culturespecific properties are always loaded from master language version. If possible, I would suggest you to try to export your catalog, delete it, and reimport again to see how does it behave.
You can of course contact developer support service for further assistance.
Just checked that my DB is fine. I have run this script and got 0 results:
Where Boolean = NULL
AND Number = NULL
AND FloatNumber = NULL
AND Money = NULL
AND Decimal = NULL
AND Date = NULL
AND Binary = NULL
AND String = NULL
AND LongString = NULL
AND Guid = NULL
Hey, Just to clarrify, these aren't null rows, they are blank.
WHERE LongString = ''