Bug #12174 Instead of nulls previous row values being returned when joining 2 tables
Submitted: 26 Jul 2005 10:18 Modified: 27 Aug 2005 14:40
Reporter: Sanjay Mistry Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:3.23.32 OS:Windows (Windows NT)
Assigned to: CPU Architecture:Any

[26 Jul 2005 10:18] Sanjay Mistry
Description:
Instead of nulls previous row values being returned when joining 2 tables...Returning all values from Siebel.tbBigMedia_CampType but following fields returning previous values ?
(bm.nLeads),
(bm.nInfoReq),
(bm.nApptReq),
(bm.nApptsmade),
(bm.nFirstVisits),
(bm.nSales)

How to repeat:
SELECT

bm.sDistrictID,
Case When Type.sCampaign='Energy' Then Type.sLevel1 Else Type.sCampaign End,
(bm.nLeads),
(bm.nInfoReq),
(bm.nApptReq),
(bm.nApptsmade),
(bm.nFirstVisits),
(bm.nSales)

FROM
Siebel.tbbigmedia2005 bm
Left Join Siebel.tbBigMedia_CampType As Type On (bm.sCampaign=Type.sCampaign)
Where
bm.sweekid = 'Week29' And bm.sDistrictID = '1+KE+4'

ORDER BY
bm.sDistrictID, Case When Type.sCampaign='Energy' Then Type.sLevel1 Else Type.sCampaign End
[27 Jul 2005 14:40] MySQL Verification Team
Dear Sanjay,

Thank you for the report, but we need repeatable test case to reproduce the problem. This means we need structures of all tables involed into SELECT and test data.
[27 Aug 2005 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".