CAST behaving differently in version 2.5 ----------------------------------------
Key: CORE-4420 URL: http://tracker.firebirdsql.org/browse/CORE-4420 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.2 Environment: Linux server Reporter: Rodrigo Gonçalves The following commands give different results between versions 2.1.1 and 2.5.2, both running in Linux systems: Version 2.1.1: SQL> SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database; RDB$GET_CONTEXT =============================================================================== 2.1.1 SQL> select round(cast(260.9550000000000 as double precision), 2) from rdb$database; ROUND ======================= 260.9500000000000 Version 2.5.2: SQL> SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database; RDB$GET_CONTEXT =============================================================================== 2.5.2 SQL> select round(cast(260.9550000000000 as double precision), 2) from rdb$database; ROUND ======================= 260.9600000000000 We've looked through the release notes and bugtracker, but couldn't find any change related to it. -- 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 ------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel