Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
11.1.1
-
None
-
Windows 10 Professional 64-bit
Description
Just recently, I was advised to upgrade from MySQL to MariaDB for a much faster experience and ended up downloading Version 11.1.1.
I am writing some stored procedures that I can pass in parameters and perform a customised query. I have discovered a bug when it comes to the ORDER BY in the stored procedure which is not working correctly, but when I created the same sql select outside of a stored procedure, the ORDER BY is working correctly.
Attached is the stored procedure and the manual select alongside two jpegs to show the difference (from row 5 onwards) where the order should be in the order of the "Dayset", followed by "Depart", "Arrive" and "StartDate", but the StartDate is not sorting correctly.