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?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
