Rudder

So, these two fields are not used much:

• insertiondate is mapped to AgentRunWithoutCompliance.insertionDate which is never read. It's only modified when the report is inserted
• compliancecomputationdate is read but only to check if null or set.

ReportsExecutionRepositoryImpl.scala
...
79        s"""SELECT nodeid, date, nodeconfigid, insertionid, insertiondate FROM ReportsExecution where compliancecomputationdate is null""" 
...
131             |( SELECT nodeid, max(date)) FROM ReportsExecution where compliancecomputationdate is not null group by nodeid)""".stripMargin)
...

reportsSchema.sql
...
CREATE INDEX reportsexecution_uncomputedrun_idx on ReportsExecution (compliancecomputationdate) where compliancecomputationdate IS NULL;
...

So we can alter the column type violently without changing behavior, not caring for existing data.