#81320Inserting in sys_refindex leads to SQL error message
Description
Given I have the following TCA field configuration:
'multiple' => [
'label' => 'Multiple',
'config' => [
'type' => 'group',
'internal_type' => 'db',
'allowed' => 'pages',
'multiple' => true,
'size' => 10,
],
],
When I select the same page multiple times in this record
I expect to be able to save the record without error and see the selected page multiple times in the select box
Actual result:
Exception is thrown:
An exception occurred while executing 'INSERT INTO `sys_refindex` (`tablename`, `recuid`, `field`, `flexpointer`, `softref_key`, `softref_id`, `sorting`, `deleted`, `workspace`, `ref_table`, `ref_uid`, `ref_string`, `hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["sys_category", 2, "multiple", "", "", "", 1, 0, 0, "pages", 437, "", "7534be502285b68ac2b24999aca60fe0"]: Duplicate entry '7534be502285b68ac2b24999aca60fe0' for key 'PRIMARY'