#97775Rename of directory name in file list results in updating of all related sys_file_metadata
Description
In TYPO3 v10. The renaming of a directory took very long and at some point there was an exception related to an UPDATE query on sys_file_metadata. The exception is a different problem, but I was wondering why all sys_file_metadata are updated. Should they not be related to the uid in sys_file and not be concerned about the path at all?
As noted, this causes the renaming of directories to take longer than necessary.
Reproduce
1. check timestamp of a sys_file_metadata record, e.g.
select uid,FROM_UNIXTIME(tstamp),title,file from sys_file_metadata where file=291201;
2. Rename a directory which contains this file
3. check the timestamp again.
Reviews 2
History 26
-
Gerrit Code Review pushed patch set 1 for main to change 81046 status
NewUnder Review 09/18/23, 14:09 -
Gerrit Code Review pushed patch set 2 for main to change 81046 09/18/23, 15:10
-
Gerrit Code Review pushed patch set 3 for main to change 81046 09/18/23, 17:14
-
Gerrit Code Review pushed patch set 1 for 12.4 to change 81061 09/18/23, 21:12
-
Oliver Bartsch commented and changed status
Under ReviewResolved done0 %100 % 09/18/23, 21:15 -
Benni Mack changed status
ResolvedClosed 07/09/24, 12:46
Applied in changeset commit:e0a0643bfa68cb2f6fc7c2425e9858d6bd94a645.