Stacked photos may be rendering in duplicate with the new Kysely migration

[aminesebastian]

The bug

Heyo folks!

I have a fork of Immich I've been using to add stacked photo viewing to albums while waiting for the outstanding PR for that to get merged. I'd initially forked straight from main (not from the latest release commit) and found that stacks were having the individual photos within them displayed on the timeline alongside the stack. It looks like the logic to de-dup when withStacked is passed is not working after the Kysely migration. When querying for a stacked asset that is not the primary for the stack, the stack value is the response is null.

Whatever the issue is, it appears to be with the query and not with how data is written, bc flipping between using the latest release tag and main as the base for my custom build hides and resolves the issue.

The OS that Immich Server is running on

Slackware (Unraid)

Version of Immich Server

latest main

Version of Immich Mobile App

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

-

Your .env content

-

Reproduction steps

1. Create a photo stack - note that everything looks as it should (based on my cursory reading, it looks like the web client removes the stacked photos on the client-cached assetStore).
2. Refresh the page -- note that the stack now appears, but so do all the photos inside it.
3. Switch to the latest release branch and note that the stack appears, but the photos inside do not (expected behaviour).

Relevant log output

No response

Additional information

No response

[aminesebastian]

cc @mertalev -- I'm thinking this PR might be where the issue started. I've only started looking at Immich code today, so please forgive me if I'm way off base here 😅.

[mertalev]

Thanks, this was fixed in #15509