And interestingly, I've just found that rebuilding the CCI only fixes existing data; any new rows added have the same issue. Leading to the only fix I can find being to completely rebuild the table. Non ideal indeed