[MDEV-19324] Wrong results from query, using brackets with ORDER BY ..LIMIT - Jira

CREATE TABLE t1 (a INT);

INSERT INTO t1 VALUES (10),(20),(30);

SELECT a FROM t1 order by a desc limit 1;

(SELECT a FROM t1 order by a desc) limit 1;

MariaDB [test]> SELECT a FROM t1 order by a desc limit 1;

+------+

| a    |

+------+

|   30 |

+------+

1 row in set (0.002 sec)

MariaDB [test]> (SELECT a FROM t1 order by a desc) limit 1;

+------+

| a    |

+------+

|   10 |

+------+

1 row in set (0.001 sec)

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

MariaDB Server