On 07/02/2018 10:54 PM, Charles Leifer wrote:
I'm getting a segfault with the following query, which uses window
functions:
Thanks for reporting this. Should now be fixed here:
https://www.sqlite.org/src/info/693b4350d7413912
Thanks also for the sum() bug report in the follow-up. That one is fixed
here:
https://www.sqlite.org/src/info/693b4350d7413912
Dan.
SELECT "t1"."counter", "t1"."value", RANK() OVER w AS "rank"
FROM "sample" AS "t1"
WINDOW w AS (PARTITION BY "t1"."counter" ORDER BY "t1"."value" DESC)
ORDER BY "t1"."counter", RANK() OVER w
The sql used to create the "sample" table:
CREATE TABLE IF NOT EXISTS "sample" (
"id" INTEGER NOT NULL PRIMARY KEY,
"counter" INTEGER NOT NULL,
"value" REAL NOT NULL);
Test data:
INSERT INTO "sample" (counter, value) VALUES (1, 10.), (1, 20.), (2, 1.),
(2, 3.), (3, 100.);
The expected output for the window query is:
1, 20., 1
1, 10., 2
2, 3., 1
2, 1., 2
3, 100., 1
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users