Deluan Quintão
13c48b38a0
fix(smartplaylists): coerce string booleans in smart playlist rules (#5450)
* fix(criteria): coerce string booleans in smart playlist rules - #4826
When clients (e.g. Feishin) send boolean values as strings ("true"/"false")
in smart playlist JSON rules, the SQL comparison fails because SQLite stores
booleans as 0/1 integers. For example, `COALESCE(annotation.starred, false) = 'true'`
never matches.
This adds a `boolean` flag to mapped fields and coerces string values to
native Go bools in `mapFields`, so squirrel generates correct SQL parameters.
Signed-off-by: mango766 <mango766@users.noreply.github.com>
Signed-off-by: easonysliu <easonysliu@tencent.com>
* fix(criteria): implement boolean string coercion for smart playlist rules
Signed-off-by: Deluan <deluan@navidrome.org>
---------
Signed-off-by: mango766 <mango766@users.noreply.github.com>
Signed-off-by: easonysliu <easonysliu@tencent.com>
Signed-off-by: Deluan <deluan@navidrome.org>
Co-authored-by: easonysliu <easonysliu@tencent.com>
2026-05-01 19:21:48 -04:00
..
2026-05-01 19:21:48 -04:00
2026-03-13 21:06:26 -04:00
2026-04-19 13:16:47 -04:00
2025-06-26 15:50:56 -04:00
2026-02-26 10:50:12 -05:00
2026-02-26 10:50:12 -05:00
2026-01-18 17:42:42 -05:00
2026-03-15 22:19:55 -04:00
2026-03-15 22:19:55 -04:00
2026-03-13 18:33:18 -04:00
2026-03-18 18:57:33 -04:00
2026-02-08 09:57:30 -05:00
2025-07-18 18:41:12 -04:00
2022-12-28 15:31:56 -05:00
2024-05-09 22:26:15 -04:00
2026-04-19 13:16:47 -04:00
2025-11-14 22:15:43 -05:00
2025-02-19 20:35:17 -05:00
2026-03-18 18:57:33 -04:00
2026-03-15 22:19:55 -04:00
2025-07-18 18:41:12 -04:00
2025-04-30 08:10:19 -04:00
2025-04-30 08:10:19 -04:00
2025-02-19 20:35:17 -05:00
2026-04-19 20:07:23 -04:00
2026-04-10 19:29:20 -04:00
2022-12-21 14:53:36 -05:00
2025-02-19 20:35:17 -05:00
2025-06-28 19:00:13 -04:00
2025-03-23 11:53:43 -04:00
2026-04-19 13:16:47 -04:00
2026-04-27 12:20:27 -04:00
2025-06-11 12:02:31 -04:00
2026-03-02 08:56:56 -05:00
2024-05-12 21:37:42 -04:00
2026-03-18 18:57:33 -04:00
2026-03-18 18:57:33 -04:00
2025-11-14 22:15:43 -05:00
2026-02-08 09:57:30 -05:00
2024-04-26 16:59:14 -04:00
2025-12-06 11:07:18 -05:00
2026-02-23 08:51:54 -05:00
2026-02-08 09:57:30 -05:00
2025-07-26 21:40:41 -04:00
2025-02-19 20:35:17 -05:00
2026-02-08 09:57:30 -05:00
2023-12-09 13:52:17 -05:00
2025-07-18 18:41:12 -04:00
2026-02-17 09:28:42 -05:00