Re: group by rollup problem.
Date: Mon, 22 Jan 2007 20:01:27 +0000
Message-ID: <si5ar21738hhdbiceptuplb8bgjsbjchka_at_4ax.com>
[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 toolReceived on Mon Jan 22 2007 - 21:01:27 CET