Re: group by rollup problem.

[Quoted] On Mon, 22 Jan 2007 16:18:57 +0100, Wojtek <xx_at_xx.pl> wrote:

>I have a problem with executing my query on oracle 10g express edition.
>
>I have the following table:
>
[snip runnable testcase]
>
>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?

[Quoted]  It's a bug in Oracle XE. Look in your alert log and you'll see something like:

Mon Jan 22 19:55:22 2007
Errors in file c:\oracle\xe\app\oracle\admin\xe\udump\xe_ora_1612.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_qeesTraverseExpr+23] [PC:0x1443013] [ADDR:0x0] [UNABLE_TO_READ] []

 Unfortunately Oracle aren't keeping up with patches for XE, so you're stuck, unless you can rewrite the SQL to a form that gives the same results but is sufficiently different to avoid the bug. It looks somewhat like bug 4573980, fixed in 10.2.0.2 - but XE is 10.2.0.1.

--
Andy Hassall :: andy_at_andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool