Ok, so we do not follow the standard in our currently implementation,
but we follow the standard in the DDL checking... this is a bit messy <g>

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DY> 10.08.2017 21:57, Carlos H. Cantu wrote:

>> DY> e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 
>> 6).
>> 
>> Are you sure? I can store such value both in (15, 4) as well in (15, 6).

DY> Formally, it cannot be stored inside (15, 6). But historically, FB 
DY> ignores the declared precision and always uses the maximum for the 
DY> underlying storage. This is buggy (from the SQL spec POV) and I expect
DY> to have it fixed/improved one day.


DY> Dmitry


------------------------------------------------------------------------------
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

Reply via email to