[MDEV-7193] Incorrect Query Result (MySQL Bug 68897) in MariaDB 10.0.14 Created: 2014-11-24 Updated: 2015-02-17 Resolved: 2015-02-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.0.14 |
| Fix Version/s: | 10.0.16 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Evi Vanoost | Assignee: | Sergei Petrunia |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | upstream-fixed | ||
| Environment: |
Debian Squeeze |
||
| Issue Links: |
|
||||||||
| Description |
|
I was having issues where a certain query would not return the expected results. So I dug and found this: https://bugs.mysql.com/bug.php?id=68897 I can replicate the issue on MariaDB 10.0.14. Copy-pasta of a test case:
I would expect the DESC and ASC to return similar results, instead one returns a NULL value. |
| Comments |
| Comment by Elena Stepanova [ 2014-11-24 ] |
|
Thanks for the report. |
| Comment by Sergei Petrunia [ 2015-02-17 ] |
|
Indeed, this bug is fixed by the fix for |
| Comment by Sergei Petrunia [ 2015-02-17 ] |
|
Fixed by fix for |