SQLite

View Ticket
Login
Plaintext
2020-06-14
13:42 • Fixed ticket [9fb26d37]: Assertion `flags3==pIn3->flags' failed. plus 6 other changes (artifact: ea0dfdf7 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: 90b1169d user: drh tags: trunk)
03:57 • New ticket [9fb26d37] Assertion `flags3==pIn3->flags' failed.. (artifact: 5c0fa89b 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;