---------- Forwarded message --------- From: Mark Rotteveel <m...@lawinegevaar.nl> Date: Thu, May 21, 2020 at 8:25 AM Subject: Re: [Firebird-devel] CASE statement Error : Datatypes are not comparable in expression CASE To: Jorge Gonçalves <projo...@gmail.com>
This looks like a bug to me, could you report it on http://tracker.firebirdsql.org/browse/CORE ? After a more detailed analysis I have found the problem. I have run the upgrade process of my application that creates a table with one field "DELETED" with type BOOLEAN. That BOOLEAN type is a domain of type smallint, but the create statement uses the syntax "... DELETED BOOLEAN ...". Since we use FB2.5 that's ok, the engine will create a smallint field, but in FB4 this will create a BOOLEAN field. So is not a engine bug ... is a application upgrade bug. Regards jGoncalves <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
