[mythtv] Removing scheduled recordings

Joseph A. Caputo jcaputo1 at comcast.net
Thu May 29 00:08:53 EDT 2003

On Wednesday 28 May 2003 09:55 pm, Chris Pinkham wrote:
> > Okay, I've re-synched the patch.  It's as follows:
> Looks OK but I'm not sure about this one.  Have you tested this?
> > '2':
> > Flag this showing as a duplicate, even if it's not in the oldrecorded
> > table
> I didn't apply the patch but I'm not seeing the part of the sql query
> like this:
> 	oldrecorded.starttime IS NOT NULL AS duplicate
> could return a 1 if there aren't any oldrecorded records and the leftjoin
> is true because of the last part of your where clause of
> 	program.overridesuppression = 2
> Just curious if this was tested and works.  If you say so then I'll
> apply it to my tree and see about getting it in CVS with a UI to edit
> the fields sometime.
> Chris

Hmmm... seems like a valid point; I'm certainly no SQL expert.  All I can say 
is that I've tested it & it seems to work as advertised.  It does seem odd, 
though... think I'll do a little reading on JOINs and see why this works in 
spite of itself :-)


More information about the mythtv-dev mailing list