You are here
MariaDB sql_mode = 'oracle'
Thu, 2021-03-25 20:15 — Shinguz
What is new in MariaDB
MariaDB has some time ago introduced or reused the sql_mode = 'oracle'. What they basically try to do is to implement a subset of the Oracle PL/SQL language. Because we receive more and more request from customers about MariaDB's Oracle PL/SQL it is worth investigating a bit more in this feature and summarize the state of the art of this topic in this article.
See also our former articles about the MariaDB sql_mode = 'oracle':
Items found in the MariaDB Jira database
If you look at the items in the MariaDB Jira database you can get some valuable information and see some trends.
It is a bit tricky to search the database because of the various different labels (Compatibility, Oracle, PL/SQL) and keywords. You will not find all items in one search. Please let us know if you find some more items we do not track yet!
| Jira ID | Title | Affected Versions | Status | Resolution | Fix Version/s | Reporter | Votes | Watchers | Created | Updated/ Resolved |
|---|---|---|---|---|---|---|---|---|---|---|
| MCOL-1751 | Oracle Compatibility: SELECT IF (...) INTO variable FROM DUAL result in syntax error | 1.2.0 | Open | Unresolved | Icebox | Daniel Lee | 0 | 1 | 2018-09-27 | 2021-01-14 |
| MCOL-1752 | Oracle Compatibility: A specific stored procedure caused mysqld to crash | 1.2.0 | Open | Unresolved | Icebox | Daniel Lee | 0 | 1 | 2018-09-27 | 2021-01-14 |
| MCOL-2116 | TRIM() can not be used with ColumnStore 1.2.x in sql_mode=oracle | 1.2.1, 1.2.2 | Open | Unresolved | Icebox | Valerii Kravchuk | 0 | 3 | 2019-01-28 | 2021-01-15 |
| MCOL-2124 | substr functions fails with an aggregate function or with GROUP BY cluase with set oracle sql_mode | 1.2.2 | Open | Unresolved | Icebox | Zdravelina Sokolovska | 0 | 1 | 2019-01-29 | 2021-01-14 |
| MCOL-2127 | query returns empty set if it's executed after failing query in oracle sql-mode | 1.2.2 | Open | Unresolved | Icebox | Zdravelina Sokolovska | 0 | 1 | 2019-01-30 | 2021-01-14 |
| MCOL-2128 | cut off string from union with sql-mode oracle | 1.2.2 | Open | Unresolved | Icebox | Zdravelina Sokolovska | 0 | 1 | 2019-01-30 | 2021-01-14 |
| MCOL-2191 | run the full tpc-ds query set to mcs with set infinidb_vtable_mode 2 | None | Closed | Won't Do | N/A | Zdravelina Sokolovska | 0 | 2 | 2019-02-22 | 2021-02-25 |
| MCOL-2194 | run the full tpc-ds query set to mcs with set sql-mode orcle and infinidb_vtable_mode 2 | None | Closed | Won't Do | N/A | Zdravelina Sokolovska | 0 | 2 | 2019-02-24 | 2021-02-25 |
| MCOL-4044 | Built In SQL Functions not working with sql_mode=ORACLE | None | In Progress | Unresolved | 5.6.1 | Todd Stoffel | 1 | 5 | 2020-06-05 | 0201-03-08 |
| MCOL-4587 | sql_mode=ORACLE specific functions do not work with ColumnStore tables | None | Closed | Duplicate | N/A | Alexander Barkov | 0 | 1 | 2021-03-05 | 2021-03-05 |
| MDEV-6121 | Data type: Array | Open | Unresolved | None | Sergei Golubchik | 13 | 13 | 2014-04-16 | 2019-02-14 | |
| MDEV-9917 | autonomous transaction | Closed | Duplicate | N/A | ManasaTulluri | 0 | 3 | 2016-04-14 | 2016-08-12 | |
| MDEV-10137 | Providing compatibility to other databases | Open | Unresolved | None | Michael Widenius | 0 | 3 | 2016-05-27 | 2017-07-19 | |
| MDEV-10142 | sql_mode=ORACLE: Explicit cursor FOR LOOP | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 4 | 2016-08-17 | 2017-03-10 |
| MDEV-10143 | User defined types | Open | Unresolved | None | Michael Widenius | 6 | 8 | 2016-05-27 | 2020-12-11 | |
| MDEV-10144 | Add support for PIVOT | Open | Unresolved | None | Michael Widenius | 5 | 10 | 2016-05-27 | 2019-02-14 | |
| MDEV-10152 | Add support for REF CURSOR | Open | Unresolved | None | Michael Widenius | 5 | 8 | 2016-05-30 | 2019-09-24 | |
| MDEV-10155 | Autonomous transactions | Open | Unresolved | None | Michael Widenius | 7 | 7 | 2016-05-31 | 2019-04-26 | |
| MDEV-10155 | Autonomous transactions | Open | Unresolved | None | Michael Widenius | 7 | 7 | 2016-05-31 | 2019-04-26 | |
| MDEV-10165 | Allow one to specify max length for a BLOB/TEXT | Open | Unresolved | None | Michael Widenius | 0 | 6 | 2016-06-01 | 2019-02-14 | |
| MDEV-10343 | sql_mode=ORACLE: Providing compatibility for basic SQL data types | None | Closed | Fixed | 10.3.0 | Dmitry Tolpeko | 0 | 3 | 2016-07-07 | 2020-08-27 |
| MDEV-10411 | sql_mode=ORACLE: Providing compatibility for basic PL/SQL constructs | None | Closed | Fixed | 10.3.0 | Dmitry Tolpeko | 0 | 4 | 2016-07-21 | 2020-08-27 |
| MDEV-10481 | Inconsistency between CREATE FUNCTION SYSDATE and DROP FUNCTION SYSDATE | 5.5, 10.0, 10.1, 10.2, 10.3, 10.4 | Open | Unresolved | 10.4 | Alexander Barkov | 0 | 5 | 2016-08-02 | 2018-08-27 |
| MDEV-10484 | Implement the RAW data type | Open | Unresolved | 10.4 | Alexander Barkov | 0 | 3 | 2016-08-03 | 2018-12-26 | |
| MDEV-10485 | "Unreserve" MariaDB reserved keywords that are not reserved in the other databases | None | Open | Unresolved | None | Alexander Barkov | 3 | 4 | 2016-08-03 | 2018-05-23 |
| MDEV-10572 | Automatic transaction start for sql_mode=ORACLE | None | Open | Unresolved | None | Alexander Barkov | 0 | 6 | 2016-08-17 | 2020-05-11 |
| MDEV-10573 | Oracle style multi-table UPDATE syntax | None | Open | Unresolved | None | Alexander Barkov | 0 | 5 | 2016-08-17 | 2019-02-14 |
| MDEV-10574 | sql_mode=ORACLE: IS NULL and empty strings | None | Open | Unresolved | 10.3, 10.4 | Alexander Barkov | 2 | 7 | 2016-08-17 | 2019-03-29 |
| MDEV-10575 | sql_mode=ORACLE: Date and timestamp formats | None | Open | Unresolved | None | Adam Erickson | 0 | 5 | 2016-08-17 | 2019-02-14 |
| MDEV-10576 | sql_mode=ORACLE: Functions with no parameters can be called without parentheses | None | Opn | Unresolved | None | Alexander Barkov | 0 | 3 | 2016-08-17 | 2018-02-14 |
| MDEV-10577 | sql_mode=ORACLE: %TYPE in variable declarations | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 3 | 2016-08-17 | 2018-08-31 |
| MDEV-10578 | sql_mode=ORACLE: SP control functions SQLCODE, SQLERRM | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-17 | 2020-08-27 |
| MDEV-10579 | sql_mode=ORACLE: Triggers: Understand :NEW.c1 and :OLD.c1 instead of NEW.c1 and OLD.c1 | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-17 | 2020-08-27 |
| MDEV-10580 | sql_mode=ORACLE: FOR loop statement | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-17 | 2020-08-27 |
| MDEV-10581 | sql_mode=ORACLE: Explicit cursor FOR LOOP | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 4 | 2016-08-17 | 2020-08-27 |
| MDEV-10582 | sql_mode=ORACLE: Explicit cursor attributes %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-17 | 2020-08-27 |
| MDEV-10583 | sql_mode=ORACLE: SQL%ROWCOUNT | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 3 | 2016-08-17 | 2020-08-27 |
| MDEV-10585 | EXECUTE IMMEDIATE statement | None | Closed | Fixed | 10.2.3, 10.3.0 | Alexander Barkov | 0 | 4 | 2016-08-17 | 2018-08-31 |
| MDEV-10586 | sql_mode=ORACLE: Predefined exceptions (part 2) | None | Open | Unresolved | None | Alexander Barkov | 3 | 4 | 2016-08-18 | 2018-02-14 |
| MDEV-10587 | sql_mode=ORACLE: User defined exceptions | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-18 | 2020-08-27 |
| MDEV-10588 | sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ] | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 3 | 2016-08-18 | 2020-08-27 |
| MDEV-10589 | sql_mode=ORACLE: LOG ERRORS clause in INSERT, DELETE, UPDATE | None | Stalled | Unresolved | None | Alexander Barkov | 0 | 3 | 2016-08-18 | 2019-02-14 |
| MDEV-10590 | sql_mode=ORACLE: Built-in package DBMS_OUTPUT | None | Open | Unresolved | None | Alexander Barkov | 3 | 6 | 2016-08-18 | 2019-02-14 |
| MDEV-10591 | Oracle-style packages | None | Closed | Fixed | 10.3.5 | Alexander Barkov | 2 | 8 | 2016-08-18 | 2019-04-24 |
| MDEV-10592 | sql_mode=ORACLE: TYPE .. TABLE OF for scalar data types | None | Open | Unresolved | None | Alexander Barkov | 5 | 9 | 2016-08-18 | 2019-04-03 |
| MDEV-10593 | sql_mode=ORACLE: TYPE .. AS OBJECT: basic functionality | None | Open | Unresolved | None | Alexander Barkov | 4 | 8 | 2016-08-18 | 2019-04-03 |
| MDEV-10596 | sql_mode=ORACLE: Allow VARCHAR and VARCHAR2 without length as a data type of routine parameters and in RETURN clause | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-19 | 2020-08-27 |
| MDEV-10597 | sql_mode=ORACLE: Cursors with parameters | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-19 | 2020-08-27 |
| MDEV-10598 | sql_mode=ORACLE: Variable declarations can go after cursor declarations | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-08-19 | 2018-08-31 |
| MDEV-10654 | IN, OUT, INOUT parameters in CREATE FUNCTION | None | Open | Unresolved | None | Alexander Barkov | 3 | 6 | 2016-08-24 | 2018-11-19 |
| MDEV-10655 | sql_mode=ORACLE: Anonymous blocks | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 4 | 2016-08-24 | 2020-05-11 |
| MDEV-10697 | sql_mode=ORACLE: GOTO statement | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 1 | 2 | 2016-08-29 | 2016-08-31 |
| MDEV-10764 | PL/SQL parser - Phase 2 | Open | Unresolved | None | Alvin Richards | 3 | 7 | 2016-09-07 | 2020-08-01 | |
| MDEV-10801 | sql_mode=ORACLE: Dynamic SQL placeholders | 10.2 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2016-09-13 | 2020-08-27 |
| MDEV-10839 | sql_mode=ORACLE: Predefined exceptions: TOO_MANY_ROWS, NO_DATA_FOUND, DUP_VAL_ON_INDEX | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2016-09-20 | 2020-08-27 |
| MDEV-10840 | sql_mode=ORACLE: RAISE statement for predefined exceptions | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2016-09-20 | 2020-08-27 |
| MDEV-10872 | Providing compatibility Oracle database | Open | Unresolved | None | Alvin Richards | 3 | 13 | 2016-09-22 | 2020-12-04 | |
| MDEV-10914 | ROW data type for stored routine variables | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2016-09-28 | 2018-08-31 |
| MDEV-11022 | sql_mode=ORACLE: SQLERRM(errcode) | 10.3 | Open | Unresolved | None | Alexander Barkov | 2 | 4 | 2016-10-11 | 2018-02-14 |
| MDEV-11070 | Providing compatibility to other databases - Phase 2 | Open | Unresolved | None | Alvin Richards | 0 | 5 | 2016-10-17 | 2018-10-08 | |
| MDEV-11160 | Incorrect column name" when "CREATE TABLE t1 AS SELECT spvar | 10.3 | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2016-10-27 | 2018-08-31 |
| MDEV-11275 | sql_mode=ORACLE: CAST(..AS VARCHAR(N)) | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2016-11-12 | 2020-08-27 |
| MDEV-11283 | CAST(..AS VARCHAR(N)) | Open | Unresolved | None | Alexander Barkov | 2 | 6 | 2016-11-15 | 2020-11-19 | |
| MDEV-11300 | sql_mode=ORACLE: CURRENT_DATE function | None | Open | Unresolved | None | Dmitry Tolpeko | 0 | 1 | 2016-11-17 | 2019-02-14 |
| MDEV-11781 | sql_mode=ORACLE: IN, OUT, IN OUT modes for dynamic SQL bind arguments | None | Open | Unresolved | None | Alexander Barkov | 2 | 4 | 2017-01-12 | 2018-02-14 |
| MDEV-11812 | sql_mode=ORACLE: AUTHID clause | 10.3 | Open | Unresolved | None | Alexander Barkov | 1 | 3 | 2017-01-16 | 2018-02-14 |
| MDEV-11848 | Automatic statement repreparation changes query semantics | 10.0. 10.1, 10.2, 10.3 | Closed | Fixed | 10.2.4 | Alexander Barkov | 0 | 1 | 2017-01-20 | 2018-08-31 |
| MDEV-11880 | sql_mode=ORACLE: Make the concatenation operator ignore NULL arguments | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2017-01-23 | 2018-08-31 |
| MDEV-11921 | sql_mode=ORACLE: Translate NUMBER, FLOAT and DOUBLE to subtypes of DECIMAL | 10.3.23 | Open | Unresolved | None | Alexander Barkov | 1 | 5 | 2017-01-27 | 2020-11-09 |
| MDEV-12007 | Allow ROW variables as a cursor FETCH target | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-02-07 | 2020-08-27 |
| MDEV-12011 | sql_mode=ORACLE: cursor%ROWTYPE in variable declarations | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2017-02-07 | 2020-08-27 |
| MDEV-12032 | sql_mode=ORACLE: recursive stored functions | None | Open | Unresolved | None | Alexander Barkov | 2 | 5 | 2017-02-09 | 2018-02-14 |
| MDEV-12033 | sql_mode=ORACLE: transactions in stored functions | 10.3 | Open | Unresolved | None | Alexander Barkov | 2 | 4 | 2017-02-09 | 2018-02-14 |
| MDEV-12034 | Dynamic SQL in stored functions | 10.3 | Open | Unresolved | None | Alexander Barkov | 7 | 7 | 2017-02-09 | 2019-03-18 |
| MDEV-12076 | CONCAT behavior with NULL is different to Oracle | 37662 | Closed | Duplicate | 10.3.0 | Alexander Barkov | 1 | 4 | 2017-02-16 | 2017-04-09 |
| MDEV-12085 | sql_mode=ORACLE: allow derived tables not to have aliases | None | Open | Unresolved | None | Alexander Barkov | 1 | 3 | 2017-02-20 | 2019-02-14 |
| MDEV-12086 | sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-02-20 | 2020-08-27 |
| MDEV-12087 | sql_mode=ORACLE: a new option to make dash-dash to start a comment | None | Open | Unresolved | 10.3, 10.4 | Alexander Barkov | 2 | 5 | 2017-02-20 | 2019-06-12 |
| MDEV-12088 | sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-02-20 | 2020-08-27 |
| MDEV-12089 | sql_mode=ORACLE: Understand optional routine name after the END keyword | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-02-20 | 2020-08-27 |
| MDEV-12098 | sql_mode=ORACLE: Implicit cursor FOR loop | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-02-20 | 2018-09-25 |
| MDEV-12107 | sql_mode=ORACLE: Inside routines the CALL keywoard is optional | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-02-22 | 2020-08-27 |
| MDEV-12119 | Provide support for DATABASE LINK | Open | Unresolved | None | VAROQUI Stephane | 0 | 3 | 2017-02-23 | 2017-02-23 | |
| MDEV-12133 | sql_mode=ORACLE: table%ROWTYPE in variable declarations | 10.3 | Closed | Fixed | 10.3 | Alexander Barkov | 0 | 2 | 2017-02-27 | 2018-08-31 |
| MDEV-12140 | sql_mode=ORACLE: Package metadata views | 10.3 | Open | Unresolved | None | Alexander Barkov | 0 | 1 | 2017-02-27 | 2019-02-14 |
| MDEV-12143 | sql_mode=ORACLE: Make the CONCAT function ignore NULL arguments | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 2 | 2017-02-27 | 2018-08-31 |
| MDEV-12209 | sql_mode=ORACLE: Syntax error in a OPEN cursor with parameters makes the server crash | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-03-08 | 2020-08-27 |
| MDEV-12224 | sql_mode=ORACLE: identifier naming convention | 10.3 | Open | Unresolved | None | Alexander Barkov | 0 | 2 | 2017-03-10 | 2019-02-14 |
| MDEV-12291 | Allow ROW variables as SELECT INTO targets | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-03-17 | 2020-08-27 |
| MDEV-12307 | ROW data type for built-in function return values | 10.3 | Open | Unresolved | None | Alexander Barkov | 1 | 3 | 2017-03-20 | 2019-02-14 |
| MDEV-12314 | sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters | 10.3 | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-03-21 | 2018-08-31 |
| MDEV-12333 | Allow %ROWTYPE variable fields as FETCH INTO targets | 10.3 | Open | Unresolved | None | Alexander Barkov | 1 | 4 | 2017-03-22 | 2019-02-14 |
| MDEV-12334 | Allow %ROWTYPE variable fields as SELECT INTO targets | 10.3 | Open | Unresolved | None | Alexander Barkov | 1 | 3 | 2017-03-22 | 2019-02-14 |
| MDEV-12441 | Variables declared after cursors with parameters lose value | None | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-04-04 | 2018-08-31 |
| MDEV-12450 | PL/SQL stored procedure appears to be removed after a drop database, but then fails to re-create - database still exists | 10.2.5 | Closed | Fixed | N/A | Alvin Richards | 0 | 2 | 2017-04-05 | 2017-08-15 |
| MDEV-12457 | Cursors with parameters | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-04-06 | 2017-04-09 | |
| MDEV-12461 | TYPE OF and ROW TYPE OF anchored data types for stored routine variables | Closed | Fixed | 10.3.0 | Alexander Barkov | 0 | 1 | 2017-04-06 | 2017-08-18 | |
| MDEV-12478 | CONCAT function inside view casts values incorrectly with Oracle sql_mode | 10.2.5 | Closed | Fixed | 10.3.0 | Alexander Barkov | 1 | 4 | 2017-04-10 | 2020-08-25 |
| MDEV-12518 | Unify sql_yacc.yy and sql_yacc_ora.yy | Closed | Fixed | 10.5.1 | Alexander Barkov | 0 | 5 | 2017-04-18 | 2020-05-05 | |
| MDEV-12533 | sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL | None | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2017-04-20 | 2018-08-31 |
| MDEV-12783 | sql_mode=ORACLE: Functions LENGTH() and LENGTHB() | 10.3 | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2017-05-11 | 2018-08-31 |
| MDEV-12842 | sql_mode=ORACLE: using Oracle-style placeholders in direct query execution makes the server crash | 10.3 | Closed | Fixed | 10.3.3 | Alexander Barkov | 0 | 1 | 2017-05-19 | 2017-11-15 |
| MDEV-12846 | sql_mode=ORACLE: using Oracle-style placeholders in direct query execution makes the server crash | 10.3 | Closed | Fixed | 10.3.3. | Alexander Barkov | 0 | 1 | 2017-05-19 | 2017-12-12 |
| MDEV-12883 | CREATE SEQUENCE with huge MAXVALUE | 10.3.0 | Closed | Won't Fix | N/A | Andrii Nikitin | 0 | 4 | 2017-05-23 | 2018-04-06 |
| MDEV-12962 | Testing MDEV-10142 (PL/SQL parser) | Open | Unresolved | None | Andrii Nikitin | 0 | 2 | 2017-05-31 | 2019-07-07 | |
| MDEV-12964 | sql_mode=ORACLE: multi-columns Unique index behavior to expect with NULL value | Open | Unresolved | None | David JEGOU | 0 | 3 | 2017-05-31 | 2018-02-14 | |
| MDEV-12977 | sql_mode=oracle: errors "Undefined CURSOR" AND "check ... right syntax to use near '%" | 10.3 | Closed | Not a Bug | N/A | Andrii Nikitin | 0 | 2 | 2017-06-02 | 2017-06-02 |
| MDEV-13078 | NOT NULL routine variables | 10.3 | Open | Unresolved | None | Alexander Barkov | 0 | 2 | 2017-06-13 | 2018-02-14 |
| MDEV-13298 | Change sp_head::m_chistics from a pointer to a structure | 10.3 | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2017-07-12 | 2018-08-31 |
| MDEV-13414 | Fix the SP code to avoid excessive use of strlen | 10.3 | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2017-07-31 | 2018-08-31 |
| MDEV-13417 | UPDATE produces wrong values if an updated column is later used as an update source | 10.0, 10.1, 10.2 | Closed | Fixed | 10.3.5 | Alexander Barkov | 0 | 4 | 2017-08-01 | 2019-04-27 |
| MDEV-13418 | Compatibility: The order of evaluation of SELECT..INTO assignments | Stalled | Unresolved | None | Alexander Barkov | 0 | 3 | 2017-08-01 | 2018-04-10 | |
| MDEV-13419 | Cleanup for Sp_handler::show_create_sp | 10.3 | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 2 | 2017-08-01 | 2018-08-31 |
| MDEV-13474 | MySQL dialect must still work in sql_mode=oracle | 10.3.0 | Open | Unresolved | 10.3, 10.4 | Andrii Nikitin | 0 | 3 | 2017-08-08 | 2019-03-29 |
| MDEV-13500 | sql_mode=ORACLE: can't create a virtual column with function MOD | None | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 2 | 2017-08-11 | 2017-08-15 |
| MDEV-13501 | sql_mode=ORACLE does not include STRICT_TRANS_TABLES | 10.3 | Open | Unresolved | 10.4 | Alexander Barkov | 1 | 4 | 2017-08-11 | 2018-04-05 |
| MDEV-13527 | Crash when EXPLAIN SELECT .. INTO row_sp_variable.field | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2017-08-15 | 2017-08-15 | |
| MDEV-13581 | ROW TYPE OF t1 and t1%ROWTYPE for routine parameters | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 1 | 2017-08-18 | 2018-08-31 | |
| MDEV-13617 | tokudb_parts tests failed in buildbot | 10.3 | Closed | Fixed | 10.3.1 | Alexander Barkov | 0 | 3 | 2017-08-22 | 2017-08-22 |
| MDEV-13686 | EXCEPTION reserved keyword in SQL_MODE=oracle but not in Oracle itself | 10.3.1 | Closed | Fixed | 10.3.2 | Anders Karlsson | 0 | 4 | 2017-08-31 | 2017-09-14 |
| MDEV-13695 | INTERSECT precedence is not in line with Oracle even in SQL_MODE=Oracle | 10.3.1 | Closed | Fixed | 10.3.7 | Anders Karlsson | 0 | 3 | 2017-09-01 | 2018-04-25 |
| MDEV-13707 | Server in ORACLE mode crashes on ALTER with wrong DEFAULT clause | 10.2, 10.3 | Closed | Fixed | 10.2.9 | Alexander Barkov | 0 | 2 | 2017-09-01 | 2017-09-13 |
| MDEV-13817 | add support for oracle's left join syntax - the ( + ) | Open | Unresolved | None | Kevin Baas | 0 | 5 | 2017-09-15 | 2017-11-13 | |
| MDEV-13863 | sql_mode=ORACLE: DECODE does not treat two NULLs as equivalent | 10.3 | Closed | Fixed | 10.3.2 | Alexander Barkov | 0 | 3 | 2017-09-22 | 2020-08-25 |
| MDEV-13919 | sql_mode=ORACLE: Derive length of VARCHAR SP parameters with no length from actual parameters | 10.3 | Closed | Fixed | 10.3.2 | Alexander Barkov | 0 | 2 | 2017-09-27 | 2018-08-31 |
| MDEV-14012 | sql_mode=Oracle: substr(): treat position 0 as position 1 | 10.3 | Closed | Fixed | 10.3.3 | Alexander Barkov | 0 | 1 | 2017-10-05 | 2018-08-31 |
| MDEV-14013 | sql_mode=EMPTY_STRING_IS_NULL | 10.3 | Closed | Fixed | 10.3.3 | Alexander Barkov | 0 | 5 | 2017-10-05 | 2020-07-22 |
| MDEV-14139 | Anchored data types for variables | None | Closed | Fixed | 10.3.3 | Alexander Barkov | 0 | 3 | 2017-10-26 | 2018-08-31 |
| MDEV-14164 | Unknown column error when adding aggregate to function in oracle style procedure FOR loop | 10.0, 10.1, 10.2, 10.3 | Closed | Fixed | 10.0.34, 10.1.29, 10.2.11, 10.3.3 | Hartmut Holzgraefe | 0 | 5 | 2017-10-27 | 2020-08-25 |
| MDEV-14228 | MariaDB crashes with function | 10.3 | Closed | Fixed | 10.3.3 | Alexander Barkov | 0 | 5 | 2017-10-31 | 2020-08-25 |
| MDEV-14388 | Server crashes in handle_select / val_uint in ORACLE mode | 10.3 | Closed | Fixed | 10.3.3 | Elena Stepanova | 0 | 2 | 2017-11-14 | 2020-08-25 |
| MDEV-14415 | Add Oracle-style FOR loop to sql_mode=DEFAULT | Closed | Fixed | 10.3.3 | Alexander Barkov | 0 | 4 | 2017-11-16 | 2019-06-20 | |
| MDEV-14603 | signal 11 with short stacktrace | 10.2.11 | Closed | Fixed | 10.2.13, 10.3.5 | Richard Stacke | 1 | 5 | 2017-12-07 | 2020-08-25 |
| MDEV-15041 | Implement MERGE statement | Open | Unresolved | None | Alexander Bienemann | 0 | 3 | 2018-01-23 | 2019-03-29 | |
| MDEV-15070 | Crash when doing a CREATE VIEW inside a package routine | 10.3 | Closed | Fixed | N/A | Alexander Barkov | 0 | 5 | 2018-01-25 | 2018-08-31 |
| MDEV-15080 | ASAN heap-use-after-free in Query_tables_list::set_query_tables_list / Sp_handler::sp_cache_package_routine or crash in MDL_key::mdl_namespace | N/A | Closed | Duplicate | N/A | Elena Stepanova | 0 | 1 | 2018-01-26 | 2018-01-27 |
| MDEV-15107 | Add virtual Field::sp_prepare_and_store_item(), make sp_rcontext symmetric for scalar and ROW | None | Closed | Fixed | 10.3.5 | Alexander Barkov | 0 | 1 | 2018-01-29 | 2018-08-31 |
| MDEV-15416 | Crash when reading I_S.PARAMETERS | 10.2.13 | Closed | Fixed | 10.3.6 | Hartmut Holzgraefe | 1 | 5 | 2018-02-24 | 2020-08-25 |
| MDEV-15545 | crash 11 during evaluating an expression | 10.3 | Closed | Duplicate | 10.2.14, 10.3.6 | Richard Stacke | 0 | 4 | 2018-03-12 | 2020-08-25 |
| MDEV-15664 | sql_mode=ORACLE: Make TRIM return NULL instead of empty string | 10.3 | Closed | Fixed | 10.3.6 | Alexander Barkov | 0 | 1 | 2018-03-26 | 2018-03-30 |
| MDEV-15715 | sql_mode = Oracle with MariaDB 10.3.4 and Store procedure | 10.3 | Closed | Duplicate | N/A | Aurélien LEQUOY | 0 | 4 | 2018-03-29 | 2018-04-09 |
| MDEV-15739 | sql_mode=ORACLE: Make LPAD and RPLAD return NULL instead of empty string | 10.3 | Closed | Fixed | 10.3.6 | Alexander Barkov | 0 | 1 | 2018-03-30 | 2018-04-03 |
| MDEV-15830 | Assorted notes on sql_mode=ORACLE documentation | 10.3 | Open | Unresolved | 10.3, 10.4 | Elena Stepanova | 0 | 1 | 2018-04-09 | 2019-03-29 |
| MDEV-15941 | Explicit cursor FOR loop does not close the cursor | 10.3 | Closed | Fixed | 10.3.8 | Alexander Barkov | 0 | 1 | 2018-04-20 | 2018-06-20 |
| MDEV-15975 | PL/SQL parser does not understand historical queries | 10.3 | Closed | Fixed | 10.3.7 | Alexander Barkov | 0 | 1 | 2018-04-22 | 2018-05-18 |
| MDEV-16095 | Oracle-style placeholder insid | 10.3 | Closed | Fixed | 10.3.7 | Alexander Barkov | 0 | 1 | 2018-05-06 | 2018-05-08 |
| MDEV-16156 | PIPES_AS_CONCAT does not work well | 5.5, 10.0, 10.1, 10.2, 10.3, 10.4 | Open | Unresolved | 10.4 | Alexander Barkov | 0 | 2 | 2018-05-17 | 2018-10-04 |
| MDEV-16186 | Concatenation operator || returns wrong results in sql_mode=ORACLE | 5.5, 10.1, 10.2, 10.3, 10.4, 10.0 | Closed | Fixed | 10.3.7 | Alexander Barkov | 0 | 2 | 2018-05-16 | 2018-10-04 |
| MDEV-16202 | Latest changes made erroneously some keywords reserved in sql_mode=ORACLE | 10.3 | Closed | Fixed | 10.3.7 | Alexander Barkov | 0 | 1 | 2018-05-17 | 2018-05-17 |
| MDEV-16244 | sql_mode=ORACLE: Some keywords do not work in variable declarations | 10.3 | Closed | Fixed | 10.3.8 | Alexander Barkov | 0 | 1 | 2018-05-22 | 2019-07-19 |
| MDEV-16258 | sql_mode=ORACLE: Keywords from keyword_verb_clause do not work in assignments | 10.3 | Open | Unresolved | 10.3, 10.4 | Alexander Barkov | 1 | 2 | 2018-05-23 | 2019-03-29 |
| MDEV-16259 | sql_mode=ORACLE: Keywords from keyword_sp_head do not work in assignments | 10.3 | Open | Unresolved | 10.3, 10.4 | Alexander Barkov | 0 | 1 | 2018-05-23 | 2019-03-29 |
| MDEV-16360 | For every function, document exactly what type it returns | Open | Unresolved | None | Vladislav Vaintroub | 1 | 6 | 2018-05-31 | 2018-06-06 | |
| MDEV-16427 | dual table is implemented a bit flaky | Open | Unresolved | None | Oli Sennhauser | 0 | 5 | 2018-06-07 | 2018-06-21 | |
| MDEV-16464 | Oracle Comp.: Sql-Error on "SELECT name, comment FROM mysql.proc" | 10.3.7 | Closed | Fixed | 10.3.8 | Mebo | 1 | 4 | 2018-06-11 | 2018-06-13 |
| MDEV-16471 | mysqldump throws "Variable 'sql_mode' can't be set to the value of 'NULL' (1231)" | 10.3.7 | Closed | Fixed | 10.3.8 | DP | 0 | 6 | 2018-06-12 | 2018-06-21 |
| MDEV-16476 | PL/SQL CONSTANT declarations | Open | Unresolved | 10.3, 10.4 | Oli Sennhauser | 0 | 4 | 2018-06-12 | 2019-03-29 | |
| MDEV-16479 | Oracle Comp.: Sql-Error when referencing database/schema in "select package-function from dual" | 10.3.7 | Open | Unresolved | 10.3, 10.4 | Mebo | 0 | 4 | 2018-06-13 | 2019-03-29 |
| MDEV-16482 | MariaDB Oracle mode misses Synonyms | Open | Unresolved | Oli Sennhauser | 2 | 8 | 2018-06-13 | 2021-02-11 | ||
| MDEV-16497 | Oracle Comp.: Sql-Error when referencing database/schema in "select package-function from dual" | 10.3 | Open | Unresolved | 10.3, 10.4 | Mebo | 0 | 4 | 2018-06-13 | 2019-03-29 |
| MDEV-16558 | Parenthesized expression does not work as a lower FOR loop bound | 10.3 | Open | Unresolved | 10.3, 10.4 | Alexander Barkov | 0 | 1 | 2018-06-25 | 2019-03-29 |
| MDEV-16891 | EVENTs created with SQL_MODE=ORACLE fail to execute | 10.3.8 | Closed | Fixed | 10.3.9 | Hartmut Holzgraefe | 0 | 4 | 2018-08-03 | 2018-08-07 |
| MDEV-16991 | Rounding vs truncation for TIME, DATETIME, TIMESTAMP | Closed | Fixed | 10.4.1 | Alexander Barkov | 1 | 4 | 2018-08-15 | 2020-11-28 | |
| MDEV-17030 | Reset Sequence doesn't reset the value the second time. | 10.2.14 | Closed | Won't Fix | N/A | Pramod Mahto | 0 | 4 | 2018-08-22 | 2020-08-25 |
| MDEV-17253 | Oracle compatibility: The REVERSE key word for FOR loop behaves incorrectly | 10.3.9 | Closed | Fixed | 10.3.11 | Daniel Lee | 0 | 4 | 2018-09-20 | 2018-12-26 |
| MDEV-17359 | || operator is not understand by "like" in Oracle | 10.3, 10.3.9 | Closed | Fixed | 10.3.11 | Jérôme Brauge | 0 | 4 | 2018-10-03 | 2018-10-19 |
| MDEV-17375 | sql_mode=ORACLE: Incompatibility with CAST(number AS CHAR) | 10.3, 10.4 | Open | Unresolved | 10.4 | Alexander Barkov | 0 | 2 | 2018-10-05 | 2019-04-02 |
| MDEV-17387 | MariaDB Server giving wrong error while executing select query from procedure | 10.3.8 | Closed | Fixed | 10.3.11 | Nilnandan Joshi | 1 | 5 | 2018-10-08 | 2020-08-25 |
| MDEV-17389 | sql_mode=ORACLE: Incompatibility in datetime arithmetic | 5.5, 10.1, 10.2, 10.3, 10.4, 10.0 | Open | Unresolved | 10.4 | Alexander Barkov | 0 | 2 | 2018-10-08 | 2019-04-02 |
| MDEV-17652 | Add sql_mode specific tokens for some keywords | Closed | Done | 10.3.11 | Alexander Barkov | 0 | 1 | 2018-11-09 | 2018-11-11 | |
| MDEV-17660 | sql_mode=ORACLE: Some keywords do not work as label names: history, system, versioning, without | 10.3 | Closed | Fixed | 10.3.11 | Alexander Barkov | 0 | 2 | 2018-11-10 | 2018-11-11 |
| MDEV-17661 | Add sql_mode specific tokens for the keyword DECODE | Closed | Fixed | 10.3.11 | Alexander Barkov | 0 | 1 | 2018-11-10 | 2018-11-11 | |
| MDEV-17664 | Add sql_mode specific tokens for ':' and '%' | Closed | Fixed | 10.3.11 | Alexander Barkov | 0 | 1 | 2018-11-11 | 2018-11-11 | |
| MDEV-17666 | sql_mode=ORACLE: Keyword ELSEIF should not be reserved | 10.3 | Closed | Fixed | 10.3.11 | Alexander Barkov | 0 | 1 | 2018-11-11 | 2018-11-11 |
| MDEV-17669 | Add sql_mode specific tokens for the keyword DECLARE | Closed | Fixed | 10.3.11 | Alexander Barkov | 0 | 1 | 2018-11-12 | 2018-11-12 | |
| MDEV-17687 | Add sql_mode specific tokens for keywords BLOB, CLOB, NUMBER, RAW, VARCHAR2 | Closed | Fixed | 10.3.11 | Alexander Barkov | 0 | 1 | 2018-11-12 | 2018-11-14 | |
| MDEV-17694 | Add method LEX::sp_proc_stmt_statement_finalize() | Closed | Fixed | 10.4.1 | Alexander Barkov | 0 | 1 | 2018-11-13 | 2018-11-14 | |
| MDEV-17762 | PL/SQL FUNCTION arguments with IN/OUT declaration fails | 10.3.10 | Closed | Duplicate | Oli Sennhauser | 0 | 3 | 2018-11-18 | 2018-11-19 | |
| MDEV-17959 | Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed in parse_sql upon DELETE HISTORY under ORACLE mode | 10.4 | Closed | Fixed | 10.4.2 | Elena Stepanova | 0 | 2 | 2018-12-10 | 2018-12-27 |
| MDEV-18423 | Unable to unset a flag from sql_mode set to oracle | 10.3.11 | Closed | Not a Bug | N/A | Zdravelina Sokolovska | 0 | 4 | 2019-01-30 | 2019-04-17 |
| MDEV-18510 | sql_mode="oracle" does not support COMMENT statements in PL/SQL | None | Open | Unresolved | None | Manjot Singh | 0 | 6 | 2019-02-07 | 2020-12-11 |
| MDEV-18687 | SQL_MODE="ORACLE" fails to catch keywords | 10.3.12 | Open | Unresolved | 10.3, 10.4 | Adam Erickson | 1 | 4 | 2019-02-21 | 2019-03-25 |
| MDEV-18789 | Port "MDEV-7773 Aggregate stored functions" to sql_yacc_ora.yy | Closed | Fixed | 10.4.4 | Alexander Barkov | 0 | 2 | 2019-03-01 | 2019-03-01 | |
| MDEV-18813 | PROCEDURE and anonymous blocks silently ignore FETCH GROUP NEXT ROW | 10.3, 10.4 | Closed | Fixed | 10.4.4 | Alexander Barkov | 0 | 2 | 2019-03-04 | 2019-03-07 |
| MDEV-18814 | The object name is quoted as a string. | 10.3.13 | Closed | Not a Bug | N/A | Alena Subotina | 0 | 2 | 2019-03-04 | 2019-04-02 |
| MDEV-18825 | Document porting of user defined aggregate functions (UDAF) to sql_mode=ORACLE | N/A | Closed | Fixed | N/A | Ian Gilfillan | 0 | 2 | 2019-03-05 | 2019-04-10 |
| MDEV-19144 | sql_mode="oracle" does not support interval data type | Closed | Duplicate | N/A | Manjot Singh | 0 | 2 | 2019-04-02 | 2019-05-15 | |
| MDEV-19145 | sql_mode="oracle" does not support bfile data type | None | Open | Unresolved | None | Manjot Singh | 0 | 3 | 2019-04-02 | 2019-09-11 |
| MDEV-19146 | sql_mode="oracle" does not support nclob data type | None | Open | Unresolved | None | Manjot Singh | 0 | 2 | 2019-04-02 | 2019-08-01 |
| MDEV-19147 | sql_mode="oracle" does not support "long raw" data type | None | Open | Unresolved | None | Manjot Singh | 0 | 2 | 2019-04-02 | 2019-08-01 |
| MDEV-19148 | sql_mode="oracle" does not support xmltype data type | None | Open | Unresolved | None | Manjot Singh | 0 | 2 | 2019-04-02 | 2019-07-10 |
| MDEV-19149 | sql_mode="oracle" errors on DBMS_OUTPUT and subfunctions | None | Open | Unresolved | None | Manjot Singh | 0 | 4 | 2019-04-02 | 2019-09-10 |
| MDEV-19150 | sql_mode="oracle" errors on create procedure AS | 10.3.14 | Closed | Not a Bug | N/A | Manjot Singh | 0 | 5 | 2019-04-02 | 2019-09-11 |
| MDEV-19162 | Some basic datatypes and functions in oracle compatibility mode do not work | Open | Unresolved | None | Manjot Singh | 1 | 10 | 2019-04-03 | 2021-01-05 | |
| MDEV-19300 | Server crashes while executing ALTER TABLE in sql_mode=oracle | 10.2.4 | Closed | Won't Fix | 10.2.15 | Valerii Kravchuk | 0 | 2 | 2019-04-22 | 2019-07-15 |
| MDEV-19328 | sql_mode=ORACLE: Package function in VIEW | 10.3, 10.4.4, 10.4 | Confirmed | Unresolved | 10.3, 10.4 | Yuriy Kuleshov | 0 | 3 | 2019-04-25 | 2019-04-25 |
| MDEV-19476 | sql_mode="oracle" errors on create procedure AS... ORDER/NOORDER | None | Open | Unresolved | None | Austin Rutherford | 0 | 3 | 2019-05-15 | 2019-09-11 |
| MDEV-19477 | sql_mode="oracle" errors on create procedure AS ... MAXVALUE | 10.3.8 | Closed | Not a Bug | N/A | Austin Rutherford | 0 | 4 | 2019-05-15 | 2019-09-11 |
| MDEV-19488 | sql_mode="oracle" - add Oracle function NVL | None | Closed | Fixed | 10.3.0 | Austin Rutherford | 0 | 3 | 2019-05-15 | 2019-03-21 |
| MDEV-19535 | sql_mode=ORACLE: 'SELECT INTO @var FOR UPDATE' does not lock the table | 10.4 | Closed | Fixed | 10.4.6 | Alexander Barkov | 0 | 2 | 2019-05-21 | 2019-05-21 |
| MDEV-19589 | sql_mode="oracle" Rem does not work for comments | None | Open | Unresolved | None | Manjot Singh | 0 | 2 | 2019-05-24 | 2019-07-15 |
| MDEV-19590 | sql_mode="oracle" @@? @@ and @ include commands do not work | None | Open | Unresolved | None | Manjot Singh | 0 | 2 | 2019-05-24 | 2019-07-15 |
| MDEV-19632 | Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ... SELECT in ORACLE mode | 10.3, 10.3.16, 10.3.18, 10.4 | Closed | Fixed | 10.3.24, 10.4.14, 10.5.5 | Elena Stepanova | 1 | 11 | 2019-05-29 | 2020-08-01 |
| MDEV-19635 | sql_mode="oracle" should provide dbms_sql | None | Open | Unresolved | None | Manjot Singh | 0 | 3 | 2019-05-29 | 2019-07-16 |
| MDEV-19639 | sql_mode=ORACLE: Wrong SHOW PROCEDURE output for sysvar:=expr | 10.3, 10.4, 10.5 | Closed | Fixed | 10.5.0 | Alexander Barkov | 0 | 1 | 2019-05-30 | 2019-06-04 |
| MDEV-19682 | sql_mode="oracle" does not support sysdate | None | In Progress | Unresolved | 10.6 | Austin Rutherford | 0 | 3 | 2019-06-04 | 2020-11-17 |
| MDEV-19683 | sql_mode="oracle" does not support Oracle function TO_DATE | None | Open | Unresolved | None | Austin Rutherford | 0 | 2 | 2019-06-04 | 2019-09-10 |
| MDEV-19728 | Comments in SQL | 10.4.5 | Closed | Duplicate | N/A | Wolfgang Draxler | 0 | 3 | 2019-06-11 | 2019-06-12 |
| MDEV-19782 | sql_mode=ORACLE: ROWNUM | Open | Unresolved | None | Wolfgang Draxler | 1 | 6 | 2019-06-17 | 2020-11-02 | |
| MDEV-19804 | sql_mode=ORACLE: call procedure in packages | 10.4.6 | Open | Unresolved | 10.4 | Wolfgang Draxler | 0 | 1 | 2019-06-19 | 2019-06-28 |
| MDEV-19915 | sql_mode=ORACLE: call procedure with "=>" | 10.4.6 | Open | Unresolved | 10.4 | Wolfgang Draxler | 0 | 4 | 2019-07-01 | 2019-07-04 |
| MDEV-19928 | sql_mode=ORACLE: Add/Subtract numbers from date | 10.4.6 | Open | Unresolved | 10.4 | Wolfgang Draxler | 0 | 4 | 2019-07-02 | 2019-07-04 |
| MDEV-19979 | Document OTHERS as reserved word in sql_mode=ORACLE in MariaDB 10.3+ | None | Closed | Fixed | N/A | Valerii Kravchuk | 0 | 1 | 2019-07-07 | 2020-08-25 |
| MDEV-20017 | Implement TO_CHAR() Oracle compatible function | None | In Progress | Unresolved | 10.6 | Faisal Saeed | 0 | 7 | 2019-07-10 | 2021-03-05 |
| MDEV-20018 | sql_mode="oracle" does not support FULL OUTER JOIN | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20019 | sql_mode="oracle" does not support MERGE statement | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20020 | sql_mode="oracle" does not support "rownum" pseudo column | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-07-10 | 2020-11-02 |
| MDEV-20021 | sql_mode="oracle" does not support MINUS set operator | None | Open | Unresolved | 10.6 | Faisal Saeed | 0 | 6 | 2019-07-10 | 2021-01-05 |
| MDEV-20022 | sql_mode="oracle" does not support TO_NUMBER() function | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20023 | sql_mode="oracle" does not support TRUNC() function | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20024 | sql_mode="oracle" does not support LISTAGG() function | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-07-10 | 2019-09-10 |
| MDEV-20025 | ADD_MONTHS() Oracle function | 10.6 | In Progress | Unresolved | 10.6 | Faisal Saeed | 0 | 4 | 2019-07-10 | 2021-02-08 |
| MDEV-20027 | LOAD DATA INFILE - REJECTED records | None | Closed | Duplicate | N/A | Daniel Lee | 0 | 3 | 2019-07-10 | 2020-09-07 |
| MDEV-20028 | sql_mode="oracle" does not support automatic List / Interval Partitioning | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20029 | sql_mode="oracle" does not support DBMS_XML package | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20030 | sql_mode="oracle" does not support FOR ALL ... BULK COLLECT | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20031 | sql_mode="oracle" should ignore the Oracle optimizer hints from the SQL automatically | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-07-10 | 2019-09-10 |
| MDEV-20032 | sql_mode="oracle" does not support TO_TIMESTAMP() function | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20033 | sql_mode="oracle" does not support INSERT INTO ... RETURNING | None | Closed | Duplicate | N/A | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-24 |
| MDEV-20034 | sql_mode="oracle" does not support stored code returning REFCURSOR or SYS_REFCURSOR | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-07-10 | 2020-12-11 |
| MDEV-20035 | sql_mode="oracle" REGEXP_SUBSTR gives error "incorrect parameter count" | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-07-10 | 2019-09-10 |
| MDEV-20036 | sql_mode="oracle" A simple com | 10.3, 10.4, 10.5 | Open | Unresolved | None | Faisal Saeed | 0 | 4 | 2019-07-10 | 2020-12-11 |
| MDEV-20037 | FUNCTION returning a TYPE fails | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-07-10 | 2020-12-11 |
| MDEV-20039 | sql_mode="oracle" does not support Combined TRIGGERS events | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-07-10 | 2019-09-10 |
| MDEV-20134 | sql_mode="oracle" does not support keyword "ENABLE" | 10.3.13 | Open | Unresolved | None | Manjot Singh | 0 | 4 | 2019-07-23 | 2020-12-11 |
| MDEV-20238 | sql_mode="oracle" does not support "DEFAULT" parameters for functions/procedures | None | Open | Unresolved | None | Faisal Saeed | 1 | 4 | 2019-08-02 | 2019-09-10 |
| MDEV-20263 | sql_mode=ORACLE: BLOB(65535) should not translate to LONGBLOB | 10.3, 10.4, 10.5 | Closed | Fixed | 10.3.18, 10.4.8 | Alexander Barkov | 0 | 3 | 2019-08-06 | 2019-08-06 |
| MDEV-20649 | sql_mode="oracle" does not support "RAISE_APPLICATION_ERROR()" | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-23 | 2019-09-23 |
| MDEV-20650 | sql_mode="oracle" does not support ancient outer join syntax (+) | None | Open | Unresolved | None | Faisal Saeed | 0 | 3 | 2019-09-23 | 2019-03-25 |
| MDEV-20651 | sql_mode="oracle" does not support "RAISE" | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-23 | 2019-09-23 |
| MDEV-20652 | sql_mode="oracle" does not support "EXECUTE IMMEDIATE INTO" / "RETURNING" | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-23 | 2019-09-23 |
| MDEV-20657 | sql_mode="oracle" does not support DATE/TIMESTAMP with TIMEZONE | None | Closed | Duplicate | N/A | Faisal Saeed | 0 | 1 | 2019-09-24 | 2019-09-25 |
| MDEV-20658 | sql_mode=oracle does not support XMLAGG(), XMLELEMENT() and EXTRACT() XML functions | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-24 | 2019-09-24 |
| MDEV-20659 | sql_mode=oracle does not support SYSTIMESTAMP | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-24 | 2019-09-24 |
| MDEV-20660 | sql_mode=oracle does not support TO_TIMESTAMP_TZ() function | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-24 | 2019-09-24 |
| MDEV-20662 | sql_mode=oracle does not support custom EXCEPTIONs | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-09-24 | 2019-09-24 |
| MDEV-20667 | Server crash on pop_cursor | 10.3, 10.4.7, 10.4.8, 10.4 | Closed | Fixed | 10.3.22, 10.4.12 | Jérôme Brauge | 0 | 4 | 2019-09-25 | 2019-12-12 |
| MDEV-20817 | sql_mode="oracle" does not support PL/SQL Table Type | None | Open | Unresolved | None | Faisal Saeed | 0 | 2 | 2019-10-12 | 2019-10-12 |
| MDEV-20913 | sql_mode=ORACLE: INET6 does not work as a routine parameter type and return type | 10.5 | Closed | Fixed | 10.5.0 | Alexander Barkov | 0 | 1 | 2019-10-29 | 2019-10-29 |
| MDEV-20924 | Unify grammar rules: field_type_string and sp_param_field_type_string | Closed | Fixed | 10.5.0 | Alexander Barkov | 0 | 1 | 2019-10-30 | 2020-01-23 | |
| MDEV-21043 | Collect different bison %type declarations into a single chunk | Closed | Fixed | 10.5.0 | Alexander Barkov | 0 | 1 | 2019-11-13 | 2020-01-23 | |
| MDEV-21875 | Postfix for MDEV-20076: quotes in GRANT PROXY haven't been changed | 10.3, 10.4 | Open | Unresolved | 10.3, 10.4 | Elena Stepanova | 0 | 1 | 2020-03-04 | 2020-03-04 |
| MDEV-22022 | Various mangled SQL statements will crash 10.3 to 10.5 debug builds | 10.3, 10.4. 10.5 | Closed | Fixed | 10.3.26, 10.4.16, 10.5.7 | Roel Van de Paar | 0 | 4 | 2020-03-24 | 2020-10-06 |
| MDEV-22260 | Add a comment about potentially missing table options on SHOW CREATE in ORACLE mode | Closed | Fixed | N/A | Hartmut Holzgraefe | 1 | 6 | 2020-04-16 | 2020-10-15 | |
| MDEV-22625 | SIGSEGV in intern_find_sys_var (optimized builds) | 10.5.2, 10.5.3, 10.5.4 | Closed | Fixed | 10.5.4 | Roel Van de Paar | 0 | 4 | 2020-05-19 | 2020-05-29 |
| MDEV-22807 | make NULLS LAST default when sql_mode=ORACLE | Open | Unresolved | None | Nilnandan Joshi | 0 | 5 | 2020-06-05 | 2021-01-11 | |
| MDEV-22808 | Oracle Mode should result into .1 rather than 0.1 for value 0.1 with SELECT statement | Open | Unresolved | None | Pramod Mahto | 0 | 6 | 2020-06-05 | 2021-03-04 | |
| MDEV-22822 | sql_mode="oracle" cannot declare without variable errors | None | Closed | Fixed | 10.5.4, 10.3.24, 10.4.14 | Manjot Singh | 0 | 4 | 2020-05-14 | 2020-06-07 |
| MDEV-22870 | Would like sort order for sql_mode=ORACLE to match Oracle sort order | Open | Unresolved | None | Alexander Barkov | 0 | 6 | 2020-06-11 | 2021-03-05 | |
| MDEV-22923 | Data Truncation when using UNION SELECT | 10.3.23, 10.4.13 | Open | Unresolved | 10.3, 10.4, 10.5 | Thomas Christlieb | 4 | 7 | 2020-06-17 | 2021-02-25 |
| MDEV-23005 | sql_mode mixture: a table with DECODE() in a virtual column refuses to work | 10.3, 10.4, 10.5 | Open | Unresolved | 10.3, 10.4, 10.5 | Alexander Barkov | 0 | 3 | 2020-06-24 | 2020-06-29 |
| MDEV-23023 | Put compatibility functions and data types into namespaces | Open | Unresolved | 10.5 | Alexander Barkov | 0 | 2 | 2020-06-26 | 2020-08-16 | |
| MDEV-23040 | sql_mode mixture: a table with TRIM() in DEFAULT refuses to INSERT | 10.3, 10.4, 10.5 | Open | Unresolved | 10.3 | Alexander Barkov | 0 | 3 | 2020-06-29 | 2020-06-29 |
| MDEV-23094 | Multiple calls to a Stored Procedure from another Stored Procedure crashes server | 10.4.13, 10.5.4 | Closed | Fixed | 10.4.16, 10.5.7 | Björn Möller | 2 | 10 | 2020-07-04 | 2020-10-27 |
| MDEV-23108 | Point in time recovery of binary log fails when sql_mode=ORACLE | 10.3, 10.4, 10.5 | Closed | Fixed | 10.3.24, 10.4.14, 10.5.5 | Sujatha Sivakumar | 1 | 6 | 2020-07-07 | 2020-08-25 |
| MDEV-23288 | Add MariaDB_PARSER_PLUGIN | Open | Unresolved | 10.6 | Alexander Barkov | 0 | 3 | 2020-07-25 | 2020-10-28 | |
| MDEV-23353 | Qualified data types in SP | Open | Unresolved | 10.5 | Alexander Barkov | 0 | 2 | 2020-07-31 | 2020-09-24 | |
| MDEV-23479 | Add a THD* argument to Item_func_or_sum::fix_length_and_dec() | Open | Unresolved | 10.7 | Alexander Barkov | 0 | 3 | 2020-08-14 | 2021-03-15 | |
| MDEV-24067 | True DECIMAL support for bitwise operators like & | Open | Unresolved | Hartmut Holzgraefe | 0 | 3 | 2020-10-30 | 2021-02-09 | ||
| MDEV-24089 | support oracle syntax: rownum | In Review | Unresolved | 10.6 | woqutech | 0 | 6 | 2020-11-02 | 2021-01-04 | |
| MDEV-24092 | support oracle syntax: sample | Open | Unresolved | woqutech | 0 | 6 | 2020-11-02 | 2020-12-23 | ||
| MDEV-24525 | sql_mode="oracle" does not support "rowid" pseudo column | Open | Unresolved | None | woqutech.com | 0 | 3 | 2021-01-05 | 2021-01-05 | |
| MDEV-24611 | Unable to restore a Oracle package after creation | 10.3, 10.4, 10.5, 10.6, 10.3.25 | Confirmed | Unresolved | 10.3, 10.4, 10.5 | Kim Gert Nielsen | 0 | 3 | 2021-01-18 | 2020-02-01 |
| MDEV-24891 | Document mariadb_schema data type qualifier | Closed | Fixed | N/A | Alexander Barkov | 0 | 2 | 2021-02-16 | 2021-03-10 | |
| MDEV-25135 | Server crashes in Column_definition::prepare_stage1 (with different rest of stack) upon creation of SP in ORACLE mode | 10.3, 10.4, 10.5, 10.6 | Open | Unresolved | 10.3, 10.4, 10.5 | Elena Stepanova | 0 | 2 | 2021-03-14 | 2021-03-14 |
| MDEV-25158 | SIGSEGV in hp_rec_key_cmp | 10.5, 10.6 | Open | Unresolved | 10.5 | Ramesh Sivaraman | 0 | 1 | 2021-03-16 | 2021-03-23 |
| MXS-1264 | Migration plugin filter | Icebox | Closed | Won't Do | N/A | Anders Karlsson | 0 | 2 | 2017-05-11 | 2019-09-04 |
| MXS-1275 | Recognize "set SQL_MODE=ORACLE" statements | None | Closed | Done | 2.2.0 | Johan Wikman | 0 | 1 | 2017-05-24 | 2018-02-14 |
| MXS-1278 | Turn on PL/SQL dynamically. | None | Closed | Done | 2.2.0 | Johan Wikman | 0 | 2 | 2017-05-31 | 2017-10-13 |
| MXS-2080 | In SQL_MODE=ORACLE, sequence_name.nextval can get routed to slave | 2.2.13 | Closed | Not a Bug | N/A | Geoff Montee | 0 | 2 | 2017-10-04 | 2020-08-25 |
| MXS-2166 | Default SQL mode should be service specific. | Icebox | Closed | Fixed | 2.5.0 | Johan Wikman | 0 | 1 | 2018-11-13 | 2019-09-13 |
| ODBC-225 | Excel+MariaDB driver not showing list of tables | 3.1.0, 3.0.8 | Closed | Fixed | 2.0.19, 3.0.9, 3.1.1 | IT Particip | 1 | 6 | 2019-02-21 | 2019-09-23 |
| ODBC-234 | SQLGetTypeInfo does not work with sql_mode='Oracle' | 2.0.18, 3.1.0, 3.0.8 | Closed | Fixed | 2.0.19, 3.0.9, 3.1.1 | Lawrin Novitsky | 0 | 1 | 2019-03-18 | 2019-03-18 |
What is new in MariaDB sql_mode = 'oracle'?
Preparation for Oracle style PL/SQL has been taking place in MariaDB 10.2 and the PL/SQL language subset was introduced in MariaDB 10.3. In later MariaDB releases 10.4 and 10.5 there were only bug fixes. Many new or missing Oracle PL/SQL features (constants, global synonyms, dual table) have not made it into the recent releases yet. No new features were found for 10.4 and 10.5 in the MariaDB release notes:
Only two bug fixes made it: MariaDB 10.4.14 Release Notes and MariaDB 10.5.5 Release Notes.
In MariaDB 10.6 we will see the introduction of some new Oracle PL/SQL compatibility functions: Changes and Improvements in MariaDB 10.6. But still no significant new features.
Why are no new MariaDB PL/SQL features implemented?
I have no insider know-how, so I am just guessing: MariaDB is a very customer driven company. If there is not huge demand for those features and also nobody is sponsoring the new features. The introduction will be postponed until somebody wants to do the work or pay for it...
So how can you contribute to MariaDB to make those features available:
- Contribute a feature. If you need some help we assist you an make the contact to MariaDB Corp.
- Participate in MariaDB Google Summer of Code 2021.
- Pay a developer contributing the feature. Also here we can assist you.
- Pay MariaDB for implementing some features. Here we help you to negotiate and get a quote.
- Pay for a MariaDB Enterprise subscription so MariaDB Corp. has more resources available for implementing the features. We will be happy to send you a quote for MariaDB Enterprise Support Subscriptions. Then open bug reports or features requests for those features.
- Shinguz's blog
- Log in or register to post comments