Re: group by rollup problem.
From: Wojtek <xx_at_xx.pl>
Date: Tue, 23 Jan 2007 10:51:59 +0100
Message-ID: <ep4lsd$2vs$1_at_inews.gazeta.pl>
> [snip runnable testcase]
>
> 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
Date: Tue, 23 Jan 2007 10:51:59 +0100
Message-ID: <ep4lsd$2vs$1_at_inews.gazeta.pl>
Andy Hassall napisał(a):
> 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?
>
> 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
Thank you guys!
Unfortunately this is bad news for me. We are migrating our software from Oracle 9i to Oracle XE, and I will have to fix this bug in many places...
Anyway, thank you once again!
Wojtek Received on Tue Jan 23 2007 - 10:51:59 CET