← Back to team overview

maria-developers team mailing list archive

  1. maria-developers team
  2. Mailing list archive
  3. Message #10815

Virtual columns in sql_mode=ORACLE

  Thread Previous • Date Previous • • Thread Next 
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

  Thread Previous • Date Previous • • Thread Next