The length of the generation expressions for a table are subject to the limitations of the .frm file, and thus they can’t be longer than 64K in total. So you can have one field with a generation expression length of 64K, or you can have 30 fields with an average expression length of 2K each.
https://mariadb.com/kb/en/mariadb/virtual-computed-columns/ says
the expression cannot exceed 252 characters in length.
I've got a complaint about this limitation.
Do we have any plans to remove it? (Does Oracle have it in their variant of
this feature?)
BR
Sergei
--
Sergei Petrunia, Software Developer
MariaDB Corporation | Skype: sergefp | Blog: http://s.petrunia.net/blog
As a friendly reminder, never send Protected Health Information (PHI) via email.
CONFIDENTIALITY NOTICE: The information contained in this email message may be privileged, confidential, and protected from disclosure. Any unauthorized use, printing, copying, disclosure, dissemination of or reliance upon this communication by persons other than the intended recipient may be subject to legal restriction or sanction. If you are not the intended recipient, you are hereby notified that you are not authorized to read, print, retain, copy, or disseminate this message, any part of it, or any attachments. If you think that you have received this email message in error, please reply to the sender and delete this email and any attachments and all copies thereof from your system without reading the content and destroy any printouts of the e-mail or attachments promptly.