[mythtv] Re: [mythtv-commits] Re: Ticket #76: mythgame makes two Calls to the Database when only one will do the job.

[Isaac Richards]

On Saturday 09 July 2005 05:14 pm, Robert Johnston wrote:
> On another note, and as a complete aside, what is the deal with all
> the SELECT NULL's going on in MythTV? It seems whenever Myth wants to
> do ANY action on the DB it tries a "SELECT NULL" first. Is it checking
> the DB is still alive or something?

Yup.  The mysql client library tends to not reconnect nicely if the connection 
has gone stale.  So, instead of littering the code with bits to retry the 
query if it failed, it does the 'SELECT NULL' up in the base classes.

Isaac