id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
4563	Scheduler ambiguous SQL query with certain custom recording rules	taco_mel@…	Janne Grunau	"I had occasion to write a custom ""power search"" query that includes a table containing a column called 'recordid', and this makes the 'recordid' of the resulting query ambiguous.  Here's what was run within MySQL:

INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime,  IF(search = 5, '''recordid''', 0) FROM (record, program INNER JOIN channel       ON channel.chanid = program.chanid)...

A patch for scheduler.cpp is attached to qualify that with the appropriate table name."	defect	closed	minor	0.21	mythtv	head	medium	fixed	mythbackend scheduler power search		0