From: Len Rose
Date: March 21 1999 2:08am
Subject: Problems with LONGTEXT/BSDI 4.0
List-Archive: http://lists.mysql.com/mysql/704
Message-Id: <XFMail.990320210812.len@netsys.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit

-----BEGIN PGP SIGNED MESSAGE-----


I've created a test database, added some records with (1) LONGTEXT field..
Inserted several 16k entries in the text field.. 90% of the time accessing them
will cause mysql to die.. (3.22.14b-gamma)

i.e. 

mysql> select * from data
    -> \g
ERROR 2013: Segmentation faultLost connection to MySQL server during query
 - core dumpedmysql> 
mysqld restarted on  Sat Mar 20 21:02:41 EST 1999

Database: test1  Table: testdata  Rows: 1
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| Num       | varchar(5)   | YES  |     |         |                |
| Title     | varchar(254) | YES  |     |         |                |
| Author    | varchar(254) | YES  |     |         |                |
| Text      | longtext     | YES  |     |         |                |
| RecordID  | int(11)      |      | PRI | 0       | auto_increment |
+-----------+--------------+------+-----+---------+----------------+


If I access any other field things are fine.. any ideas on solving this?

Thanks

Len

len@stripped
http://www.netsys.com

-----BEGIN PGP SIGNATURE-----
Version: 2.6.1

iQCVAwUBNvRUi4ef0OvUNu5PAQGS+wQAl5mCVMXYoUPgMMWbIbyGiTl54zmwJd7K
AGhMd2WHcrWgAxN7QiUlJ3haDzBWjUyB5TthHOXkYtefQEuGtUH8posO5TvYIBCd
0gjJoZHKhmTl4Cj1aB5wHyIgWGWRqUFF4S7uzQYW5wAA1NRC1NqVRYlbWcxVOfjq
zs2W/Od/apY=
=NiIp
-----END PGP SIGNATURE-----