Division of numbers that wre written in scientific notation ( "1.23e4" ) was broken in dialect 1 (FB 4.0 only) ---------------------------------------------------------------------------------------------------------------
Key: CORE-5541 URL: http://tracker.firebirdsql.org/browse/CORE-5541 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Alpha 1 Reporter: Pavel Zotov Run this: set sqlda_display on; set wng off; set list on; set echo on; set sql dialect 1; select 1e2 + 1e1 from rdb$database; select 1e2 - 1e1 from rdb$database; select 1e2 * 1e1 from rdb$database; select 1e2 / 1e1 from rdb$database; Expected result should finish with: === select 1e2 / 1e1 from rdb$database; INPUT message field count: 0 OUTPUT message field count: 1 01: sqltype: 480 DOUBLE scale: 0 subtype: 0 len: 8 : name: DIVIDE alias: DIVIDE : table: owner: DIVIDE 10.00000000000000 === But on WI-T4.0.0.639 output will finish like this: === select 1e2 / 1e1 from rdb$database; Statement failed, SQLSTATE = 42000 Dynamic SQL Error -expression evaluation not supported -Division in dialect 1 must be between numeric data types === No troubles with dialect 3. No troubles in current 3.0.2 builds. -- 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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel