FW: FW: mySQL Question

Hello Sergei,
As per your request I'm posting to the bugs and CCd you for this e-mail
only.

Okay, when I look at my installer files, it is clearly labeled as
3.23.52. If I use mySQL-Front from my PC, it says the same thing. When I
use the command line on the UNIX box, it says:
mysql Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386)

I'm a little confused why the versions are different. My assumption is
the server is one version while the client is another?

In any case, I installed that binary on 3 different machines and keep
having the same problem. On two of the machines, I allowed for one
character searches. On the 3rd machine, I did no adjustments to the
search word limit.

How-To-Repeat:
I have placed the source code I used to install the server at the
following URL if that helps. This code allows for a single character
search.
http://64.71.137.110/mysql

Unfortunately I am experiencing this problem and am not sure what other
info I can offer. What distribution did you run the test on?
Thanks in advance,
~jerry



-----Original Message-----
From: Sergei Golubchik [mailto:serg@mysql.com]
Sent: Tuesday, October 22, 2002 4:05 AM
To: J. Phul
Subject: Re: FW: mySQL Question

Hi!

On Oct 21, J. Phul wrote:
> Hello Sergei,
> I posted on the group but thought to contact you directly as well with
> this repeat of an issue (hope you don't mind). Can you please confirm
if
> this bug has re-appeared or is there a fix for this (see below). I've
> also attached a text file explaining how to reproduce it.

First, please use bugs@lists.mysql.com to report bugs.
Don't write directly to me - your mail can be forwarded to
"not-urgent" folder and I won't see it in a months.

Then,

>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8& threadm=9j57
in%245kc%241%40FreeBSD.csie.NCTU.edu.tw&rnum=1&prev=/groups% 3Fq%3Dmysql%
2BAND%2Bfulltext%2Bfields%2BAND%2B%2522incorrect%2Bkey%2522% 26hl%3Den%26
lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D9j

> I've sought my answer all over the web and cannot seem to find.
> Hopefully someone can point me to the answer or help debug the issue.
>
> This can be reproduced on a new database with one table, I'll attache
> the script below.
>
> How-To-Repeat:
> PROBLEM: I create a table with 3 fields. The first field is an
> autoincrement ID field. The remaining two are content fields (varchar
> and text). I create a fulltext index on the content fields.
>
> Inserting new records for the first work okay (I only inserted two for
> this test). Then I went to update any one of those two records. When I
> edit the field with an index and commit my change, I get the following
> error:
>
> Incorrect key file for table: ?TABLE NAME'. Try to repair it.

I wasn't able to repeat it. Are you sure you were using 3.23.52 ?
According to url above the bug was fixed long time ago.

> TECH INFO:
> Validated before mySQL install that I have the correct compilers,
libraries, etc.
> OS: RedHat Linux 7.3
> mySQL: 3.23.52
>
> TRIED:
> - 3 other machines
> - myisamchk with a combination of options (-r -o -e etc)
> - repaired at mySQL command line 'table repair TABLENAME extended'
>
> SQL SCRIPT:
> #
> # Table structure for table 'myTest'
> #
>
> CREATE TABLE `myTest` (
> `id` tinyint(3) unsigned NOT NULL auto_increment,
> `name` varchar(60) default NULL,
> `description` text,
> PRIMARY KEY (`id`),
> UNIQUE KEY `id` (`id`),
> KEY `id_2` (`id`),
> FULLTEXT KEY `ft_name` (`name`,`description`)
> ) TYPE=MyISAM;
>
> #
> # Dumping data for table 'myTest'
> #
> INSERT INTO `myTest` VALUES("1","name 1","This is record 1.");
> INSERT INTO `myTest` VALUES("2","name 2","This should be the second
record.\r\n");

Yes, and what then ?
I tried several UPDATE's - everything worked fine.

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