Comments - Generated (Virtual and Persistent/Stored) Columns

10 years, 5 months ago Alex Hermann

Too bad that an important limitation isn't mentioned: the expression is limited to 252 characters.

ERROR 1470 (HY000): String 'XXXXXXXXXX' is too long for VIRTUAL COLUMN EXPRESSION (should be no longer than 252)

I would have hoped to be able to use virtual columns for reducing complexity in multiple applications by containing the logic in the database. Unfortunately, even a simple CASE statement with a few options will quickly exceed the 252 character limit.

 
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.