[Info-ingres] Loading stats generates warning W_OP0973

Steve s.anderson.au at gmail.com
Thu Jul 29 03:15:51 UTC 2021


Hi folks

Recently I generated tables stats in our DR environment, writing them to a file rather than the System Catalogs - that sounds awfully like the Ingres documentation :) - using the -o optimizedb flag. Later when loading the stats into our production environment, I received several W_OP0973 warnings.

Searching the Actian website, it seems the issue re warning W_OP0973 was fixed in 9.2 - below is the note from "Patch 14296 for Ingres 9.2 Service Pack 1 (9.2.1) on Sun Solaris UltraSPARC":

"Bug 122605 (GENERIC)

optimizedb generates incorrect exact histogram cell counts for date columns. Loading these stats via optimizedb will generate W_OP0973 warnings."

(NB: Am running Ingres 11.0 on Solaris SPARC)

Should I interpret these warnings to suggest the bug may not be fixed? Should I be raising this with Actian? 

Further, all but one of the columns with this warning are ingresdate columns. The exception is column defined as a float4.

Thanks
Steve


More information about the Info-ingres mailing list