Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4450

random query generator: prefer || for postgres string concatenation

    Details

      Description

      If Impala CONCAT() has an argument that evaluates to NULL, then Impala
      CONCAT() returns NULL.

      If PostgreSQL CONCAT() has an argument that evaluates to NULL, then
      PostgreSQL will ignore it, and treat it as an empty string. Even
      CONCAT(NULL) evaluates to the empty string.

      PostgreSQL has a || operator that behaves like Impala CONCAT(): if a
      NULL expression is on one side of ||, that || evals to NULL

      For the Postgres SQL writer, we need to write logical concatenation as the || operator, not the CONCAT() function.

        Attachments

          Activity

            People

            • Assignee:
              mikesbrown Michael Brown
              Reporter:
              mikesbrown Michael Brown
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: