MyISAM Data files, trailing row-bytes

[Jan Kneschke]

Hi,

I have a simple table:

CREATE TEMPORARY TABLE `temp_tbl` (
   `id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

 > select * from temp_tbl;
+------+
| id   |
+------+
|    1 |
| NULL |
|   -1 |
+------+

Dumping the file I get:

   [0000]  fd 01 00 00 00 00 00 ff 00 00 00 00 00 00 fd ff
   [0010]  ff ff ff 00 00

... or unrolled:

fd   01 00 00 00   00 00
ff   00 00 00 00   00 00
fd   ff ff ff ff   00 00

I would have expected to get the header-byte + 4 bytes for my INT.

Even http://forge.mysql.com/wiki/MySQL_Internals_MyISAM doesn't talk 
about the trailing 00 in fixed format.



cheers,
   Jan
-- 
Jan Kneschke, MySQL Enterprise Tools, Senior Software Dev

Sun Microsystems GmbH    Sonnenallee 1, DE-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfang Engels, Dr. Roland Boemer
Vorsitz d. Aufs.rat.: Martin Haering                    HRB MUC 161028