Hi,
i once reported this together with the "update fails after alter"-bug in
3.23.35; this is how it "works":
mysql> DROP TABLE IF EXISTS ttt;
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TABLE ttt (
-> i1 varchar(10) default NULL
-> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO ttt VALUES ('1');
Query OK, 1 row affected (0.00 sec)
mysql> \q
Bye
balin:~ # myisamchk /usr/local/var/test/ttt.MYI
Checking MyISAM file: /usr/local/var/test/ttt.MYI
Data records: 1 Deleted blocks: 0
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check record links
MyISAM-table '/usr/local/var/test/ttt.MYI' is usable but should be fixed
^^^ note this; i get this on each and every table i create (3.23.24 was
o.k.). Doesn't sound too nice for a production environment imho...
This happens on Linux 2.2.18/glibc 2.1, Linux 2.2.18/glibc 2.2. Connection
through socket.
regards, Jan Legenhausen
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
