Incorrect result of SQL keywords LIMIT

[Echo9573]

The result of the SQL keywords LIMIT is incorrect. the reproducing procedure is shown as follows:

%%sqlflow
drop table if exists iris.train1;
create table energy.train1 as
select * from iris.train limit 0, 80;

drop table if exists energy.val1;
create table iris.val1 as
select * from iris.train limit 80, 90;

drop table if exists iris.test1;
create table iris.test1 as
select * from iris.train limit 90, 110;

The output is :

0 row affected
80 rows affected
0 row affected
30 rows affected
0 row affected
20 rows affected

Obviously, the result of iris.val1 is not correct, it should be 10 instead of 30.