oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: zhanyue.zzy
5
#owner group: sql1
6
#tags: group_by
7
#description: 本case用于测试count聚合函数
8
##
9
--disable_warnings
10
drop table if exists t1,t2,t3;
11
--enable_warnings
12

13
select count(*);
14
select count(*) from dual;
15

16
create table t1 (libname varchar(21), city varchar(256), primary key (libname));
17
select count(*) from t1;
18

19
insert into t1 values ('test1','city1'),('test2','city2');
20
insert into t1 values ('l', null);
21
replace into t1 values ('2', null);
22
replace into t1 values ('test3','city3'),('test4','city4');
23
select count(*) from t1;
24
select count(city) from t1;
25

26
--error 1149
27
select count(t1.*) from t1;
28