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
