I've submitted a ticket with a patch which resolves this issue.<br><br>- Mark.<br><br><div><span class="gmail_quote">On 2/7/08, <b class="gmail_sendername">Allan Stirling</b> <<a href="mailto:Dibblahmythml0015@pendor.org">Dibblahmythml0015@pendor.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Mark Buechler wrote:<br>>> # Query_time: 11 Lock_time: 0 Rows_sent: 0 Rows_examined: 0<br>>> DELETE FROM program WHERE manualid = -1 OR (manualid <> 0 AND -1 = -1);<br><br><br>Since manualID is unsigned, this does not make any sense to me?<br>
<br>It is also the reason MySQL doesn't use the index - If you run:<br><br>mysql> select * FROM program WHERE (manualid <> 0 AND -1 =<br>-1) and manualid=-1;<br>Empty set, 1 warning (0.83 sec)<br><br>mysql> show warnings;<br>
+---------+------+-------------------------------------------------------------+<br>| Level | Code | Message<br> |<br>+---------+------+-------------------------------------------------------------+<br>
| Warning | 1264 | Data truncated; out of range for column<br>'manualid' at row 1 |<br>+---------+------+-------------------------------------------------------------+<br>1 row in set (0.00 sec)<br><br><br><br>Cheers,<br>
<br>Allan.<br>_______________________________________________<br>mythtv-dev mailing list<br><a href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</a><br>
</blockquote></div><br>