odbtools/odbctest/mql/basic/10memdb/32.aggr2.mql

insert into /test/basic2 (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values ('2', 'hhhhhh', 1, 1534567890123456789, 1.3, 2.1234567890123456, 1.223456, true  )
;

/**
sleep(1s)
**/
;

select count(*) from /test/basic2 group by v_varchar
/**
count(3)
**/
;

select sum(v_float), min(v_int), max(v_double) , avg(v_int) as avgint, v_varchar from /test/basic2 group by v_varchar
/**
count(3)
**/
;