← Back to team overview

maria-developers team mailing list archive

Re: Dynamic column expression limitat - 252 characters


Hi Sergei,

Oracle's limitation is different.

>From http://mysqlserverteam.com/generated-columns-in-mysql-5-7-5/

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.

In normal practice, this is significantly higher than the MariaDB limit.



On Wed, Apr 20, 2016 at 5:03 PM, Sergey Petrunia <sergey@xxxxxxxxxxx> wrote:

> 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


*Christopher Church*
Architect | Patientco
888.747.2455 x

<http://info.patientco.com/himss> <http://info.patientco.com/_patientwallet>


As a friendly reminder, never send Protected Health Information (PHI) via 


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.