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 <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php