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

Karl Newman newmank1 at asme.org
Thu Aug 14 00:13:27 UTC 2014


On Wed, Aug 13, 2014 at 4:44 PM, Tony Sauri <hoiho.nz at gmail.com> wrote:

> On 14/08/14 09:13, Karl Newman wrote:
> > ND C.commmethod != -2) LEFT JOIN (recorded AS R2
>
>
>
> I can't exactly duplicate your experience because of missing categories
> in my EPG but my reading of MTSQL manual seems to indicate that that
> LEFT JOIN of your should be
>
>         LEFT OUTER JOIN
>
> HTH
>
> Regards
>
> Tony Sauri
>

Tony, as far as I can tell the LEFT JOIN is an implied LEFT OUTER JOIN. The
OUTER keyword indicates to return NULL for columns where there is no match
in the joined table, but the LEFT JOIN is doing just that.

Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140813/0ac538f5/attachment.html>


More information about the mythtv-users mailing list