Re: group by rollup problem.
From: Wojtek <w_at_w.pl>
Date: Mon, 22 Jan 2007 22:48:36 +0100
Message-ID: <ep3bfj$6t9$1_at_inews.gazeta.pl>
>> 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?
Windows 2000 Received on Mon Jan 22 2007 - 22:48:36 CET
Date: Mon, 22 Jan 2007 22:48:36 +0100
Message-ID: <ep3bfj$6t9$1_at_inews.gazeta.pl>
DA Morgan napisał(a):
> 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?
Windows 2000 Received on Mon Jan 22 2007 - 22:48:36 CET