Bug #30928 Wrong NULL results with combination of subqueries, views and ORDER BY

• Submitted: 10 Sep 2007 13:06
• Modified: 15 Dec 2007 8:29
• Reporter: Hartmut Holzgraefe
• Status: Duplicate
• Category: Server
• Severity: S3 (Non-critical)
• Version: 5.0.40-5.0.42
• OS: Any
• Assigned to: Bugs System
• Target Version: 5.0+
• Tags: regression, bfsm_2007_12_06
• Triage: D2 (Serious)

[10 Sep 2007 13: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 13:11] Hartmut Holzgraefe

mysqltest test case

Attachment: bug30928.tgz (application/x-gtar, text), 1.25 KiB.

[15 Dec 2007 8: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.