MariaDB 10.3支持SQL_MODE=ORACLE

MariaDB 10.3开始,设置系统变量sql_modeOracle可以打开对Oracle的PL/SQL的语法支持。这个支持包含了以下的新的功能,这个工作还在开发过程中. 参考MDEV-10142MDEV-10764发现现在的状态和子任务.

  • Providing compatibility for basic PL/SQL constructs - MDEV-10411
  • %TYPE in variable declarations - MDEV-10577
  • cursor%ROWTYPE in variable declarations - MDEV-12011
  • table%ROWTYPE in variable declarations - MDEV-12133
  • FOR loop statement - MDEV-10580
  • Implicit cursor FOR loop - MDEV-12098
  • Explicit cursor FOR LOOP - MDEV-10581
  • Cursors with parameters - MDEV-10597
  • Implicit cursor FOR LOOP for cursors with parameters - MDEV-12314
  • Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND - MDEV-10582
  • SQL%ROWCOUNT - MDEV-10583
  • Variable declarations can go after cursor declarations - MDEV-10598
  • Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX - MDEV-10839
  • RAISE statement for predefined exceptions - MDEV-10840
  • User defined exceptions - MDEV-10587
  • SP control functions SQLCODE, SQLERRM - MDEV-10578
  • Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 - MDEV-10579
  • Dynamic SQL placeholders - MDEV-10801
  • Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause - MDEV-10596
  • CAST(..AS VARCHAR(N)) - MDEV-11275
  • Anonymous blocks - MDEV-10655
  • GOTO statement - MDEV-10697
  • Allow SELECT UNIQUE as a synonym for SELECT DISTINCT - MDEV-12086
  • Do not require BEGIN..END in multi-statement exception handlers in THEN clause - MDEV-12088
  • Understand optional routine name after the END keyword - MDEV-12089
  • Inside routines the CALL keywoard is optional - MDEV-12107
  • Make the concatenation operator ignore NULL arguments - MDEV-11880
  • make the CONCAT function ignore NULL arguments - MDEV-12143
  • TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] - MDEV-10588
  • Providing compatibility for basic SQL data types - MDEV-10343

另见

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.