SQLite: View Ticket

2020-06-14
13:42		• Fixed ticket [9fb26d37]: Assertion `flags3==pIn3->flags' failed. plus 6 other changes (artifact: ea0dfdf786 user: drh)
13:40		Check-in [1d4f86201dab9a22] changed a testcase() to an assert() because we didn't know how to reach that condition any more. But YongHeng's fuzzer found a way. So now we change it back. Ticket [9fb26d37cefaba40]. (check-in: 90b1169d1b user: drh tags: trunk)
03:57		• New ticket [9fb26d37] Assertion `flags3==pIn3->flags' failed.. (artifact: 5c0fa89b79 user: yongheng)

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:

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;