Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
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)
|