[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