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

Reply via email to