create table t1 (a int);

insert into t1 values (1), (1), (2), (3), (2);

select * from t1 order by a offset 2 rows;

a

2

2

3

create view v1 as select * from t1 order by a offset 2 rows;

select * from v1;

a

1

1

2

2

3

show create view v1;

View	Create View	character_set_client	collation_connection

v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` order by `t1`.`a`	latin1	latin1_swedish_ci

drop view v1;

create view v1 as select * from t1 order by a limit 2 offset 2;

select * from v1;

a

2

2

show create view v1;

View	Create View	character_set_client	collation_connection

v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a` from `t1` order by `t1`.`a` limit 2,2	latin1	latin1_swedish_ci

drop table t1;

#enable after fix MDEV-29645

--disable_view_protocol

...

--enable_view_protocol