Mark Rotteveel wrote 10.10.2021 18:08:
Yes, this is normal. The range of a smallint is from -32768 to 32767, so you can't negate -32768 as it will overflow back to -32768, hence it will raise the integer overflow error.
The question is whether result of negation should keep the type of source or can it be expanded if needed.
-- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel