Opened 17 years ago

Closed 17 years ago

Last modified 17 years ago

#4563 closed defect (fixed)

Scheduler ambiguous SQL query with certain custom recording rules

Reported by: taco_mel@… Owned by: Janne Grunau
Priority: minor Milestone: 0.21
Component: mythtv Version: head
Severity: medium Keywords: mythbackend scheduler power search
Cc: Ticket locked: no

Description

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.

Attachments (1)

myth-scheduler-recordid-sql.patch​ (606 bytes) - added by taco_mel@… 17 years ago.
Patch to mythbackend/scheduler.cpp

Download all attachments as: .zip

Change History (4)

Changed 17 years ago by taco_mel@…

Attachment: myth-scheduler-recordid-sql.patch​ added

Patch to mythbackend/scheduler.cpp

comment:1 Changed 17 years ago by Janne Grunau

Milestone: unknown → 0.21
Owner: changed from Isaac Richards to Janne Grunau
Status: new → accepted

comment:2 Changed 17 years ago by Janne Grunau

Resolution: → fixed
Status: accepted → closed

(In [16126]) make recordid unambiguous for custom recording rules involving tables with recordid

Closes #4563 From: <taco_mel[a]yahoo[p]com>

comment:3 Changed 17 years ago by Janne Grunau

(In [16127]) Merges revision [16126] from trunk: make recordid unambiguous for custom recording rules involving tables with recordid

Closes #4563 From: <taco_mel[a]yahoo[p]com>

Note: See TracTickets for help on using tickets.