[sqlite] Bug report: Window functions in VIEWs broken in 3.25.1

[Bjoern Hoehrmann]

Hi,

  Using the sqlite-tools-linux-x86-3250100 Linux binaries I find that
Window functions in VIEWS behave differently from PostgreSQL 9.6 and 
from what I expect.

  DROP TABLE IF EXISTS example;
  CREATE TABLE example(t INT, total INT);
  INSERT INTO example VALUES(0,2);
  INSERT INTO example VALUES(5,1);
  INSERT INTO example VALUES(10,1);

  DROP VIEW IF EXISTS view_example;
  CREATE VIEW view_example AS
  SELECT
    NTILE(256) OVER (ORDER BY total) - 1 AS nt
  FROM
    example 
  ;

  SELECT * FROM view_example;

In SQLite 3.25.1 I get 0, 0, 0, while PostgreSQL 9.6 gives 0, 1, 2.

Thanks,
-- 
https://bjoern.hoehrmann.de/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users