FYI: So called "SUM-Bug" in Informix 7.3
Posted in 1998
It was brought to my attention yesterday by one of my co-worker about what they call 'SUMBug'. Here is how the bug can be reproduced. 1. create table x (d decimal(4,2)) 2. insert into x values(99.99), say 500 times. Now select sum(d) or avg(d) from x will cause sql error 1226. I could produce it in 7.30.UC3 on Solaris 2.6. My co-workers have produced it on HP-UX platform. This has been reported to Informix and version upgrade is available. Please see the attached posting, thanks to a real guru from Informix. Hope this helps..... Idiot. begin 666 infxbug.zip M4$L#!!0````(`'QM6R6=X389D\\H``(Q.`@`,````8G5G.3$S-# N:'1MW?U; MLV?7=>6)/9L1^@['[(AJ,B+_AWO=UZ+$BH"(5 DV2; )4*+\\4@$"20C=(,#" M11>[_=T]?F/N0ZI*Q,R2'_Q@=J-TD,C<N?>ZS.N88_S5W[Y^Y]W__!??^ZL/ MW_OP9Z__\\V^__?0/3Z>T?OW5C^)7])]^]/)[_OK]=_^!__NW];_[C?K7O_KE MK_BM?_WMIS]^BE]^TJ_\\]+T/WGO_%T]_]\\[/?OWZ@Z>_>?]73Q_\\^N?_ZP=/ M[_SJ]=.'[[__],'/W_G9S_SKOWK]SL_>^^##]W[Z]+_]^O6OWGO]P5]\\[]V/ MOGGSXZ=RSGY<[5':TT_U"Y]^^=6__OCI_5_\\[+U?O'YZ^HOO??BO?]!O^N#O MGYZ>/OCVM[__[)MOWGSUXZ???OG%1U^_^>HC?L=/O_S]'[[\\XLT7W_SXZ9V? MO?.KGS\\]O?Z[U[_X\\/Z7#W[]UQ_\\PP<?OOZYODKO\\?.GG[_^\\&_??_<GW__E M^Q]\\^/VG=W[ZH3[@)]__T<>??O;X[6=?_.C_^.TG7S[K7[[/,GSP^F>O?_KA MTR_>^?GKGWS_LV_>_/[K[S]]\\-[_X_5/!O_U_5]^^,>/_\\GW/_KF\\X^^_L/3 MZK.V]OW__,[]T],_?O2U__GJS<?_],G31[][>O/%IY]]\\>;ID\\\\^^>)__>;I MTR^?/OGRG[]X>CS]_J///O_LBT^_\\\\&CG+[\\8/_T5&KEG_GTYJNOOOSJZ<LO MGKY^\\_F;C[_Y[@>,>IUX`#\\]K>?&/]>O?]I^4Y^^_O;WO__HF\\_TF#?_\\O&; M3]Y\\_?2[S_[ES2=/__31Y]^^^?J['WJNMN.A_/3TTV^_YI]OOOS]FZ^>/GWS MS3?ZI*>/_NV+_OCIDS<??_;[CS[WH[_SP?/J*];1/_T/GYO\\L=GW_<?TT]-O M/OP5_[Q^_>.GO__HJR_T-C_65OSAJS=?Z\\3$]W[]V?_SS5-_^KW>^NGWR8-/ M>WFP?OH?WN?KIW_^QS=?/'WSU;\\^??/ET[=?OWGZZ)_TW9]^^M6;3W6JM3O? M_>!2VA4/YJ?_<5^__9H5U.[\\X(?)(\\[U\\@C]I)OR>_^CC_O=9V\\^_^3IT\\_^ MB:?XL;_[ZLO?/_WS9]_\\XV=?/'WRVX\\^_CC9W5GKU>/!_/3TAZ^^Y)_??O[F M]T]???L%RZF_A%]YDSUC_O$9L_]/;^09,TZK?WIZE,H_<_BDZ^/T^I]](6N@ M4_3T@X\\_??/1TU=??OR/;_3?OGKZUV2]U]7O>^2?GC[X\\G/^^>BKS[Y^JL_S MU?OO?G#?BE>LN@[K#_[PZNL?_O#IRW]Z\\]7O/O_RNQ]<RHHW]D]<Q_M*^GU? M3GW^V:NT<=T/T4__=BM?'O#'+=4=_?C++_167_O:YL\\=9<?Q]4]/?_WF&_[Y MZ.F_Z79S#;[VF?";ZF&R_F'EO_N!^ZKW,O+3T^NOON(?G5AOKI[QQ]-_/_I^ M_Q_]7M;Z7Y/G]E7OY^JG/V/F_G2K?O?M%Q_[W;_[:6?O.'S^Z4G^R__\\+^6Z M^MBOGG[Q1C9.5_:W;W2:/O[\\VT_TKSI9G(#G7_]T?N>#][7[\\(/]T[_=;*VH MS( _V9]Z;]CCX>_X[B?JE6)!_=._6="'OU^VA>NF=_WHZZ\\_^U3K$+;9OZ+% M_>X'MUK#DOJGIU^]^9A_WN@`?7*OJO^"__3?OOWRF[]\\.67ZU7A[W,&;3[[[ MZ;(Y<;#\\T_^X7[8V_=//,1N??O71O[>O$6>,6>;W__.[\\0/N_^GVO8HG?O#3 M]W_VZY__XH?OOOX;!07O/KWSP=.[BCP46OS@EZ\\^^.'3W[_WYQ^J5:SX@G?O MG^*Q>MX/G][_FZ?W?O'AZU_IM\\<?>?HOKS^\\S<O?_^WK7RA<^>#7/_O.Q^KD MW(_53__V;=_YN__R@[]Y[_7/WOWAT]_\\ZOV?/WWXSE__[/5?ZFD?_OI7OWAZ M_:M?*1(J_^ZQV,\\_/.UQ<'B_C!_\\U/](A$48%V]!;/+>+W[YZP^?/OR'7^KQ M7SMN^O[+W_9WG[WYYZ???/7F=]__ST^ZM_ST]8^??O#7/]&]>/7N3][]]@_\\ M\\,N?_#+L_*N?_N2GBK5>O?.3=]CQ)__+W_SD;]Y\\],VW7[UY]>%//GSS\\3^^ M]\\7OOOSA7_V(`$M_NT*[-U]__-5G?^!N_O@OOO?WN,:/%:9]>T<#-C*_>_KZ MHW_5O[SLY7Y5?ZC?]?FWO__BU=,W,N0?_&\\_>_K\\HW]]@P_$1_%K<MP??V9S MIS__O^.Q=4;UO(__\\>FC3S[Y[)O[OWSSSU_&+\\;SOM:5\\2/E]K_]7!'2'Q_S M_/3A/\\KN?_R1[.='7W_V^;^^6/E_C@NL/_>Y8L[/W_!3N>1B_OEKV8=XF6\\^ MT@(]/[WWQ=-O?OF!GJ\\'_?-'+W'3;_5MG__S1__Z]>W!^0.__^A?/ON]OOV/ M?_U??.]WNB/:T3O,>G[Z&_V[%NBCW_]!?^?O%!)JD1U/\\.=_]^7G>C/'`U[> M9];Z0_V'C[_\\A-_QT3=/7^BN?HU)^/@?/_KB4QDU7O?IZ__V^8^^_F\\RG,\\? M$ZA\\%8_SG_KHJR^__>(3?:76L:SKQSSRZ<WG^AL_^]W3#][[0-O#,?K!-S]4 M_/'T_](_?_CXVZ^TKH__].DW?_GQ)_]5RZ[=][]]\\LG'__4;!>Q//WGZYB_? M^CL_UZGX"7_9O[ >/_C\\U>>OWO_E?WWGW7=?:>?O4_%O?OPA3_Q_WR_W'WF5 M/SV")_!5/_CU!Z]_):OR,WW5TT_\\.S[XN0S"T__Y?S[]^_\\4_T%_]-__IW?? M^?#U#Y_^DW;K+_W_Z#?]7Q7X_>[SCS[]X?_<]_N.__R=__OK'Y3YZO(WWM_W M'_W#=8P_+M%OOWKST?_QEVSEU__XY;=R/G)O<2!P=O^_WN,_O6:KK_A9?]\\/ M/O_A_[]OJ#[V__L-U1_^\\QM*\\O+E)]]^?-O6O_C>_T7V]\\O;>;_[U9=_^(-M M[!>R9-KW3SZ2D9+%CO^LWWQ'_%\\KX7P\\_:?/O_E+_GEZ_?[?\\-_TI__X)Q0" M?OVO_ G_M__^K_FIWL:F_ NYDC_^@8^^('126N[_Q"__3_VM'_.P-__N[_W3 M?[&9??KFZ0?Z)4<Z']M7O.)??WO_:XM__=C_>E[^ZR?WOS:?-?U*O!YYPY=Z M8-C<'^Q^]3V>VWCUU,J>YWGO^>KI,?3KYZK/1;\\^#[[^>6R>\\^>?4F8;?<3O MOGKA-U<]\\"AYW>6YGE=/]>Q1Q_,:W_V0/59;Z_GT5T^[S[Z>]8C1ZCCS>EZ* M5L^N:U3%IO.[GS&OO<IXKD5_^]4GK\\2/>W5E4L^S\\WY-4=;S:"5YRE#$M)\\; MWS#WU?1.C44I<YQSGNOB7TXYHS\\K,?SNYXRC/_Y<M:#[E'Z>^]%GU#U[:5IH M_;(BJ+[/\\QGGNQ_2UAQ#B\\C+7%<KSW-J/8=>A25GG7=1]#F?=T]>15_0SGCN M^NUSS/ZL_.85&7/3RSRWXY]'W\\_]2G:H:U]:\\ZN,NK>.QZLG#LUJSYME+GVL M\\GQFMLF7WJ1H)?2(I5/S7#>G0R]2]>3"RBHOW5K8GFS0NLJLW2\\RE_:G'7U- M+;OT6F/SQU5K>2ZG)KO<M#OEF9-_S?7<NT[':7J*SOVYM*RK*/M^UC_)BHRA M>^(%G$=WX'FWS0HKF.:/ZG/J:J7L9_W'Y"FK%QUL_>[2]^0G_N"8>VWMJI9D M]>J%'\\E#](>X-$U?/W6E^=V%IUR'E>!6U75=NDO:YF1_YKCVY2N[FS;T64=+ MAT/?P,?QF:7(4.BUDNUIJXZ]=-GU$#U.:SST)UMOU^$6\\FRMAS;Y9$;E;/V= MW?NSO3R3RZ,MU>49W*DRNW[L/;$'C[[*YIIJ5W1?=1LY8C(TNLK]N6B72SG7 MD:VI+3ENLF2Z@MPUUE._F[^_Z0943(E^N5]*^RXMUI6\\2SVZ'\\V'I95+UV=S M@$\\IG7N@)QX=?/W86G)J:[]FZSXL>MKFJ%YA#JI^^?#+K8QKZD,SH])66?.Y M:W$?4V=V/T_L2YEE::EYEUE'F[K+B4W9>I,25G_5H_.^,2]G:-=DQSMG^+0] MG^>UDE71BV.;N[ZBM:MH?=B6U>1&],CCM=4&/,N!)*_2RM'%P4R/T_7Q.+0C M%R";+9>FA\\@VC?6\\1W)8RK76T'[Z'E9YJWWY3SJ!]O?T,M>11<_.2EDR]OHM MKRB[Z N65W;I`"U]!$=HG\\&/.WE*D]]LS]R:AUYIR=*V"PNW^IG%;[ATUG3B M5G:9JWRNCOSF'LHBRNSRE*,KN602:N>#>([,<;)#8W);GB=7:%<=BH%=>]2K MZ5VVMY^?909K28S"HV@_='<PK>V2@9 STFJLHQ-WZ=#C&FO7S7Q6&)!8;1DY MKHL/_913Y<@7#-2T59!KT)O,Y :U:UTSC-G10=775Z_S;I.5Q@WH(8J#GLM. MKI#.Q#5DS;!/M>K ^S8_= W7Q2U?X=;TH]Q]<EZ&K.5ELU3&)KKP&5E[\\VHL MNKS:X:XF&_W M,I9+&]IK7KU"]_(]DX65)]Z]N:G9&'<6@E;V7EU'0N\\AF(Y M7P:<?:E+CTZV1Z?Z:.4:]GGH](5_WS1(GK$JNJ@XN"LY*%I!? /!FDR0S-'! M\\G?9<<5<S]0MZR63<.DDI4_94T$1?W3H!.NU?0T5* W=&@<.:XRAYR5[K$_= M? -'Y8H+Q+8J5NF]/@^'/XI*92<S8UOFQ4D9Q"C]R#0WKN'4HNYV.5RAP8#= MS0Z*C.NJS<?S*.I4',ANKRWKI/NPL)EK+J*$DAC*.;4N6CKV1XY>2\\']F9R. MHS7W%LE)ZP!EL8;,JN(D'6R'ZI6SWYTHZ!#J+,<-JD2MJ>F7^R8V(<11='H1 ME6-9%/;H48K>-HZ%CI^^.GN;,QI!&":W8=EZ)P@K"F"T>9SA-;96ZSD+D.?0 M7[2>[85F=32MW=72ZF_'@++E6KB9>?AY5?TM'+DC-ZUC/@E%%;4=14,#C]05 MR1P=_\\0>3 6EPSNQCJ)Q&37'RCK$:X3EUQF2G>@E.W(**IX++S(5LLOM8)J6 M@B[E8<YK=,&U4"T[MOVZMNPK]EVF3C9JLB2Z2BRR38T<&6;W),LJ']$N)PJ* M263]"YOZ&-KHILMLH]>70K&>N@YE./K_GF=S_*E;,(;?2D&"#AD;+UN,)5^I MY]!7=)O41]U7UTW9#KK:($KAU'9Y`.UWZUGH=#A8-MBGLB<-RR+7U<M+!*+S MH\\-\\:OJ4>6'-+K9",>WSM!_50RIARB+SU)U4M#Z3B*7J;5E4MD6QEIP1'Z&( MP9?9R<?"+V?YY5(>IA<G8%$RH_AG+:^M?#Y9JM<6!Z>$-;F#A#J*XC")<EP* M;R:)B+Z@Z3O#I9#(*T*=V;LHUU7TAC%3%$L8A9N7*5?H\\%R<@VO-Y1R4"2=^ M3!=5@7&S65'(I%O3?5KT9L]<2<5PBL>4`^=&6VZ7$TI$)R?$N6FZD?K_??B7 M#HM>)/% 1X[]V&$M0I:Q'+/KI&(Z<0;RAD0*62K5E;?+>'1G*CIN\\C240F3S M%9<^=_:XK7&M_)S(27'$CPL:NM8Z[,=N5)FJHTR]FRRZ-BWY'NV(L@8GF(KV MM J#D& I]-BM.@QKK6GW9I8SG*T@5M]#7*._7\\O#%C]FOUJOVU'34!*LG+YG M%9I!?'SN@I,S*<*")ANPCS^HQ[>=FH4(!+\\]B@ZS7$25L47*8'3><<P/77#% M525-@W97XA#[+!="*G4Y^3BM1)E'M[$,(KLLV^U=9\\N1R4,6A>B?W=5E5++9 M'&;J'0_[-9.SKXNJ'$Y>G=^N'Y78XL?D2G1E7+F2%2<EES-(#K_L(]D?'G47 MRCL7L<XE5X]A(1RBC"4G5#.72JE'SL=)E%++9\\*>52Z*7BX.3-TQOGDD#^F\\ M^?2Z#"6XLB:8[,F%XBI7^2A98Z4TR2,4C+"Y^AN'C/2,Q(-\\1%&';A2&5Z=( M2?"JR26255/X[#CRH8!I$;1CXW1R%A_$"VZ.M'+A9(,4F<LA\\CDD/LK"''+L M<O5M'S0I><IFU>2+.""DI#AU;;+<)_Y0UEZIYW3D+$-Z*812#):LBV);'4L[ M&R6\\V@CNMK98'CN>(MO2B"BS`\\<G5Q<U=!&ZK"I7L2E"7-3BMD^_@L[GDH4) MA_0]@EM975V;2LSMLZ_3',F\\;(X.4Q9_50IYD32Q0[=QT2&\\BH)^(H^NDZ,8 M8%Q9H*W??UQQ5A2%EU@.W!87B-+-FK*]>=E)EO$<IUV*P_@`GW:=<Y[!]9E1 MJNQ98J@C/JIKG(\\AK_/,4BHKE*%PQ%