> This seems a little bit confusing and thus very unfriendly for the user, because the actual meaning > of the same 'DEFAULT' option will be different for each data type, and to check storage mode user > has to query full table (or column) description. > I'd rather add a paragraph in documentation describing each data type default storage mode.
I agree that "SET STORAGE default" syntax leaves much to be desired.
Personally I would prefer "RESET STORAGE" and "RESET COMPRESSION". But since we already have "SET COMPRESSION default" this going to be either two commands that do the same thing, or a broken backward compatibility. Simply removing "SET COMPRESSION default" will make the syntax consistent too, but again, this would be a broken backward compatibility. I would argue that a sub-optimal but consistent syntax that does the job is better than inconsistent syntax and figuring out the default storage strategy manually.