The Ultimate Guide to High Availability with MariaDB

Comments - VALUES / VALUE

5 years, 7 months ago Charles Leifer
Re: VALUES / VALUE

I understand the motivation but this is a real pain for those of us that maintain libraries offering cross-database compatibility. MySQL 8 seems to continue to use VALUES for this functionality.

This does not appear to be backwards-compatible (i.e., 10.3.2 you can only use VALUES, 10.3.3 you can only use VALUE). It seems a bit hostile to introduce breaking, backwards-incompatible SQL changes in a point release (not even a minor version!).

I hope you will consider an alternative, such as supporting VALUES until 11.x?

 
4 years, 1 month ago Lapo Luchini
Re: VALUES / VALUE

(this might be a little late but) please notice that `VALUES(col)` can still be used after 10.3.3 (I just double-checked this on a 10.4.13), I guess the article uses strong wording in "starting from / until" but retro-compatibility is safe (for now).

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.