Hello everyone I try to use @@fulltext search in MySQL DB:

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["dataProxy", "referentialIntegrity", "fullTextSearch", "fullTextIndex"]
}

model User {
  username            String?
  email               String?

  @@fulltext([username, email])
  @@fulltext([username])
  @@fulltext([email])
}

Migration:

-- CreateIndex
CREATE INDEX `User_username_email_idx` ON `User`(`username`, `email`);

-- CreateIndex
CREATE INDEX `User_username_idx` ON `User`(`username`);

-- CreateIndex
CREATE INDEX `User_email_idx` ON `User`(`email`);

Also I have run

yarn prisma db push

But I still get error P2030:

Cannot find a fulltext index to use for the search

when trying to search by any field:

return await prisma.user.findMany({
    where: {
      username: input?.username && { search: input.username },
      email: input?.email && { search: input.email },
      type: input?.type,
    },
    select: {
      ...getSharedSelectableFields(),
    },
    take: input?.take,
    skip: input?.skip,
  });

Why this can happen? Prisma version: 3.8.1