[mythtv] Re: [mythtv-commits] mythtv commits

[Isaac Richards]

On Tuesday 01 June 2004 03:23 pm, David Engel wrote:
> On Tue, Jun 01, 2004 at 01:27:15PM -0400, Isaac Richards wrote:
> > On Tuesday 01 June 2004 01:12 pm, David Engel wrote:
> > > It looks like this is a non-starter for now.  IMO, phrase searching
> > > would be a requirement and that wasn't added until MySQL 4.0.2.
> >
> > Well, as soon as redhat puts out a distribution with 4.x, I wouldn't have
> > a problem upping the minimum mysql version to 4.  Dunno when that's going
> > to happen, though.
>
> Hmm, there's only a couple of fairly localized places in the code that
> would be affected (ProgLister and Scheduler).  I could make the type
> of search used configurable by adding a backend setting or detecting
> magic characters in the search string.  The former would be safer with
> the default being mysql 3 compatible.

We could possibly also just run a 'select version();' query when the db is 
opened and store it in the MythSqlDatabase class, if you wanted to 
automatically detect what query type to use.

Isaac