Find by a null time doesn't work

[matthewmueller]

create table events (
  id serial not null primary key,
  "time" timestamp with time zone
);
insert into events ("time") values (NULL);
insert into events ("time") values (NULL);
insert into events ("time") values (NULL);

client.events.findMany({ where: { time: null } })

Expect 3 fields, don't get any back.

[pantharshit00]

I received a rust panic when I tried the above:

 const data = await client.events.findMany(Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: FromSql(1), cause: Some(WrongType { postgres: Type(Timestamptz), rust: "core::option::Option<alloc::string::String>" }) }) })
    at PrismaClientFetcher.request (/Users/harshit/code/reproductions/issue-matt-2/node_modules/@prisma/client/index.js:89:17)
    at processTicksAndRejections (internal/process/task_queues.js:94:5)
(node:8290) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
(node:8290) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
 const data = await client.events.findMany(Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: FromSql(1), cause: Some(WrongType { postgres: Type(Timestamptz), rust: "core::option::Option<alloc::string::String>" }) }) })
    at PrismaClientFetcher.request (/Users/harshit/code/reproductions/issue-matt-2/node_modules/@prisma/client/index.js:89:17)
    at processTicksAndRejections (internal/process/task_queues.js:94:5)
(node:8290) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
(node:8290) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

Schema:

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = "postgresql://xxxxx:xxxxxx@localhost:5432/matt-2?schema=public"
}

model events {
  id   Int       @id
  time DateTime?
}

Version: prisma2@2.0.0-alpha.781, binary version: a1a562d6f7093ae4ac17ebe3c8d2b387b2ed0598

[janpio]

Can you please reconfirm this @pantharshit00? @tomhoule recently fixed some stuff related to timestamps, so maybe this returns a different error message now.

[dpetrick]

Unable to reproduce on the query-engine level.

Datamodel:

model Event {
  id   Int       @id
  time DateTime?
}

After firing a bunch of mutations with and without time set:

mutation {
  createOneEvent(data: {
    id: 5
    time: "2020-03-17T13:32:09"
  }) {
    id
    time
  }
}

I am able to get only events with time: null as following:

{
  findManyEvent(where: {
    time: null
  }) {
    id
    time
  }
}

[pantharshit00]

Unable to reproduce as well in preview024. Closing