Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10142 PL/SQL parser
  3. MDEV-11880

sql_mode=ORACLE: Make the concatenation operator ignore NULL arguments

    Details

    • Sprint:
      10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

      Description

      The concatenation operator || in Oracle skips all NULL arguments and returns the result of concatenation of non-NULL arguments.
      NULL is returned only if all arguments were NULL.

      Under terms of this task we'll make the || operator work in Oracle style when sql_mode is ORACLE.

      Note, the function CONCAT won't be changed by this task.

      There is a contributed patch from Jérôme Brauge implementing this feature:

      https://lists.launchpad.net/maria-developers/msg10288.html

      It adds a new flag MODE_CONCAT_NULL_YIELDS_NULL_OFF.
      We'll probably won't add the flag and just perform the Oracle style concatenation when sql_mode & MODE_ORACLE is set.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: