List:Bugs« Previous MessageNext Message »
From:sasha Date:June 11 2000 4:39am
Subject:Re: Ugly Bug: auto_increment weirdness...
View as plain text  
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                  |
+------------------------------------------------------------------+
Thread
Ugly Bug: auto_increment weirdness...August Zajonc11 Jun
  • RE: Ugly Bug: auto_increment weirdness...jason11 Jun
  • Re: Ugly Bug: auto_increment weirdness...sasha11 Jun