Row format "compressed" view as "default"

5 posts
lgts's profile image lgts posted 13 years ago in General Permalink
For table compressed (packed) in the Edit table form, the row format "compressed" is view as "default".
959 posts
kalvaro's profile image kalvaro posted 13 years ago Permalink
It seems that the "CREATE code" tab in the table editor does not include the ROW_FORMAT clause. Is that what you mean?
959 posts
kalvaro's profile image kalvaro posted 13 years ago Permalink
Funny, it only happens in recent snapshots. Latest stable version works as expected.
10152 posts
ansgar's profile image ansgar posted 13 years ago Permalink
ROW_FORMAT is only included in CREATE and ALTER code if the user selected some other than the default one.
5 posts
lgts's profile image lgts posted 13 years ago Permalink
This image explain better.
959 posts
kalvaro's profile image kalvaro posted 13 years ago Permalink
Anse: yesterday, I couldn't get a ROW_FORMAT clause no matter what changes I made to the table. Today, there it is... even for DEFAULT:

http://img812.imageshack.us/img812/74/rowformatdefault.png

:-?
959 posts
kalvaro's profile image kalvaro posted 13 years ago Permalink
Lgts: you are right, the grid in the "Database" tag displays "Compact" for me as well when I have a table with ROW_FORMAT=COMPRESSED. I bet it's just a mistyped array index that's easy to fix :)

Please login to leave a reply, or register at first.