Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
None
-
None
Description
The following initial situation:
A small selection:
A Table (see at dump.sql):
| user | datum | ereignis |
|---|---|---|
| 1 | 2007-02-13 | Eintritt Maßnahme |
| 1 | 2007-03-13 | Eintritt |
| 2 | 2007-04-04 | Eintritt Maßnahme |
| 2 | 2007-05-02 | Eintritt |
| 2 | 2008-01-31 | Kündigung am |
| 2 | 2008-02-29 | Austritt |
When I execute the following Command:
SELECT * FROM |
(SELECT * FROM `userhitory` |
ORDER BY user,datum ASC) s |
GROUP BY user |
With Maria DB 10.0.17 I get the following result:
| user | datum | ereignis |
|---|---|---|
| 1 | 2007-02-13 | Eintritt Maßnahme |
| 2 | 2007-04-04 | Eintritt Maßnahme |
| 3 | 2014-07-01 | Eintritt Maßnahme |
| 4 | 2014-08-27 | Eintritt Maßnahme |
With MySQL Server 5.5 I get the following result:
| user | datum | ereignis |
|---|---|---|
| 1 | 2013-08-15 | Austritt |
| 2 | 2008-02-29 | Austritt |
| 3 | 2015-01-29 | Austritt |
| 4 | 2015-02-26 | Austritt |
The expected result is the MySQL 5.5 result.
Is there a bug?