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

Window functions without column references get removed from ORDER BY

    XMLWordPrintable

    Details

      Description

      create table t1 (id int, first_name varchar(100), last_name varchar(100), score double);
      create index t1_name on t1 (first_name, last_name);
      insert into t1 values
      (1, 'Alice', 'Fowler', 5),
      (2, 'John', 'Doe', 6),
      (3, 'John', 'Smith', 6),
      (4, 'John', 'Smith', 6),
      (5, 'John', 'Smith', 7),
      (6, 'John', 'Elton', 8.1),
      (7, 'Bob',  'Trasc', 9),
      (8, 'Silvia', 'Ganush', 10);
      select first_name fn, last_name ln, row_number() over () rn
      from t1
      order by rn desc;
      

      fn	ln	rn
      Alice	Fowler	1
      Bob	Trasc	2
      John	Smith	3
      John	Smith	4
      John	Smith	5
      John	Elton	6
      John	Doe	7
      Silvia	Ganush	8
      

      The DESC keyword is being ignored.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated: