Numeric may be set to more that specidied precision ---------------------------------------------------
Key: CORE-3556 URL: http://tracker.firebirdsql.org/browse/CORE-3556 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.1.3 Environment: Firebird 2.1 64bit Windows 7 sp1 dialect 3 (!) Reporter: Roman Krivykh CREATE TABLE TEST ( B NUMERIC(18,5) DEFAULT 0 NOT NULL ); insert into test values1.0000199) select iif(b = 1.10002, 'true', 'false') from test returns true Is that how it must work? Do I missed something? Similar issues claims that this behavior is impossible with dialect 3. -- 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 ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel