Subject RE: [firebird-support] Datatypes are not comparable in expression CASE when using TIMESTAMPS
Author Maya Opperman
>Mark Rotteveel wrote:
>I am unable to reproduce it. Could you create a simple reproduction script that creates the table, adds the testdata and includes the query?

>My reproduction is:

>CREATE TABLE int_date_table
> intfield INTEGER,
> datefield DATE,
> timestampfield TIMESTAMP

Make datefield a TIMESTAMP, not a DATE, and you should get the error as well.