August Zajonc wrote:
>
> I can't figure out if MySQL is falling flat on its face or if I am making
> some enourmous error. Check this out:
> Notice the difference in count and number of rows returned. I inserted seven
> new rows, with blank insert statements. This has me baffled. I was planning
> on developing a rather large project MySQL but these basic tests don't seem
> to pan out. I shudder to think of what would happen if I gave it a beating.
>
> I'm hoping I missed the docs on this functionality somewhere :)
> ver: MySQL 3.23.7-alpha-log
> platform: FreeBSD
>
> // Table Structure
> --------------------
> CREATE TABLE Test (
> UserID smallint(5) unsigned NOT NULL auto_increment,
> PRIMARY KEY (UserID)
> );
>
> // MySQL output
> --------------------
> mysql> select * FROM Test
> -> ;
> +----+
> | AA |
> +----+
> | 1 |
> | 2 |
> | 3 |
> +----+
> 3 rows in set (0.09 sec)
>
> mysql> select count(*) From Test;
> +----------+
> | count(*) |
> +----------+
> | 7 |
> +----------+
> 1 row in set (0.00 sec)
>
> August Zajonc
> augustz@stripped
Some comments:
- make sure to have a fully repeatable test case, before sending it to the bugs
list
- make sure the test case fails on the latest version of MySQL
- the reason for the problem above is probably corrupted index - does it still
persist after myisamchk -r ?
--
Sasha Pachev
+------------------------------------------------------------------+
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
