Re: More pain and sufferring with Tropashko's materialized path...

vadimtro_at_yahoo.com (Vadim Tropashko) wrote in message news:<22d2e427.0309171245.534732eb_at_posting.google.com>...
> "Robin Tucker" <r.tucker_at_thermoteknix.com> wrote in message news:<bk6os9$hrt$1$8302bc10_at_news.demon.co.uk>...
> > The error is "Arithmetic overflow error converting expression to data type
> > float". This, I assume, is for the POWER function. So even when I use
> > BIGINT or DECIMAL(12,0), the problem is still there.
>
> I suggest posting the function and invocation context at microsoft
> forum, as there must be definitely a simple solution to your overflow
> problem.
>
> Otherwise, I'm inclined to add the following paragraph into my next
> article
> <quote>
> An immediate property of the above labeling schema is density: we have
> all integer positive numbers utilized. Since some database
> implementations have integers of limited range only, density might
> become an attractive feature, because one would be able to store and
> manipulate bigger trees before hitting arithmetic overflow exception.
> Today, the problem of 16-bit overflow is ridiculous, of course, but
> that is nevertheless the practical limitation that database developer
> have to live with in some RDBMS implementations.
> </quote>
>
> I'm suspecting once again, however, that the blank statement at the
> very end that I had drawn from your experience is wrong. I would be
> happy to learn that the overflow is a non-issue and remove the last
> statement.

Hello,

I'll have to defend SQL Server. COnsider this in Oracle:

select rownum, path, path_numer(path), path_denom(path) from (   select '1' path from dual
   union all
  select '1.'||rownum from all_objects
)

Result:

      rownum path

...............................................
       119       1.118           6.6461E+35      6.6461E+35
       120       1.119           1.3292E+36      1.3292E+36

ERROR:

ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "STARGUS.CHILD_NUMER", line 5
ORA-06512: at "STARGUS.PATH_NUMER", line 19
ORA-06512: at line 1

... only after 120 rows.

VC.

120 rows selected. Received on Sat Oct 18 2003 - 21:32:23 CEST