The original Interbase implementation had rational, aka reasonable, arithmetic semantics. Your example is an excellent example of idiotic semantics. Borland rewrote the code to conform what they, severely lacking in working neurons, interrupted the SQL standard to require.
I care very little about official SQL semantics. I care deeply about getting the wrong answer. Given a choice between SQL semantics (correctly interpreted), I'd go with right answers every time. This needs rational thought and careful discussion. Surely there is some middle ground between SQL and useful. On 12/7/2015 12:39 PM, Carlos H. Cantu wrote: > SS> I have several points against this idea: > > You opinion is welcome :) > > SS> 1. Decimal or Numeric is used for to keep exact accuracy. > SS> If you don't need this accuracy use float point data types. > > You didn't get the point. There is no loss of accuracy. The data types > will continue working as is. Remember, as I said, today you already have to > cast > if you want to make the formula work, so, you are already "loosing" > digits. > > > SS> 2. System that will produce unpredictable results in math is really hard > SS> to use. > SS> Some numbers will rounded, truncated or modified. > SS> There will lot of risk in financial calculation because real result > SS> will depend > SS> on server config. > > What risks? As I said, currently formulas will keep working in the > exact same way. About server config, personally, I think that > parameter is not needed. > > SS> From my point of view, this auto casting will generate more problems > SS> than helps. > > Do you have a better solution for the proposed problem? > > []s > Carlos > http://www.firebirdnews.org > FireBase - http://www.FireBase.com.br > > > ------------------------------------------------------------------------------ > Go from Idea to Many App Stores Faster with Intel(R) XDK > Give your users amazing mobile app experiences with Intel(R) XDK. > Use one codebase in this all-in-one HTML5 development environment. > Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. > http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK. Use one codebase in this all-in-one HTML5 development environment. Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
