SQLite

Seems a newly introduced problem.

POC:
---
CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ; 
INSERT INTO v0 VALUES ( 10 ) ; 
SELECT DISTINCT v1 , lead ( v1 ) OVER( ) FROM v0 GROUP BY v1 ORDER BY 1 , 2 , 1 ;