[MDEV-25679] Wrong result selecting from simple view with LIMIT and ORDER BY - Jira

The following test case demonstrate the problem:

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)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server