[MDEV-23569] temporary tables can overwrite existing files Created: 2020-08-25  Updated: 2020-10-06  Resolved: 2020-08-26

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Create Table
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.1.48, 10.2.35, 10.3.26, 10.4.16, 10.5.7

Type: Bug Priority: Blocker
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-23570 deprecate keep_files_on_create Closed

 Description   

MyiSAM/Aria traditionally overwrite exiting MYI/MYD/MAI/MAD files when creating a new table.

This, kind of, made sense, because before MDEV-11412 there was no way to remove stale MyISAM/Aria files.

But temporary tables use generated file names that are supposed to prevent filename collisions. They should not overwrite files on collisions, because there should be no collisions. And if a conflict does happen, it usually indicates that something fishy is going on and an error message would be safer than any destructive action.

This bug was reported by RACK911 LABS
Generated at Thu Feb 08 09:23:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.