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

Different result header when using CTE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 10.2.3
    • Fix Version/s: 10.2.4
    • Component/s: Optimizer - CTE
    • Labels:
      None

      Description

      CREATE TABLE transactions (timestamp int, customer_id int, amount int);
       
      SELECT timestamp, customer_id, amount, (
           SELECT sum(amount) from transactions as t2 where t2.customer_id = t1.customer_id and t2.timestamp <= t1.timestamp)
      FROM transactions AS t1
      ORDER BY customer_id, timestamp;
      

      Header results looks like this:

      +-----------+-------------+--------+------------+
      | timestamp | customer_id | amount | SELECT sum(amount) from transactions as t2 where t2.customer_id = t1.customer_id and t2.timestamp <= t1.timestamp |
      +-----------+-------------+--------+------------+
      

      WITH result as (
          SELECT timestamp, customer_id, amount, (
                  SELECT sum(amount) from transactions as t2 where t2.customer_id = t1.customer_id and t2.timestamp <= t1.timestamp)
          FROM transactions AS t1
          ORDER BY customer_id, timestamp)
      SELECT * from result;
      

      Header result looks different for the same definition.

       +-----------+-------------+--------+------------+
      | timestamp | customer_id | amount | Name_exp_4 |
      +-----------+-------------+--------+------------+
      

        Attachments

          Activity

            People

            Assignee:
            igor Igor Babaev
            Reporter:
            cvicentiu Vicențiu Ciorbaru
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: