Hello,

I need some help.

If I run this (in ISQL) or ODBC driver or anywhere:

select
siteid,'2009-12-15',year(auditdate),month(auditdate),sum(inhousero oms)
from forerev
group by siteid,'2009-12-15',year(auditdate),month(auditdate)
order by siteid,'2009-12-15',year(auditdate),month(auditdate)

It GPF's with a memory x0000000 error.

If I change it to:

select
siteid,'2009-12-15',year(auditdate),month(auditdate),sum(inhousero oms)
from forerev
group by siteid,'2009-12-15',year(auditdate),month(auditdate)
order by siteid,year(auditdate),month(auditdate)

It runs fine with NO GPF at all.

Please help and explain.

Thank you.

BTW: It runs fine in Sybase 9.02 ... but not in 8.x

-Robert

What version and build of 8.0.x? Have you tried the latest EBF for 8.0.3?

--
Joshua Savill
Sybase Inc. - Product Manager


Robert Paresi wrote:

Hi,

Not sure what version - it's a VERY old installation ... but I'll be sure to
patch it to 8.03

Thanks.

-Robert


"Josh Savill [Sybase]" <no_spam_jsavill_no_spam (AT) sybase (DOT) com> wrote

I reproduce this in early 8.0.3 builds. It was subsequently fixed as the
last 8.x MR and EBF do not show this behaviuour.

-chris


Robert Paresi wrote: