Hi Nikita, > 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. But let's see what is others people opinion. -- Best regards, Aleksander Alekseev
