List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:July 29 1999 12:56am
Subject:3.23.1-alpha - HEAP table bug?
View as plain text  
>>>>> "Nem" == Nem W Schlecht <nem@stripped>
> writes:

>> Description:
Nem> HEAP tables are *not* "freed" up when they are "drop"ed.  (BTW - HEAP
Nem> tables really rock!  Quite the cool feature in 3.23.)

>> How-To-Repeat:

Nem> Put the following in a file:

Nem> #------------------
Nem> drop table if exists foo;
Nem> create table foo ( bar char(10), baz char(10));
Nem> insert into foo values ('nem','schlecht'),('monty','The Man');
Nem> select * from foo;

Nem> drop table if exists foobie;
Nem> create table foobie TYPE=HEAP select * from foo;
Nem> select count(*) from foobie;

Nem> delete from foobie;		# this line optional - makes no diff.
Nem> drop table foobie;
Nem> create table foobie TYPE=HEAP select * from foo;
Nem> select count(*) from foobie;

Nem> delete from foobie;		# this line optional - makes no diff.
Nem> drop table foobie;

Nem> drop table foo;
Nem> #------------------

Nem> Then run 'mysql -t test < filename'.  I get the following output:
Nem> +-------+----------+
Nem> | bar   | baz      |
Nem> +-------+----------+
Nem> | nem   | schlecht |
Nem> | monty | The Man  |
Nem> +-------+----------+
Nem> +----------+
Nem> | count(*) |
Nem> +----------+
Nem> |        2 |
Nem> +----------+
Nem> +----------+
Nem> | count(*) |
Nem> +----------+
Nem> |        4 |
Nem> +----------+

Nem> Both count() calls should return 2.  Now run it *again*.  Try it several
Nem> times.  Watch the numbers grow.  Weee. ;-)

>> Fix:

<cut>

Hi!

I checked this in 3.23.2 and this version doesn't have this bug.
I have apparently fixed this during my vacation :)

Sorry, no fix;  Just wait a until 3.23.2 is released (within a few
days;  I have just to purify my new features...)

Regards,
Monty
Thread
3.23.1-alpha - HEAP table bug?Nem W Schlecht20 Jul
  • 3.23.1-alpha - HEAP table bug?sinisa20 Jul
  • 3.23.1-alpha - HEAP table bug?Michael Widenius29 Jul