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

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Mon, 15 Sep 2003 14:52:12 -0700
Message-ID: <NEq9b.33$lB2.204_at_news.oracle.com>


May I suggest bigint?

"Robin Tucker" <r.tucker_at_thermoteknix.com> wrote in message news:bk4v08$mek$1$8302bc10_at_news.demon.co.uk...
>
> When I execute this function with a number such as 113755/65536, I get
> arithmetic overflow. When I convert them to "real", same problem.
> Everything is fine with smaller numbers, such as you get for the test
cases
> given.
>
> This problem has occurred on a test tree containing only 500 nodes that
goes
> to a depth of 12. I thought I had this materialized path thing cracked,
but
> it seems I haven't! (using MS T-SQL by the way, perhaps there is some
other
> data-type I should be using?).
>
> Any ideas?
>
>
> ALTER FUNCTION dbo.func_Get_Child_Numerator
> (
> _at_numer INTEGER,
> _at_child INTEGER
> )
> RETURNS INTEGER
> AS
> BEGIN
> RETURN _at_numer * POWER ( 2, @child ) + 3 - POWER ( 2, @child )
> END
>
>
Received on Mon Sep 15 2003 - 23:52:12 CEST

Original text of this message