Prisma Client: Add tests for orderByNulls preview feature for MongoDB

[Jolg42]

While checking #17081

I didn't find any tests in prisma/prisma running on MongoDB
Currently, the following databases are tested

    {
      provider: 'sqlite',
    },
    {
      provider: 'postgresql',
    },
    {
      provider: 'mysql',
    },
    {
      provider: 'sqlserver',
    },
    {
      provider: 'cockroachdb',
    },

https://github.com/prisma/prisma/tree/main/packages/client/tests/functional/order-by-null

[SevInf]

I don't think it's supported for mongo: https://github.com/prisma/prisma/blob/main/packages/client/tests/functional/order-by-null/tests.ts#L158

[Jolg42]

I could not find anything about it not being supported on MongoDB though 🤔

• https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#sort-with-null-records-first-or-last
• Preview feature feedback: Order By Nulls (orderByNulls) #14377
• https://github.com/prisma/prisma/releases/tag/4.1.0

[Weakky]

It is in the docs (might have been updated since you linked it). MongoDB is intentionally not supported yet because supporting the feature required too many hacks. The connector doesn't have the capability and thus doesn't expose the API at all. We could review that in the future but I'd suggest we keep it that way for now.

EDIT: Yeah, it didn't mention MongoDB at first #16728 (comment)