Bug #30928 Wrong NULL results with combination of subqueries, views and ORDER BY
Submitted: 10 Sep 2007 11:06 Modified: 15 Dec 2007 7:29
Reporter: Hartmut Holzgraefe Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.40-5.0.42 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: bfsm_2007_12_06, regression

[10 Sep 2007 11:06] Hartmut Holzgraefe 
Description:
This might be the same problem as in bug #28337, #28378 and #28526,
in this case it only shows when wrapping up a subquery in a view though
but not when putting in the view definition query instead.

So i'm reporting this anyway to make sure this problem was indeed
fixed and did not just disappear at random, lurking to come back
again later ...

How to repeat:
see attached test case

Suggested fix:
None if this was indeed the same problem as in Bug #28337
(adding the test case to the test suite might be a good idea though nonetheless).

If this is *not* the same bug then some extra investigation
on what caused this in 5.0.40 and what fixed it in 5.0.44 ...
[10 Sep 2007 11:11] Hartmut Holzgraefe 
mysqltest test case

Attachment: bug30928.tgz (application/x-gtar, text), 1.25 KiB.
[15 Dec 2007 7:29] Igor Babaev 
This is a duplicate of bug #28337: I rolled the changes of the fix for this bug back and got exactly the results reported by Hartmut.
I checked this with the current dev tree 5.0.54.