[314]: numeric overflow ?

[Former Member]

Hi,

I try to understand ...

I want to aggregate some values, but i've got this error message :

[314]: numeric overflow: search table error:  [6944] AttributeEngine: overflow in numeric calculation;JEAggregate pop1(setIndex('TEST:F_EXPORT','en'),setAttribute('MT_VALEUR'),setAggregationTypes(1))

SQL is :

SQL
select cd_pays,sum(mt_valeur) from f_export group by cd_pays

I work with AWS

max() returns values..

[Former Member]

would you mind posting your table definition? I still stick to my initial assumption, but after some testing I can say that it works fine (on Revision 36) at least for the data types I tested (tinyint with max_value = 255 and decimal(3) with max_value = 999) - this works fine and returns [A, 300]:

create column table foobar(

  foo varchar(1),

  bar tinyint

);

insert into foobar values('A',100);

insert into foobar values('A',200);

select foo,sum(bar) from foobar group by foo;