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

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to