Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

[Fournier Jocelyn [Presence-PC]]

Hi,

I've just tested with MySQL 4.0, no error, but strange result :

mysql> insert into visitkort (kategori_id) values (108);
Query OK, 1 row affected (0.00 sec)

mysql> update visitkort set navn = 'test5' where id = last_insert_id();
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update visitkort set tekst1 = 'bla bla' where id = last_insert_id();
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

The latest update seems to have been successful, but if you look at the
table you can see the tekst1 field has not been updated :

+----+-------------+-------+-------+---------+--------+-----+-----+-------+-
---------+-----+-------------+-----------+----------+------+---------+------
--+--------+--------+--------+
| id | kategori_id | aktiv | navn  | adresse | postnr | tlf | fax | email |
password | url | beskrivelse | visitkort | skabelon | logo | billede |
tekst1 | tekst2 | tekst3 | tekst4 |
+----+-------------+-------+-------+---------+--------+-----+-----+-------+-
---------+-----+-------------+-----------+----------+------+---------+------
--+--------+--------+--------+
|  1 |         108 |     0 | test5 |         |        |     |     |       |
|     |             |         0 |        0 |    0 |       0 |        |
|        |        |
+----+-------------+-------+-------+---------+--------+-----+-----+-------+-
---------+-----+-------------+-----------+----------+------+---------+------
--+--------+--------+--------+

Regards,

Jocelyn Fournier
Presence-PC

----- Original Message -----
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 12:06 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields


> I'm going to Spain today and cannot respond to any questions in the next
> week. I was going to wait with this until I got home again, but what the
> heck ;-)
>
> Run the following script through your MySQL on an empty database with
>
> mysql -uusername -ppassword dbname <scriptname
>
> and the last command should produce the following error:
>
> ERROR 1034 at line 31: Incorrect key file for table: 'visitkort'. Try to
> repair it
>
> I've let 3 people besides myself test it, and they all get the same error.
> It has now been tested on:
>
> Win2k server SP2, MySQL 3.23.32
>
> Win2k server SP2, MySQL 3.23.39
>
> Win2k Pro (Danish), MySQL 3.23.33 (normal version)
>
> Win2k Pro SP2 (English), MySQL 3.23.38-MAX
>
> Debian GNU/Linux, MySQL 3.23.39 (bniary .deb package)
>
> Some other Linux (didn't get the distro name), MySQL 3.23.39
>
> All of the above produces the error. So something must be wrong.
>
> Sincerily,
> - Carsten
>
> Here's the script:
>
> ##################################################
> CREATE TABLE `visitkort` (
>   `id` int(10) unsigned NOT NULL auto_increment,
>   `kategori_id` int(10) unsigned NOT NULL default '0',
>   `aktiv` tinyint(3) unsigned NOT NULL default '0',
>   `navn` varchar(60) NOT NULL default '',
>   `adresse` varchar(150) NOT NULL default '',
>   `postnr` varchar(5) NOT NULL default '',
>   `tlf` varchar(20) NOT NULL default '',
>   `fax` varchar(20) NOT NULL default '',
>   `email` varchar(60) NOT NULL default '',
>   `password` varchar(20) NOT NULL default '',
>   `url` varchar(150) NOT NULL default '',
>   `beskrivelse` varchar(200) NOT NULL default '',
>   `visitkort` tinyint(3) unsigned NOT NULL default '0',
>   `skabelon` tinyint(3) unsigned NOT NULL default '0',
>   `logo` tinyint(3) unsigned NOT NULL default '0',
>   `billede` tinyint(3) unsigned NOT NULL default '0',
>   `tekst1` text NOT NULL,
>   `tekst2` text NOT NULL,
>   `tekst3` text NOT NULL,
>   `tekst4` text NOT NULL,
>   PRIMARY KEY  (`id`),
>   FULLTEXT KEY `ft`
> (`navn`,`beskrivelse`,`tekst1`,`tekst2`,`tekst3`,`tekst4`)
> ) TYPE=MyISAM;
>
> insert into visitkort (kategori_id) values (108);
>
> update visitkort set navn = 'test5' where id = last_insert_id();
>
> update visitkort set tekst1 = 'bla bla' where id = last_insert_id();
> ##################################################
>
>
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php