SQLite

View Ticket
Login
Ticket Hash: 9fb26d37cefaba40f77fe3251ba217e14eb86030
Title: Assertion `flags3==pIn3->flags' failed.
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Virtual_Machine Resolution: Fixed
Last Modified: 2020-06-14 13:42:55
Version Found In:
User Comments:
yongheng added on 2020-06-14 03:57:16:
POC:
---
CREATE TABLE a(b VARCHAR0);
INSERT INTO a VALUES(0);
CREATE TABLE c(d e);
CREATE VIEW f(g, h) AS SELECT b, 0 FROM a UNION SELECT d, 0 FROM c;
SELECT(SELECT lead(g = g) OVER() FROM f GROUP BY h);
---

drh added on 2020-06-14 13:42:55: (text/x-markdown)
Simplified test case

~~~~~
  CREATE TABLE a(b TEXT);  INSERT INTO a VALUES(0),(4),(9);
  CREATE TABLE c(d NUM);
  CREATE VIEW f(g, h) AS SELECT b, 0 FROM a UNION SELECT d, d FROM c;
  SELECT g = g FROM f GROUP BY h;
~~~~~