Re: Multiple datasets in one dataset

On Wed, 17 Oct 2007 06:36:47 -0700, roman.morokutti_at_googlemail.com wrote:

>Hi Brian,
>
>sorry, that I did not answer your previous post completely.
>Your assumption (5a ... 5f) were all right.
>
>The data gets be collected correctly.
>
>After excessive testing I found out, that Oracle ends up
>in an endless loop when executing your fabulous state-
>ment with data where CURR_MS and all other VALUE_N
>are filled with 0.
>
>Maybe you could test it with the following sample data:
>
>REM INSERTING into FOO
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',11,0,0,0,0,0,0,0,0,0,0,0);
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',21,0,0,0,0,0,0,0,0,0,0,0);
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',22,0,0,0,0,0,0,0,0,0,0,0);
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',23,0,0,0,0,0,0,0,0,0,0,0);
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',24,0,0,0,0,0,0,0,0,0,0,0);
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',25,0,0,0,0,0,0,0,0,0,0,0);
>Insert into FOO
>(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
>values ('418',26,0,0,0,0,0,0,0,0,0,0,0);
>
>I think we should be aware of such 0 values. What do you think?
>
>Regards
>Roman

I do not see the "endless loop". What do you mean?

B. Received on Wed Oct 17 2007 - 12:07:42 CDT