maria-developers team mailing list archive

["Philip Stoev" <pstoev@xxxxxxxxxxxx>]

> When one sees this pair of codes ER_CONST_EXPR_IN_VCOL and 
> ER_ROW_EXPR_FOR_VCOL,
> one can't help asking himself whether that's the only disallowed 
> expressions,
> and if not, do we have error codes for vcol expressions with
> - user variables
> - subqueries
> - SP calls
> - etc, etc.
> Do we handle such cases at all?

Hello,

I checked our implementation and the Oracle and MS SQL Server documentation 
. We disallow subqueries, stored procedures and functions, but we allow user 
variables. The other database products are mostly stricter than we are, and 
I opened a new bug regarding the more relaxed rules in MariaDB and the 
issues this can cause.

https://bugs.launchpad.net/maria/+bug/608641