/ Ticket Change Details

Artifact ID: f772d7686fa1517694f03f9e1a027ab9ae7b8669eaf50d872b705d5c3c2ce886
Ticket: 5829597ac43811e35d9fccd9b1f3b852ab6f713f
SEGV in sqlite3.c:80685 sqlite3VdbeCursorMoveto
User & Date: yongheng 2020-03-22 02:34:13

  1. icomment:
    I tested on the following version, so I thought it would exist on the release version of sqlite.
    ~: ./sqlite3
    SQLite version 3.31.0 2019-11-17 02:41:06
    Enter ".help" for usage hints.
    Connected to a transient in-memory database.
    Use ".open FILENAME" to reopen on a persistent database.
    sqlite> CREATE TABLE v0(v4 UNIQUE AS(v3), v2, v3);
    sqlite> INSERT INTO v0(v2) VALUES(0);
    sqlite> CREATE VIEW v5(v6) AS SELECT v4 FROM v0;
    sqlite> SELECT 0 FROM v5 GROUP BY v6;
    [1]    48773 segmentation fault (core dumped)  ./sqlite3
  2. login: "yongheng"
  3. mimetype: "text/plain"