group by rollup problem.

From: Wojtek <>
Date: Mon, 22 Jan 2007 16:18:57 +0100
Message-ID: <ep2klf$n18$>


[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:

  , count(*)
from test t,

    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

Original text of this message