← Back to team overview

maria-developers team mailing list archive

Virtual columns in sql_mode=ORACLE

 

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.


Follow ups