I can't believe MySQL is behaviouring that way and giving that kind of errors.
I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
all with the same results.
Can anyone please help?
Thx in advance,
Joan
The tests consists in:
* creating a table,
* to insert 2 registers,
* to erase 1 register,
* and... in this point of it annoys everything.
TO PASS a ISAMCHK with option - r (to repair).
Once I throw this, the table is in a error state.
When I passed a SELECT count(*) gives 1 registry us,
and if we happened a SELECT * says that this vacia to us.
(To see results down)
TEST:
DROP TABLE prueba;
CREATE TABLE prueba (id bigint not null,nom varchar(100));
INSERT INTO prueba VALUES (1,'ONE');
INSERT INTO prueba VALUES (2,'TWO');
DELETE FROM prueba WHERE id<2;
select * from prueba;
select count(*) from prueba;
Exit MySQL and run :
isamchk -r /D3/mysql.tables/joan/prueba
Mysql:
select * from prueba;
select count(*) from prueba;
[root]# mysql test
mysql> DROP TABLE prueba;
Query OK, 0 rows affected (0.03 sec)
mysql> CREATE TABLE prueba (id bigint not null,nom varchar(100));
Query OK, 0 rows affected (0.03 sec)
mysql> INSERT INTO prueba VALUES (1,'ONE');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO prueba VALUES (2,'TWO');
Query OK, 1 row affected (0.00 sec)
mysql> DELETE FROM prueba WHERE id<2;
Query OK, 1 row affected (0.01 sec)
mysql> select * from prueba;
+----+------+
| id | nom |
+----+------+
| 2 | TWO |
+----+------+
1 row in set (0.00 sec)
mysql> select count(*) from prueba;
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)
[root]# isamchk -r prueba
- recovering ISAM-table 'prueba.ISM'
Data records: 1
ANY RECORDS IN DATABASE,
BUT count(*) is 1.
[root]# mysql test
mysql> select * from prueba;
Empty set (0.00 sec)
mysql> select count(*) from prueba;
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)
mysql>
---------------------------------------------------------------------
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
