oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: link.zt
5
#owner group: sql1
6

7
--disable_abort_on_error
8
#
9
# Test of update and delete with limit
10
#
11

12
--disable_warnings
13
drop table if exists t1;
14
--enable_warnings
15

16
create table t1(a int primary key,b int);
17

18
insert into t1(a) values(1),(2),(3);
19
select * from t1 limit 0;
20
select * from t1 limit 1;
21
select * from t1 limit 3;
22
select * from t1 limit 4;
23

24
# netsed limit，用来测试limit算子自身的re_est_cost(...)函数
25
select /*+no_rewrite*/ * from (select * from t1 order by b limit 4) AS t2 limit 2;
26

27
#--error 1146
28
select * from t1 limit -1;
29

30
drop table t1;
31

32

33
create table t1 (a int primary key,b int);
34
insert into t1(a) values (1),(2),(3),(4),(5),(6),(7);
35
select * FROM t1  ORDER BY a desc LIMIT 3;
36
select * FROM t1  ORDER BY a desc LIMIT 0;
37
select * FROM t1  ORDER BY a desc LIMIT 8;
38
select count(*) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;
39
select sum(a) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;
40
drop table t1;
41

42