group by rollup problem.

[Quoted] [Quoted] I have a problem with executing my query on oracle 10g express edition.

I have the following table:

create table test
(

        col char(60)
)

[Quoted] [Quoted] 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

[Quoted] 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 Received on Mon Jan 22 2007 - 16:18:57 CET