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

Fournier Jocelyn [Presence-PC] Fri, 20 Jul 2001 07:07:33 -0700
Take a look at :

http://www.mysql.com/doc/I/n/Installing_source_tree.html


----- Original Message -----
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Fournier Jocelyn [Presence-PC]'" <[EMAIL PROTECTED]>; "Carsten
Gehling" <[EMAIL PROTECTED]>; "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 2:55 PM
Subject: RE: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields


> Hi
> Where can we get V4.0?
>
> Thanks Simon
>
> -----Original Message-----
> From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
> Sent: 20 July 2001 12:30
> To: Carsten Gehling; Sergei Golubchik
> Cc: [EMAIL PROTECTED]
> Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
> TEXT fields
>
>
> 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
>


---------------------------------------------------------------------
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
Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

Reply via email to
