MySQL creates rows out of nothing

Posted by ads' corner on Sunday, 2010-01-31
Posted in [Other-Dbs]

After running a REPAIR TABLE:

1
2
3
4
5
6
7
8
 mysql> repair table search_archive_count_checked;
+----------------------------------+--------+----------+----------------------------------------------+
| Table                            | Op     | Msg_type | Msg_text                                     |
+----------------------------------+--------+----------+----------------------------------------------+
| xxx.search_archive_count_checked | repair | warning  | Number of rows changed from 335540 to 365874 |
| xxx.search_archive_count_checked | repair | status   | OK                                           |
+----------------------------------+--------+----------+----------------------------------------------+
2 rows in set (36.75 sec)

I’m surprised: this is the first database which is able to create rows out of nothing. Violation of the conversation of energy data, eh? ;-)


Categories: [Other-Dbs]
Tags: [Mysql] [Stupid]