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

TO_DATE: NLS_DATE_LANGUAGE=EGYPTIAN does not parse values which work in Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 12.3
    • Server
    • None

    Description

      The one-line test case is also attached as a file, in case JIRA corrupts the string.

      Oracle

      SELECT TO_DATE('15 ابريل 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=EGYPTIAN') AS x FROM DUAL;
       
      X
      15-APR-24
      

      bb-12.3-MDEV-19683-to_date f45636ea81a5a02444833e993e47c262ed52f384

      MariaDB [test]> SELECT TO_DATE('15 ابريل 2024','DD MONTH YYYY','NLS_DATE_LANGUAGE=EGYPTIAN') AS x FROM DUAL;
      +------+
      | x    |
      +------+
      | NULL |
      +------+
      1 row in set, 1 warning (0.001 sec)
       
      MariaDB [test]> show warnings;
      +---------+------+---------------------------------------------------------------------+
      | Level   | Code | Message                                                             |
      +---------+------+---------------------------------------------------------------------+
      | Warning | 1411 | Incorrect datetime value: '15 ابريل 2024' for function to_date      |
      +---------+------+---------------------------------------------------------------------+
      1 row in set (0.000 sec)
      

      I have no idea what would be the right string for MariaDB. Also, maybe it somehow gets corrupt between the client and the server, although it looks the same to me in the warning.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.