-----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-----