[mythtv] [BUG] mythweb removes similar recordings that is should not.

[Martin Moeller]

For a while now I have used mythweb to find 'Top 10' music videos on
VH-1 and MTV and queueing them for recording. On each distinct Top 10
video I say 'Record only this showing'. The strange thing is that when I
simultanously looked in the database to see them show up, the last one
of two queued you be replaced with the one I just chose.

If I select them in mythtv they all stay there.

Example:

mysql> select title,chanid,startdate,starttime from record where title
like '%Top 10%';
+-------------------------------+--------+------------+-----------+
| title                         | chanid | startdate  | starttime |
+-------------------------------+--------+------------+-----------+
| Top 10 at Ten One Hit Wonders |     16 | 2003-04-10 | 10:00:00  |
| Top 10: Vintage Videos        |     12 | 2003-04-06 | 11:00:00  |
+-------------------------------+--------+------------+-----------+
2 rows in set (0.00 sec)

mysql> select title,chanid,startdate,starttime from record where title
like '%Top 10%';
+-------------------------------+--------+------------+-----------+
| title                         | chanid | startdate  | starttime |
+-------------------------------+--------+------------+-----------+
| Top 10 at Ten One Hit Wonders |     16 | 2003-04-10 | 10:00:00  |
| Top 10: Vintage Videos        |   NULL | 0000-00-00 | 00:00:00  |
+-------------------------------+--------+------------+-----------+
2 rows in set (0.00 sec)

mysql> select title,chanid,startdate,starttime from record where title
like '%Top 10%';
+-------------------------------+--------+------------+-----------+
| title                         | chanid | startdate  | starttime |
+-------------------------------+--------+------------+-----------+
| Top 10 at Ten One Hit Wonders |     16 | 2003-04-10 | 10:00:00  |
| Top 10: Vintage Videos        |     12 | 2003-04-06 | 11:00:00  |
+-------------------------------+--------+------------+-----------+
2 rows in set (0.01 sec)

mysql> select title,chanid,startdate,starttime from record where title
like '%Top 10%';
+-------------------------------+--------+------------+-----------+
| title                         | chanid | startdate  | starttime |
+-------------------------------+--------+------------+-----------+
| Top 10 at Ten One Hit Wonders |     16 | 2003-04-10 | 10:00:00  |
| I Wanna: Top 10               |     12 | 2003-04-07 | 11:00:00  |
+-------------------------------+--------+------------+-----------+
2 rows in set (0.00 sec)

mysql> select title,chanid,startdate,starttime from record where title
like '%Top 10%';
+-------------------------------+--------+------------+-----------+
| title                         | chanid | startdate  | starttime |
+-------------------------------+--------+------------+-----------+
| Top 10 at Ten One Hit Wonders |     16 | 2003-04-10 | 10:00:00  |
| I Wanna: Top 10               |     12 | 2003-04-07 | 11:00:00  |
| Top 10 at Ten Up and Coming   |     16 | 2003-04-15 | 10:00:00  |
| Top 10 at Ten Barely Dressed  |     16 | 2003-04-08 | 10:00:00  |
| Top 10: Latino                |     12 | 2003-04-13 | 11:00:00  |
| Top 10: Vintage Videos        |     12 | 2003-04-06 | 11:00:00  |
| Teen Idols: Top 10            |     12 | 2003-04-08 | 11:00:00  |
| Cover Songs: Top 10           |     12 | 2003-04-09 | 11:00:00  |
| Bottoms: Top 10               |     12 | 2003-04-14 | 11:00:00  |
+-------------------------------+--------+------------+-----------+
9 rows in set (0.00 sec)

This probably happens with other multiword searches as well, but this is
the only one I have tried. The above result is with CVS as of yesterday.
Commit time seems to have been 00:45. If it matters, I'm at GMT+1 here.

Does anyone else see this or something similar?

-- 
Martin Moeller <martin at martinm-76.dk>