> -----Original Message----- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Lunes, 28 de Abril de 2014 14:21 > > > 7) It is known that mixing DDL/DML in the same transaction can cause > > corruption in DBs. If this cannot be 100% fixed, I suggest to > > introduce some mechanism to detect such situation and avoid the > > execution of the statement before corruption happens. > > Maybe my memory is failing, but I don't remember corruptions > because of > this reason. v1.0 and v1.5 don't count.
I know people will feel outraged with my opinion, but anyway: make DDL operations atomic and immediate. Uncommitted DDL and DML working in unison with stable DB structure is a naive dream, period. > > 8) Enhancement to the numerics calculations. The currently rule of > > summing the scale of the types involved in muls/divs is very bad and > > can easily cause overflow. Maybe FB could automatically truncate the > > result to the maximum precision possible to accommodate the final > > value. Even better if the truncation happens only in the > final result > > (not during the internal calculations). > > Blame me for delaying it again and again. But I don't agree with > truncations, Mark is right that a longer precision is a better way to > go. However, longer NUMERIC/DECIMAL data types and longer > intermediate > results during calculations are two different things, even if related. This is very important limitation, IMHO. SqlServer goes up to numeric(38,0), for example. I'm not sure why longer data types and longer intermediate results are very different things; probably my neurones are becoming rusty. The only difference I see is that intermediate large results can be volatile things inside the server code but can't be declared as proper data types neither stored in the DB. C. ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
