Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13928/src/test/BugTracker-2009/Tests
Added Files:
avg-bug.SF-2132666.sql
Log Message:
propagated changes of Wednesday Feb 11 2009 - Thursday Feb 12 2009
from the Feb2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/02/11 - nielsnes:
src/test/BugTracker-2009/Tests/avg-bug.SF-2132666.sql,1.1.2.1
add test for bug about avg on small ints and integers
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: avg-bug.SF-2132666.sql ---
CREATE TABLE car (
age int,
gender char(1),
price bigint,
category varchar(20),
class varchar(20),
codville char(3),
sage smallint,
iprice int
);
insert into car values
(2, 'm', 123, 'a', 'b', 'c', 1, 1),
(3, 'm', 123, 'a', 'b', 'c', 2, 1),
(4, 'm', 123, 'a', 'b', 'c', 3, 9),
(6, 'm', 123, 'a', 'b', 'c', 8, 1),
(8, 'm', 123, 'a', 'b', 'c', 9, 1);
select count(*), gender , sum (sage), avg(sage) from car group by gender;
select count(*), gender , sum (age), avg(age) from car group by gender;
select gender, count(*),sum(iprice), avg(price), avg(iprice) from car group by
gender;
drop table car;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
