[Info-Ingres] E_OP03A2

[glennr69 at gmail.com]

On Mar 27, 7:58 am, Laframboise André <andre.laframbo... at lac-
bac.gc.ca> wrote:
> 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

Hi Andre

Yes - we had the same problem - required a new patch to get it working
ok.

Cheers
Glenn