oceanbase

1
drop table if exists t1;
2
create table t1(a int primary key,b int);
3
insert into t1(a) values(1),(2),(3);
4
select * from t1 limit 0;
5
a	b
6
select * from t1 limit 1;
7
a	b
8
1	NULL
9
select * from t1 limit 3;
10
a	b
11
1	NULL
12
2	NULL
13
3	NULL
14
select * from t1 limit 4;
15
a	b
16
1	NULL
17
2	NULL
18
3	NULL
19
select /*+no_rewrite*/ * from (select * from t1 order by b limit 4) AS t2 limit 2;
20
a	b
21
1	NULL
22
2	NULL
23
select * from t1 limit -1;
24
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near '-1' at line 1
25
drop table t1;
26
create table t1 (a int primary key,b int);
27
insert into t1(a) values (1),(2),(3),(4),(5),(6),(7);
28
select * FROM t1  ORDER BY a desc LIMIT 3;
29
a	b
30
7	NULL
31
6	NULL
32
5	NULL
33
select * FROM t1  ORDER BY a desc LIMIT 0;
34
a	b
35
select * FROM t1  ORDER BY a desc LIMIT 8;
36
a	b
37
7	NULL
38
6	NULL
39
5	NULL
40
4	NULL
41
3	NULL
42
2	NULL
43
1	NULL
44
select count(*) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;
45
c
46
7
47
select sum(a) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;
48
c
49
28
50
drop table t1;
51