Re: [Info-Ingres] E_OP03A2

Hi Marty,
 
Yep, tried that too. The problem only goes away when the table stats are
dropped.
Which to me makes sense if the problem is related to the histogram.
 
I called it in and it looks like a known bug has somehow krept in the
patch we're currently
running.
 
Andre

________________________________

From: info-ingres-bounces@[EMAIL PROTECTED]
 on behalf of Martin
Bowes
Sent: Thu 27/03/2008 4:44 AM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] E_OP03A2



Hi Andre,

 

Have you tried rebuilding the stats on the table /column?

 

Martin Bowes

 

From: info-ingres-bounces@[EMAIL PROTECTED]
 On Behalf Of
Laframboise André
Sent: 26 March 2008 18:58
To: Ingres and related product discussion forum
Subject: [Info-Ingres] E_OP03A2

 

Hi,

 

Anyone ever see this error with Ingres 2006 R2 ?

 

  1> select count(*) from s_verity_marc_xml
      where trstn_dte ='2008-03-26 00:00:00'

 

E_OP03A2 consistency check
    - histogram on s_verity_marc_xml attribute trstn_dte is not
    monotonically increasing
    (Wed Mar 26 14:43:07 2008)

 

Our version is II 9.1.0 (i64.lnx/123)NPTL. The same query works fine with
2.6.

Is there a new optimizedb flag I should be using ?

 

Thanks

 

Andre