[TIKA-4172] Apple binary file incorrectly identified as text/x-sql due to filename

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: 2.9.1
• Component/s: general
• Assignee: Unassigned
• Reporter: martin k.
• Created: 22/Nov/23 20:04
• Updated: 16/Dec/23 09:59
• Resolved: 16/Dec/23 09:59

Description

This is related to https://github.com/eikek/docspell/issues/2376 and https://github.com/eikek/docspell/issues/2403.

Take the following Base64 encoding of a binary Apple-generated file. No idea what it does. You can get the file by piping the following to e.g. base64 -d > something.sql

ABRkMDEwMWM2Nl9teVNRTDQwLnNxbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAbUJJTgAA
AAAAAAAAAAAAAAAAAACCgf+/AAA=

If this file is name something.sql, then Tika will classify it as text/x-sql, which it is not. It seems like more weight is given to the filename (extension) than the fact that the file is binary anyway.