I was able to reproduce this behaviour using much shorter query (in
sqlite.exe 3.27.1):
SELECT + sum(0) OVER() ORDER BY + sum(0) OVER();
SELECT + avg(0) OVER() ORDER BY + avg(0) OVER();
SELECT 1 + avg(0) OVER() ORDER BY 1 + avg(0) OVER();
SELECT - - - - - avg(0) OVER() ORDE
?SELECT(+++ last_insert_rowid()++sum(0)oVER())ORDER BY
(+++ last_insert_rowid()++sum(0)oVER())ORDER BY
1,1,1,1,1,1?
Best regards
Longfei Fan from 360 Codesafe Team of Legendsec?
___
sqlite-users mailing
2 matches
Mail list logo