Error Thrown When Sorting Field Is Not Selected about prisma HOT 3 OPEN

Hey @Hellio404, I can confirm the ""2100 parameters"" error message but I can't confirm the resolution by including the createdAt: true in the select, neither on dev nor on 5.3.1.

await prisma.post.findMany({
  where: { authorId: { in: Array.from(Array(4000).keys()) } },
-  select: { id: true, title: true },
+  select: { id: true, title: true, createdAt: true },
  orderBy: { createdAt: 'asc' },
});

Could you please provide a reproduction that shows this succeeding with the inclusion of createdAt in select

from prisma.

@Druue

I double checked and I confirm that adding the createdAt: true fixes the issue for me as well as removing select all together

  const { id } = await client.user.create({
    data: {
      posts: {
        createMany: {
          data: Array(4000).fill({title: 'post'}),
        }
      }
    }
  });
  // this works
  const sortedPosts = await client.post.findMany({
    where: { authorId: { in: Array.from(Array(4000).keys()) }},
    select: {id: true, title: true, createdAt: true},
    orderBy: {createdAt: 'asc'},
  });
  // this works too
  await client.post.findMany({
    where: { authorId: { in: Array.from(Array(4000).keys()) }},
    orderBy: {createdAt: 'asc'},
  });

from prisma.

Huh, I double checked in another repro repo and I can reproduce it there. You can see a link above. For some reason, however, I still cannot reproduce this in our internal reproductions dir that directly hooks into a locally-built version of the client. I have no idea what's going on there :/

Looking at the succeeding findMany query that includes createdAt: true, I see following two (minimised) SQL queries logged.

SELECT [dbo].[Post].[id], [dbo].[Post].[title], [dbo].[Post].[createdAt]
FROM [dbo].[Post]
WHERE [dbo].[Post].[authorId] IN (@P1 ... @P2098)

SELECT [dbo].[Post].[id], [dbo].[Post].[title], [dbo].[Post].[createdAt]
FROM [dbo].[Post]
WHERE [dbo].[Post].[authorId] IN (@P1 ... @P1902)

If I swap to the failing query that doesn't include createdAt: true, I see the following logged

SELECT [dbo].[Post].[id], [dbo].[Post].[title]
FROM [dbo].[Post]
WHERE [dbo].[Post].[authorId] IN (@P1 ... @P2098)

with the following error:

thread 'tokio-runtime-worker' panicked at query-engine/query-structure/src/record.rs:69:46:
no entry found for key
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

This is the relevant code that it references

and then the following SQL query after:

SELECT [dbo].[Post].[id], [dbo].[Post].[title]
FROM [dbo].[Post]
WHERE [dbo].[Post].[authorId] IN (@P1 ... @P1902)

from prisma.