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

Support of opérator || for string concatenation

    XMLWordPrintable

Details

    Description

      Oracle CONCAT function admit only two string to concat
      https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions026.htm#i77004

      Concatenation operator (||) is more used.
      https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators003.htm#i997789

      His behavior is similar to concat_ws with '' as separator
      Exemple:
      select 'a'||null||'c' from dual;
      return 'ac'

      Attachments

        Issue Links

          duplicates

          Technical task - A technical task. MDEV-11880 sql_mode=ORACLE: Make the concatenation operator ignore NULL arguments

          • Major - Major loss of function.
          • Closed
          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-11070 Providing compatibility to other databases - Phase 2

          • Major - Major loss of function.
          • Open

          Activity

            People

              bar Alexander Barkov
              halfspawn Jérôme Brauge
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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