[TYPO3-core] RFC #13945: Bug: Missing key on l18n parent in tt_content table

[Christian Kuhn]

Hey,

Dmitry Dulepov wrote:
> Martin Kutschker wrote:
>> Like "l18n_parent (l18n_parent,sys_language_uid,deleted)"?
>>
>> In theory Mysql wouldn't need to read any row of the table.
> 
> Yes but it also can decide that reading the table may take the same time
> as reading the index. This is actual for small tables. Thus it will not
> use the index at all. This depends on the index size a lot.
> 
> I think we might do better with (l18n_parent,sys_language_uid).

Yes, that's my feeling too. And it's done in v2. Feel free to prove the 
opposite ;)

Regards
Christian