[mythtv-users] mysql query failing after upgrade to 5.5

John Marshall mythtv at marshallparty.org
Thu Aug 14 17:24:55 UTC 2014


On 8/14/2014 12:12 PM, Gary Buhrmaster wrote:
> On Thu, Aug 14, 2014 at 3:57 PM, Karl Newman <newmank1 at asme.org> wrote:
> .....
>> Thanks Mike, but I get the same results with or without the MIN. And I still
>> get NO results unless I remove the final "AND R2.starttime IS NULL" clause.
>
> recorded.starttime in my mythconverg database
> (and in the MythTV schema creation logic) is
> defined to be NOT NULL, and, as a primary key
> it would be silently promoted to NOT NULL even
> if it was not explicit.  I am not sure how you are
> seeing NULLs in the column list as you stated.

The NULLs are a result of a LEFT JOIN.  Column nullability doesn't apply 
here - every column in the row from R2 is reported as NULL because the 
row matching the left side isn't found.  He's checking for NULL because 
he specifically wants items where there's no match there.



More information about the mythtv-users mailing list