Is this a bug?

Is this a bug? The boolean search does not work?

SELECT AU,ST,BT,AT,id FROM ccl.ccl_main WHERE MATCH
(TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO)
AGAINST ('"ready maria"' IN BOOLEAN MODE)
ORDER BY id desc

I run a search for '"ready maria"' and I get the same thing I would get for
'ready maria' with no double quotes. I was under the impression at
http://www.mysql.com/doc/en/Fulltext_Search.html that double quotes meant
something.

What's the hic? Is it the boolean mode thing or a bad compile?

tested on 4.0.1-alpha-max-debug on a Windows box.

------------------------------------------------------------ ---------
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 bugs-thread13162@lists.mysql.com
To unsubscribe, e-mail

Re: Is this a bug?

It also does not work in MySQL 4.0.5-beta-max-debug

AGAINST ('"ready maria"' IN BOOLEAN MODE)

does the same job as:

AGAINST ('ready maria' IN BOOLEAN MODE)

The double quotes are meaningless, unless my SQL is bad, which I don't think so.

http://www.mysql.com/doc/en/Fulltext_Search.html


> Is this a bug? The boolean search does not work?
>
> SELECT AU,ST,BT,AT,id FROM ccl.ccl_main WHERE MATCH
> (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO)
> AGAINST ('"ready maria"' IN BOOLEAN MODE)
> ORDER BY id desc
>
> I run a search for '"ready maria"' and I get the same thing I would get
> for
> 'ready maria' with no double quotes. I was under the impression at
> http://www.mysql.com/doc/en/Fulltext_Search.html that double quotes
> meant
> something.
>
> What's the hic? Is it the boolean mode thing or a bad compile?
>
> tested on 4.0.1-alpha-max-debug on a Windows box.
>
> ------------------------------------------------------------ ---------
> 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 bugs-thread13162@lists.mysql.com
> To unsubscribe, e-mail
>

------------------------------------------------------------ ---------
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 bugs-thread13164@lists.mysql.com
To unsubscribe, e-mail

Re: Is this a bug?

Hi!

On Nov 29, eslcafe@courrier.usherb.ca wrote:
> It also does not work in MySQL 4.0.5-beta-max-debug
>
> AGAINST ('"ready maria"' IN BOOLEAN MODE)
>
> does the same job as:
>
> AGAINST ('ready maria' IN BOOLEAN MODE)

Test case, please ?

> The double quotes are meaningless, unless my SQL is bad, which I don't think so.

Not completely.
At least, the queries that are tested in mysql-test suite
(in fulltext.test file) works ok :)

> > Is this a bug? The boolean search does not work?
> >
> > SELECT AU,ST,BT,AT,id FROM ccl.ccl_main WHERE MATCH
> > (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO)
> > AGAINST ('"ready maria"' IN BOOLEAN MODE)
> > ORDER BY id desc
> >
> > I run a search for '"ready maria"' and I get the same thing I would get
> > for
> > 'ready maria' with no double quotes. I was under the impression at
> > http://www.mysql.com/doc/en/Fulltext_Search.html that double quotes
> > meant
> > something.
> >
> > What's the hic? Is it the boolean mode thing or a bad compile?
> >
> > tested on 4.0.1-alpha-max-debug on a Windows box.

This version is too old.

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
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 bugs-thread13166@lists.mysql.com
To unsubscribe, e-mail

Sergei: Re: Is this a bug?

Sergei,

A clarification:

>> It also does not work in MySQL 4.0.5-beta-max-debug
>> AGAINST ('"ready maria"' IN BOOLEAN MODE) does the same job as:
>> AGAINST ('ready maria' IN BOOLEAN MODE)
> Test case, please ?

What do you mean by test case? The case doesn't matter?

http://ccl.flsh.usherb.ca/print/index.html?table=ccl_main&db =ccl&search=%26quot%
3BReady+Maria%26quot%3B
http://ccl.flsh.usherb.ca/print/index.html?table=ccl_main&db =ccl&search=%26quot%
3Bready+maria%26quot%3B

It won't work. Only one entry has "ready maria".

http://ccl.flsh.usherb.ca/print/index.html?id=99&table=ccl&d b=jdaxell&search=%26
quot%3BReady+Maria%26quot%3B

>>The double quotes are meaningless, unless my SQL is bad, which I don't think
so.
> Not completely. At least, the queries that are tested in mysql-test suite
> (in fulltext.test file) works ok :)

I thjought I was using full text, right?

SELECT id,AU,ST,BT,AT FROM ccl WHERE MATCH
(TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO)
AGAINST ('"Ready Maria"' IN BOOLEAN MODE) ORDER BY id asc

So double quotes don't work yet?

I did test it also on your newest Windows compile 4.0.5-alpha-max-debug.

John

> > > Is this a bug? The boolean search does not work?
> > > SELECT AU,ST,BT,AT,id FROM ccl.ccl_main WHERE MATCH
> > > (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO)
> > > AGAINST ('"ready maria"' IN BOOLEAN MODE)
> > > ORDER BY id desc
> > >
> > > I run a search for '"ready maria"' and I get the same thing I would
> get
> > > for
> > > 'ready maria' with no double quotes. I was under the impression at
>
> > > http://www.mysql.com/doc/en/Fulltext_Search.html that double
> quotes
> > > meant
> > > something.
> > > What's the hic? Is it the boolean mode thing or a bad compile?
> > > tested on 4.0.1-alpha-max-debug on a Windows box.
>
> This version is too old.
>
> Regards,
> Sergei
>
> --
> MySQL Development Team
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
> /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
> <___/
>
> ------------------------------------------------------------ ---------
> 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 bugs-thread13166@lists.mysql.com
> To unsubscribe, e-mail

------------------------------------------------------------ ---------
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 bugs-thread13179@lists.mysql.com
To unsubscribe, e-mail

Re: Sergei: Re: Is this a bug?

Hi!

On Dec 02, eslcafe@courrier.usherb.ca wrote:
> Sergei,
>
> A clarification:
>
> >> It also does not work in MySQL 4.0.5-beta-max-debug
> >> AGAINST ('"ready maria"' IN BOOLEAN MODE) does the same job as:
> >> AGAINST ('ready maria' IN BOOLEAN MODE)
> > Test case, please ?
>
> What do you mean by test case? The case doesn't matter?

Sorry...
I mean something like

CREATE TABLE bug ....
INSERT INTO bug VALUES ...
SELECT * FROM bug WHERE MATCH ... AGAINST ( '"blabla foobar"' IN BOOLEAN MODE ...)

So I could repeat it with

mysql
as a variant, you can send me the one of your tables (MYD and frm, but
not MYI, tarred and gzipped), of course, if the resulting archive won't
be too big.

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
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 bugs-thread13182@lists.mysql.com
To unsubscribe, e-mail

Sergei: Re: Sergei: Re: Is this a bug?

Sergei,

Here is something repeatable. Consider this first:

http://news.php.net/article.php?group=php.general&article=12 6934

Is my problem PHP or MySQL?? I'm at wits end. I can get PHPMyAdmin to run my
SQL and work, but not PHP. PHP problem, right? Everyone over there STILL says
its a MySQL problem.

I have been having doubts since we last talked.

Mayble you know of something I don't know about PHP?

John
cc: n_o_s_p_a_m_jtjohnston@_n_o_s_p_a_m_courrier.usherb.ca

> > >> It also does not work in MySQL 4.0.5-beta-max-debug
> > >> AGAINST ('"ready maria"' IN BOOLEAN MODE) does the same job as:
> > >> AGAINST ('ready maria' IN BOOLEAN MODE)
> > > Test case, please ?
> >
> > What do you mean by test case? The case doesn't matter?
>
> Sorry...
> I mean something like
>
> CREATE TABLE bug ....
> INSERT INTO bug VALUES ...
> SELECT * FROM bug WHERE MATCH ... AGAINST ( '"blabla foobar"' IN BOOLEAN
> MODE ...)
>
> So I could repeat it with
>
> mysql >
> as a variant, you can send me the one of your tables (MYD and frm, but
> not MYI, tarred and gzipped), of course, if the resulting archive
> won't
> be too big.
>
> Regards,
> Sergei

------------------------------------------------------------ ---------
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 bugs-thread13204@lists.mysql.com
To unsubscribe, e-mail

Re: Sergei: Re: Sergei: Re: Is this a bug?

Hi!

On Dec 03, eslcafe@courrier.usherb.ca wrote:
> Sergei,
>
> Here is something repeatable. Consider this first:
>
> http://news.php.net/article.php?group=php.general&article=12 6934
>
> Is my problem PHP or MySQL?? I'm at wits end. I can get PHPMyAdmin to run my
> SQL and work, but not PHP. PHP problem, right? Everyone over there STILL says
> its a MySQL problem.

Trivial to check - enable general log, teere you can see what queries
MySQL receives. If it's '"ready maria"' - then it's probably MySQL
problem. Otherwise, you'll have to find why php doesn't pass your query to
MySQL as is.

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
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 bugs-thread13206@lists.mysql.com
To unsubscribe, e-mail