mirror of
https://github.com/photoprism/photoprism.git
synced 2026-07-17 16:49:04 +00:00
0cecb5287f
Folder search lowercases the query term, but album_path is VARBINARY and compared byte-exact (case-sensitive) on MySQL/MariaDB, so a lowercased term no longer matched uppercase folder paths. A parent folder still appeared via its case-insensitive title, while child folders - matchable only by path - dropped out of the results. Add a dialect-aware PathLike helper: MySQL converts album_path to a case-insensitive collation for the LIKE, SQLite and other dialects fall back to a plain LIKE (SQLite is already ASCII case-insensitive). Only the folder search filter is affected; byte-exact album_path identity lookups are unchanged, so emoji and case-distinct folders stay distinct. |
||
|---|---|---|
| .. | ||
| ai | ||
| api | ||
| auth | ||
| commands | ||
| config | ||
| entity | ||
| event | ||
| ffmpeg | ||
| form | ||
| mcp | ||
| meta | ||
| mutex | ||
| photoprism | ||
| raw | ||
| server | ||
| service | ||
| thumb | ||
| workers | ||
| AGENTS.md | ||