This is a multi-part message in MIME format. ------_=_NextPart_001_01C88F73.592FFFE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, =20 Anyone ever see this error with Ingres 2006 R2 ? =20 1> select count(*) from s_verity_marc_xml where trstn_dte =3D'2008-03-26 00:00:00' =20 E_OP03A2 consistency check - histogram on s_verity_marc_xml attribute trstn_dte is not monotonically increasing (Wed Mar 26 14:43:07 2008) =20 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 ? =20 Thanks =20 Andre ------_=_NextPart_001_01C88F73.592FFFE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:v =3D=20 "urn:schemas-microsoft-com:vml" xmlns:o =3D=20 "urn:schemas-microsoft-com:office:office" xmlns:w =3D=20 "urn:schemas-microsoft-com:office:word" xmlns:m =3D=20 "http://schemas.microsoft.com/office/2004/12/omml"><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3243" name=3DGENERATOR> <STYLE>@[EMAIL PROTECTED] { font-family: Calibri; } @[EMAIL PROTECTED] Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt = 72.0pt; } P.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: = "Calibri","sans-serif" } LI.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: = "Calibri","sans-serif" } DIV.MsoNormal { FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: = "Calibri","sans-serif" } A:link { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99 } A:visited { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99 } SPAN.EmailStyle17 { COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: = personal-compose } ..MsoChpDefault { mso-style-type: ex****t-only } DIV.Section1 { page: Section1 } </STYLE> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></HEAD> <BODY lang=3DEN-GB vLink=3Dpurple link=3Dblue> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff = size=3D2><SPAN=20 class=3D890495418-26032008>Hi,</SPAN></FONT></DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff = size=3D2><SPAN=20 class=3D890495418-26032008></SPAN></FONT> </DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff = size=3D2><SPAN=20 class=3D890495418-26032008>Anyone ever see this error with Ingres 2006 = R2=20 ?</SPAN></FONT></DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff = size=3D2><SPAN=20 class=3D890495418-26032008></SPAN></FONT> </DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff = size=3D2><SPAN=20 class=3D890495418-26032008> 1> select count(*) from=20 s_verity_marc_xml<BR> where trstn_dte = =3D'2008-03-26=20 00:00:00'</SPAN></FONT></DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial color=3D#0000ff = size=3D2><SPAN=20 class=3D890495418-26032008>E_OP03A2 consistency = check<BR> -=20 histogram on s_verity_marc_xml attribute trstn_dte is = not<BR> =20 monotonically increasing<BR> (Wed Mar 26 14:43:07=20 2008)</SPAN></FONT></DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV> <DIV dir=3Dltr align=3Dleft><FONT face=3DArial><FONT = color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D890495418-26032008>Our version is </SPAN>II 9.1.0 = (i64.lnx/123)NPTL<SPAN=20 class=3D890495418-26032008>. The same query works fine with=20 2.6.</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D890495418-26032008>Is there a new optimizedb flag I should be = using=20 ?</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D890495418-26032008></SPAN></FONT></FONT></FONT> </DIV> <DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D890495418-26032008>Thanks</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D890495418-26032008></SPAN></FONT></FONT></FONT> </DIV> <DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20 class=3D890495418-26032008>Andre</SPAN></DIV> <DIV dir=3Dltr = align=3Dleft><BR></DIV></FONT></FONT></FONT><BR></BODY></HTML> ------_=_NextPart_001_01C88F73.592FFFE0--
