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

MySQL dialect must still work in sql_mode=oracle

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.0
    • 10.4(EOL)
    • Parser
    • None

    Description

      All MySQL-specific dialect expressions must work in sql_mode=oracle , (unless they really conflict with Oracle syntax - but then it may be serious limitation for some cases).

      The reasoning behind that is that some 10.2 environments may rely on that dialect with sql_mode=oracle and it may be very unfortunate if those stop working after upgrading to 10.3 .
      As example I could identify following cases in MDEV-12962 :

      1. ELSEIF stopped working in sql_mode=oracle, which recognising only ELSIF now
      2. '%' operator has gone in sql_mode=oracle (see MDEV-12977)

      Other cases must be considered as well in 10.3 oracle parser during testing / implementation.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-12962 Testing MDEV-10142 (PL/SQL parser)

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            anikitin Andrii Nikitin (Inactive) created issue -
            anikitin Andrii Nikitin (Inactive) made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Fix Version/s 10.4 [ 22408 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 81951 ] MariaDB v4 [ 140382 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]

            People

              bar Alexander Barkov
              anikitin Andrii Nikitin (Inactive)
              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.