SQL Error in search_cluster_data_equality

[mabezi]

Checking the equality of the data fails because of an SQL error.

I think it's a bit related to a design decision in the code, so I'm not quite sure how to fix it.

SQL Error:

[Thu Jun 29 21:25:51 2023][Error][Kernel::System::Search::Admin::Reindexation::DataEqualitySet][363] ERROR:  null value in column "last_reindexation" of relation "search_cluster_data_equality" violates not-null constraint
DETAIL:  Failing row contains (61, 3, Article, 100.00, 2023-06-29 21:25:51, 2023-06-29 21:25:51, null)., SQL: '
                    INSERT INTO   search_cluster_data_equality (cluster_id, index_name, percentage, create_time, change_time)
                    VALUES        (?, ?, ?, '2023-06-29 21:25:51', '2023-06-29 21:25:51')
                '

It looks like the immediate cause is here:

Znuny-Search/Kernel/System/Search/Admin/Reindexation.pm

Lines 361 to 364 in 14ca672

	if ( $IndexesToUpdateReindexTime{$Index} ) {
	$ReindexationTimeUpdateSQL = ', last_reindexation';
	$ReindexationTimeUpdateSQL2 = ', current_timestamp';
	}

This query is made across the entire file.

Since the method evaluates to false, the field is not added to the SQL query, even though it is a required and non nullable field, according to the definition of the relation:

Znuny-Search/Znuny-Search.sopm

Line 165 in 14ca672

<Column Name="last_reindexation" Required="true" Type="DATE"/>

Is there a reasonable reason why this if-query is set as a condition for the field?