Comments - VALUES / VALUE
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.
It seems to me that it would've been better to choose a different syntax for new features than to make breaking changes to existing features, to maintain backward compatibility.
Yes, absolutely. We're trying to do that whenever possible.
But in this case,
VALUES()is the syntax from SQL Standard. For more than 20 years, as far as I know. AndVALUES()function was added to MySQL about 15 years ago. Either way compatibility with something had to be broken.And we thought that future-wise it's more important to be compatible with the SQL Standard (and numerous other databases).