Population fails for cm:created property
When you have a query set with cm:created property the table table is created successfully, when you create a document, the cm_created column will be populated. But when the population is triggered it will fail with the following error:
After an iteration of PR review, we’ve figured out that it is pointless to edit the population code to cater for auditable properties as these are always selected by the accelerated query
The right changes need to happen in DefaultQuerySetConfigValidator where properties we decide to ignore get filtered out from the QuerySetDetail object that is validated (as of now this happens for any MLText property we detect), and in DBQueryEngineEnterprise where the predicates found in a given query are checked against available query sets to figure out whether they can be accelerated. Here, any auditable predicate that is found in the query will not be considered to determine whether they are supported by a given query set.
These columns have to be treated differently as they belong to the alf_node table. During the population, a specific select has to be used that loads the data from alf_node rather than look into the node properties.
From the 150M the ‘created’ is not present in alf_qname: