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: optimizer, create_table, insert
7
#description:
8

9
#
10
# Test of count(distinct ..)
11
#
12

13
--disable_warnings
14
drop table if exists a1;
15
--enable_warnings
16
create table a1(rowkey_suffix int primary key, price int) ;
17
let $1=100;
18
let $2=200;
19
disable_query_log;
20
while ($1)
21
{
22
 eval insert into a1(rowkey_suffix, price) values($2, $1);
23
 dec $2;
24
 eval insert into a1(rowkey_suffix, price) values($2, $1);
25
 dec $1;
26
 dec $2;
27
}
28
enable_query_log;
29
select count(distinct price) from a1;
30
--replace_regex /Plan signature: [0-9]*/Plan signature/
31
--disable_result_log
32
#explain extended select count(distinct n) from t1;
33
--enable_result_log
34
#drop table t1;
35
drop table a1;
36
# End of 4.1 tests
37