It is possible to store more digits than de declared precision in DECIMAL(X,Y)
------------------------------------------------------------------------------
Key: CORE-5723
URL: http://tracker.firebirdsql.org/browse/CORE-5723
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.2
Environment: Debian/unstable 64-bit, SQL dialect 3
Reporter: Damyan Ivanov
Priority: Minor
SQL> create table test(a decimal(18,18), b decimal(3,3));
SQL> insert into test(a,b) values('9.123456789012345678', '999999.999');
SQL> set list;
SQL> select * from test;
A 9.123456789012345678
B 999999.999
--
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
