> On Tuesday 31 December 2002 10:21, Walter Procopio wrote:
>
> > I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server
and
> > I have created a database with this schema:
>
> [skip]
>
> >
> > And I try to execute this query:
> >
> >
> > SELECT ecoras.rstda, ecotes.rstes, ecoras.rsart, ecoras.rsimm,
> > ecorub.rsdes, ecoras.rstpg, ecoras.rsdat, ecoras.rsrub
> > FROM ecoras, ecotxt
> > LEFT JOIN ecotes ON ecoras.rstcd = ecotes.rstcd
> > LEFT JOIN ecorub ON ecoras.rsnum = ecorub.rsnum and ecoras.rsrub =
> > ecorub.rsrub
> > WHERE ecoras.rsori = ecotxt.rsori
> > AND ecoras.rscod = ecotxt.rscod
> > AND (rsdat >= '2002-12-01') and (rsdat <= '2002-12-23')
> > AND (match(ecotxt.rstxt) against('JAVA' IN BOOLEAN
MODE))
> > ORDER BY ecoras.rspst, ecoras.rstda, ecotes.rstes, ecoras.rstpg,
> > ecoras.rsart
> >
> >
> > I have no data in my resultset, but data-base contains data which match
> > conditions.
> > If I excute the following query I have a valid resultset.
> >
> >
> > SELECT ecoras.rstda, ecotes.rstes, ecoras.rsart, ecoras.rsimm,
> > ecorub.rsdes, ecoras.rstpg, ecoras.rsdat, ecoras.rsrub
> > FROM ecoras, ecotxt
> > LEFT JOIN ecotes ON ecoras.rstcd = ecotes.rstcd
> > LEFT JOIN ecorub ON ecoras.rsnum = ecorub.rsnum and ecoras.rsrub =
> > ecorub.rsrub
> > WHERE ecoras.rsnum = 0
> > AND ecoras.rsori = ecotxt.rsori
> > AND ecoras.rscod = ecotxt.rscod
> > AND (rsdat >= '2002-12-01') and (rsdat <= '2002-12-23')
> > AND (match(ecotxt.rstxt) against('JAVA' IN BOOLEAN
MODE))
> > ORDER BY ecoras.rspst, ecoras.rstda, ecotes.rstes, ecoras.rstpg,
> > ecoras.rsart
> >
> >
> > In this query the where-clause matches the primary key (index) of ecoras
> > table:
> >
> >
> > ecoras.rsnum = 0
> > AND ecoras.rsori = ecotxt.rsori
> > AND ecoras.rscod = ecotxt.rscod
> >
> >
> > If I do not use an index, I will obtain slow performances, but I must
have
> > always a
> > valid resultset like in the second query.
> >
> > Is it a bug or a join-condition has to match an index?
>
> Could you test it with latest version of MySQL server (4.0.7)?
> Could you provide some data for testing?
>
>
>
I have tried the release 4.0.7 and it is ok. It solves another problem I had
using full text query.
Thank you.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
