Wrong result selecting from simple view with LIMIT and ORDER BY

create table t1 (a int);

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

create view v1 as (select a from t1 limit 2) order by a desc;

(select a from t1 limit 2) order by a desc;

select * from v1;

MariaDB [test]> (select a from t1 limit 2) order by a desc;

+------+

| a    |

+------+

|    7 |

|    3 |

+------+

2 rows in set (0.00 sec)

MariaDB [test]> select * from v1;

Empty set (0.00 sec)