Home -> Usenet -> c.d.o.tools -> Re: group by rollup problem.

Re: group by rollup problem.

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 22 Jan 2007 14:57:01 -0800
Message-ID: <1169506616.315024_at_bubbleator.drizzle.com> 






Wojtek wrote:

> 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





Then I think Andy called it correctly.

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


Received on Mon Jan 22 2007 - 23:57:01 CET












Original text of this message