maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hello Jerome,


I filed a bug report:

MDEV-13500 sql_mode=ORACLE: can't create a virtual column with function MOD

It should be enough to fix Item_func_mode::print() to print expressions as:

arg1 MOD arg2

instead of

arg1 % arg2


I'll try to do it soon.

On 08/02/2017 11:03 AM, jerome brauge wrote:
> Hello Alexander,
> Something seems to be wrong in sql_yacc_ora.yy. (10.2-ext branch)
> We can't create a table with a virtual column because the grammar try to reduce the rule sp_cursor_name_and_offset.
> 
> CREATE TABLE t1 (c1 INTEGER, c2 INTEGER AS (c1 MOD 10) VIRTUAL) ENGINE=InnoDb;
> ERROR 1324 (42000): Undefined CURSOR: c1
> 
> Regards,
> Jérôme.
>