Re: group by rollup problem.

Wojtek wrote:
> Hi!
>
> I have a problem with executing my query on oracle 10g express edition.
>
> I have the following table:
>
> create table test
> (
> col char(60)
> )
>
> insert into test values('aaa')
> insert into test values('bbb')
> insert into test values('ccc')
> insert into test values('acc')
>
>
> The query is:
>
> select
> p1
> , count(*)
> from test t,
> (select
> substr(col,1,1) p1
> , col
> from test
> ) p
> where t.col = p.col
> group by rollup(p1)
> having grouping(p1) = 1 or p1 is not null
>
> It gives me the following error: ORA-03113: end-of-file on communication
> channel.
>
> When the last line is commented out, it works fine.
> When you replace "substr(col,1,1)" with "col" it works fine.
> When the column's type is number, it works fine.
>
> Does anybody have a clue what's going on?
>
> Best regards,
>
> Wojtek

Operating system?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org