oceanbase

1
drop table if exists t1,t2;
2
CREATE TABLE t1 (pk int primary key,col1 double , col2 double);
3
INSERT INTO t1(pk,col1) VALUES (1,-5.00000000001),(2,-5.00000000002),(3,-5.00000000003),(4,-5.00000000000);
4
select col1,count(col1),sum(col1),avg(col1) from t1 group by col1 order by col1;
5
col1	count(col1)	sum(col1)	avg(col1)
6
-5.00000000003	1	-5.00000000003	-5.00000000003
7
-5.00000000002	1	-5.00000000002	-5.00000000002
8
-5.00000000001	1	-5.00000000001	-5.00000000001
9
-5	1	-5	-5
10
DROP TABLE t1;
11
create table t1 (pk int primary key,col1 double , col2 double);
12
insert into t1(pk,col1) values (1,-5.00000000001);
13
insert into t1(pk,col1) values (2,-5.00000000002);
14
select col1,sum(col1),max(col1),min(col1) from t1 group by col1 order by col1;
15
col1	sum(col1)	max(col1)	min(col1)
16
-5.00000000002	-5.00000000002	-5.00000000002	-5.00000000002
17
-5.00000000001	-5.00000000001	-5.00000000001	-5.00000000001
18
insert into t1(pk,col1) values (3,5.00000000003);
19
insert into t1(pk,col1) values (4,5.00000000004);
20
select col1,sum(col1),max(col1),min(col1) from t1 group by col1 order by col1;
21
col1	sum(col1)	max(col1)	min(col1)
22
-5.00000000002	-5.00000000002	-5.00000000002	-5.00000000002
23
-5.00000000001	-5.00000000001	-5.00000000001	-5.00000000001
24
5.00000000003	5.00000000003	5.00000000003	5.00000000003
25
5.00000000004	5.00000000004	5.00000000004	5.00000000004
26
DROP TABLE t1;
27