BIN_AND() wrong result ---------------------- Key: CORE-5059 URL: http://tracker.firebirdsql.org/browse/CORE-5059 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.5 Environment: Windows 8.1 64-bit - Firebird 2.5.5 (x64) Reporter: F.D.Castel
BIN_AND is not working as expected: SELECT 0xFFFFFFFF , /* -1 */ BIN_AND(0xFFFFFFFFFF, 0x0000000F), /* 15 */ BIN_AND(0xFFFFFFFFFF, 0x000000FF), /* 255 */ BIN_AND(0xFFFFFFFFFF, 0x00000FFF), /* 4095 */ BIN_AND(0xFFFFFFFFFF, 0x0000FFFF), /* 65535 */ BIN_AND(0xFFFFFFFFFF, 0x000FFFFF), /* 1048575 */ BIN_AND(0xFFFFFFFFFF, 0x00FFFFFF), /* 16777215 */ BIN_AND(0xFFFFFFFFFF, 0x0FFFFFFF), /* 268435455 */ BIN_AND(0xFFFFFFFFFF, 0xFFFFFFFF) /* 1099511627775 (?!) */ FROM rdb$database The last result should be -1 (0xFFFFFFFF). No UDFs attached. Clean install of Firebird Server 2.5.5 (x64) on Windows 8.1 (x64) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel