Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19683

Add support for Oracle TO_DATE()

    XMLWordPrintable

Details

    • A new function TO_DATE() has been added for compatibility with other DBMS systems. in addition to the already existing STR_TO_DATE(), which is using a different format string.
    • Q1/2026 Server Maintenance

    Description

      Implement TO_DATE(VARCHAR2 [DEFAULT return_value ON CONVERSION ERROR], VARCHAR2)

      https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/TO_DATE.html

      This could be implemented by reusing the code of str_to_date(), but using another version
      of extract_date_time()

      Attachments

        Issue Links

          blocks

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-34569 Oracle compatibility project 4

          • Major - Major loss of function.
          • Open
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38400 compat/oracle.func_to_date fails with PS protocol and cursor protocol

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38403 Server crashes in Item_func_to_date::fix_length_and_dec upon using an invalid argument

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38404 TO_DATE: MTR coverage omissions, round 1

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38509 TO_DATE: AD_DOT does not appear to be supported

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38513 TO_DATE: NULL value for format string causes assertion failure

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38514 TO_DATE: A call with wrong number of arguments causes syntax error (not standard behavior for MariaDB)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38515 TO_DATE: Result with a single NULL argument incompatible with Oracle

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38516 TO_DATE: 'J' format element not supported and not listed as unsupported

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38517 TO_DATE: (Documentation) 'IW' format element is said to be supported, but isn't

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38520 TO_DATE: Basque localization is incompatible with Oracle

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38521 TO_DATE: Date strings with non-ASCII symbols cause warnings and wrong results

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38563 TO_DATE: Missing space in view frm, unexpected syntax error in a corner case

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38578 TO_DATE: Possibly unexpected results upon wrong input

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38580 TO_DATE: Cyrillic Serbian is in fact Latin Serbian, incompatibility with Oracle

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38581 TO_DATE: NLS_DATE_LANGUAGE=EGYPTIAN does not parse values which work in Oracle

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38582 TO_DATE: NLS_DATE_LANGUAGE=JAPANESE does not parse values which work in Oracle

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38583 TO_DATE: NLS_DATE_LANGUAGE=URDU does not parse values which work in Oracle

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38584 TO_DATE: NLS_DATE_LANGUAGE=VIETNAMESE does not parse values which work in Oracle

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38585 TO_DATE: NLS_FORMAT_STRING parameter does not accept anything other than literals, incompatible with Oracle

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38586 TO_DATE: DATETIME(6) instead of DATETIME(0) when format is read from a table

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38606 TO_DATE: Assertion failure in oracle_year_2000_handling, unexpected result upon using RRRR

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38608 TO_DATE: Server crash in my_uca_strnncoll_multilevel_generic

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38627 TO_DATE: MSAN/valgrind uninitialised value errors parse_format_string

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38634 TO_DATE: A.M. etc. elements do not work without hours, incompatibility with Oracle

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38635 TO_DATE: UBSAN errors in item_timefunc.h upon comparison with a view column

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38675 TO_DATE: MSAN/Valgrind/UBSAN errors in extract_oracle_date_time

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38703 TO_DATE: Quotation for multi-word NLS_DATE_LANGUAGE leads to syntax error in view definition

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38719 TO_DATE: Assertion `&my_charset_bin != charset()' failed in String::append_for_single_quote_using_mb_wc

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work

          • Major - Major loss of function.
          • Open
          has action item

          DOCS-5934 Loading...

          links to

          Web Link Oracle docs: Working in a Global Environment

          Web Link Oracle docs: Language names for the nlsparam argument

          Activity

            People

              elenst Elena Stepanova
              austinrutherford Austin Rutherford (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.