unkin-agent
6e405af1dc
fix(db): collapse presentation-key groups without min(uuid)
...
ci/woodpecker/push/ci Pipeline was successful
ci/woodpecker/pr/ci Pipeline was successful
PostgreSQL has no min(uuid) aggregate, so every query that picked a group
representative with MIN over the item id failed with 42883: library browse,
search, Recently Added, the by-name endpoints and Upcoming.
- Pick the representative with an anti-join on (primary version, id)
- Cover the collapse with a repository test against a real PostgreSQL
2026-09-13 13:18:11 +10:00
5e621d0e3f
Order IsPlayed and IsUnplayed by the played state the filter reports
...
Ordering mapped both keys to the item's own stored UserData row. Folders do not
have one: a series, season or box set counts as played when no descendant is
left unplayed, which is what the isPlayed filter and the DTO both report. A
mixed library therefore sorted every series and box set into the unplayed group,
and a query could filter and sort by two different notions of "played".
Extract the filter's predicate into BuildIsPlayedFilter and route both sort keys
through it so the two cannot drift apart again.
2026-08-25 15:19:38 +02:00
8044534774
Merge remote-tracking branch 'upstream/master' into fix-byname-queries
2026-08-02 22:12:57 +02:00
45b8f6c4c8
Merge pull request #17486 from Shadowghost/fix-adjacent
...
Fix AdjacentTo being ignored on non-recursive item queries
2026-08-02 14:24:13 -04:00
044f651299
Merge pull request #17482 from Shadowghost/fix-stale-versions
...
Fix video version links being read from stale serialised item data instead of the LinkedChildren table
2026-08-02 14:24:05 -04:00
705368ee49
Merge remote-tracking branch 'upstream/master' into fix-byname-queries
...
# Conflicts:
# src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs
2026-08-01 21:41:16 +02:00
b94ba9d409
Merge remote-tracking branch 'upstream/master' into tmdb-missing-episodes
...
# Conflicts:
# Jellyfin.Server.Implementations/Item/BaseItemRepository.QueryBuilding.cs
2026-08-01 14:25:20 +02:00
e123a13e38
Apply the by-name access exemption in the search candidate query
2026-07-30 09:53:44 +02:00
d8fc0a9914
Fix AdjacentTo being ignored on non-recursive item queries
2026-07-29 13:13:44 +02:00
d64e18b69a
Fix more filter cases
2026-07-29 09:35:20 +02:00
7a4271c85f
Fix video version links being read from stale serialised item data instead of the LinkedChildren table
2026-07-29 07:31:27 +02:00
a94588497c
Fix Folder access filtering
2026-07-28 23:13:10 +02:00
eed664b7d3
Fix played/unplayed filter for empty Series and BoxSets
2026-07-28 12:43:12 +02:00
5a9fb80239
Exempt people from the allowed tags visibility check
2026-07-18 14:07:52 +02:00
2fcf4084f8
Add TMDb missing episode provider
2026-06-25 19:10:38 +02:00
fe1d8d8840
Collapse version groups to the primary version in queries
2026-06-07 23:06:14 +02:00
00b08c0b32
Omit BoxSet related materialization
2026-05-03 13:26:30 +02:00
a1f3da1819
Reduce correlated EXISTS queries
2026-04-26 18:53:17 +02:00
d19449e6a5
Use AsNoTracking() when only reading
2026-04-26 18:53:17 +02:00
fc866a64e0
Remove unnecessary materializations
2026-04-26 18:53:06 +02:00
f806ae4018
Fix too many SQL variables error on large libraries
2026-04-19 10:27:47 +02:00
6fdfc6a61b
Fix version filters
2026-03-30 21:04:59 +02:00
d5f4c624e3
Do not return alternate versions by default
2026-03-30 18:56:31 +02:00
ba722b4517
Optimize Search and NextUp queries
2026-03-08 15:26:35 +01:00
ea1c1d0468
Optimize grouping query performance
2026-03-07 20:14:04 +01:00
077fa89717
Split BaseItemRepository and IItemRepository
2026-03-07 20:12:42 +01:00
unkin-agent
Piotr Niełacny