Re: Re[2]: heap tables

Victoria Reznichenko writes:
> Hi!
>
> SM> Victoria Reznichenko writes:
> >> I have a question about heap tables :)
> >>
> >> Why does MySQL allow to insert more rows in the table than is
> >> specified in MAX_ROWS ?
>
> SM> Send a test case ...
>
> mysql> create table hp(
> -> id int primary key)TYPE=HEAP MAX_ROWS=5;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into hp values
> -> (1),
> -> (2),
> -> (3),
> -> (4),
> -> (5),
> -> (6);
> Query OK, 6 rows affected (0.00 sec)
> Records: 6 Duplicates: 0 Warnings: 0
>
> mysql> select 8 from hp;
> ERROR 1030: Got error 124 from table handler
>
> --
> Victoria Reznichenko
>

Thank you for your bug report, but this is truly no bug ...

Some table handler, like HEAP, use info you specify for max_rows and
avg_row_length to determine maxumum number of blocks that could be use
for given table.

So, your table would be able to accomodate as many rows as would fit
in a single block, which in your case is about 12.

Regarding last error, this was fixed few days ago already.


--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

For technical support contracts, go to https://order.mysql.com/?ref=msmi


------------------------------------------------------------ ---------
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 bugs-thread12123@lists.mysql.com
To unsubscribe, e-mail