maria-developers team mailing list archive
Mailing list archive
Re: Dynamic column expression limitat - 252 characters
Oracle's limitation is different.
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?)
> Sergei Petrunia, Software Developer
> MariaDB Corporation | Skype: sergefp | Blog: http://s.petrunia.net/blog
Architect | Patientco
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.