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

compat/oracle.func_to_date fails with PS protocol and cursor protocol

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • N/A
    • 12.3
    • Tests, MTR
    • None

    Description

      https://buildbot.mariadb.org/#/builders/534/builds/32679/steps/6/logs/stdio

      bb-12.3-MDEV-19683-to_date 98b01265df03446ce9a861e044e3cde19225afe4

      compat/oracle.func_to_date               w7 [ fail ]
              Test ended at 2025-12-19 22:33:52
      CURRENT_TEST: compat/oracle.func_to_date
      --- /home/buildbot/amd64-ubuntu-2204-debug-ps/build/mysql-test/suite/compat/oracle/r/func_to_date.result	2025-12-19 22:14:48.000000000 +0000
      +++ /home/buildbot/amd64-ubuntu-2204-debug-ps/build/mysql-test/suite/compat/oracle/r/func_to_date.reject	2025-12-19 22:33:52.516947261 +0000
      @@ -242,8 +242,6 @@
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=VICTORIAN');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=VICTORIAN')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: NLS_CALENDAR=VICTORIAN in function to_date.
       SELECT TO_DATE('January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = German');
       TO_DATE('January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = German')
       NULL
      @@ -254,32 +252,18 @@
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_XX=YYY');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_XX=YYY')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: NLS_XX=YYY in function to_date.
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', '=YYY');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', '=YYY')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: =YYY in function to_date.
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'XX=');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'XX=')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: XX= in function to_date.
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'XX=');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'XX=')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: XX= in function to_date.
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'A=B C=');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'A=B C=')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: A=B in function to_date.
      -Warning	3047	Invalid argument error: C= in function to_date.
       SELECT TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'A=B =D');
       TO_DATE('2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'A=B =D')
       2024-11-01 00:00:00
      -Warnings:
      -Warning	3047	Invalid argument error: A=B in function to_date.
      -Warning	3047	Invalid argument error: =D in function to_date.
      Result length mismatch
      

      Attachments

        Issue Links

          Activity

            People

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