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

sql_mode=ORACLE: Make the CONCAT function ignore NULL arguments

    XMLWordPrintable

    Details

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

      Description

      Under terms of MDEV-11880, we fixed the concatenation operator || to ignore NULL arguments.

      In addition to the concatenation operator, Oracle has also the function CONCAT with two arguments, so these two queries should be equivalent:

      SELECT a||b FROM t1;
      SELECT CONCAT(a,b) FROM t1;
      

      The patch for MDEV-11880 changed only behavior of the concatenation operator ||.
      Under terms of this task we'll also change CONCAT to ignore NULL arguments.

        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: