SQLite Forum

segmentation fault occured
Login

segmentation fault occured

(1) By youngjooko (y0108009) on 2021-05-24 12:48:16 [link]

During using SQLite, segmentation fault occured.

I sent 

CREATE TABLE v0 ( v2 INTEGER AS( ( 'x' IN ( 0 , 0 , 10 , NOT ( v1 ) IS NULL , 1 , 10 , 10 , 1 , 9223372036854775807 ) ) ) UNIQUE , v1 UNIQUE ) ; 
CREATE VIEW v3 AS SELECT DISTINCT * , v1 , sum ( DISTINCT v2 ) FROM v0 GROUP BY v2 , v2 ; 
SELECT DISTINCT ( random () % 10 ) FROM v3 NATURAL JOIN v3 JOIN v3 , v0 , v3;

to SQLite then the SQLite crashed.

The version is 3.36.

(2) By Richard Hipp (drh) on 2021-05-24 14:13:11 in reply to 1 [link]

> The version is 3.36.

"Version 3.36.0" can refer to any of [274 different check-ins][1].
Which of these specifically are you using.  I ask because
I cannot seem to recreate your problem.

[1]: src:/timeline?d=5cee689d647087a5&n=274&nd

(3) By youngjooko (y0108009) on 2021-05-25 04:53:28 in reply to 2 [link]

The git log shows that the last commit ID is 252d582a35d4e24fbd9311ee98b18730543d9622.

Thank you for your attention.

(4) By Richard Hipp (drh) on 2021-05-25 12:43:38 in reply to 3 [link]

SQLite does not use Git.  SQLite uses [Fossil][1].  The Fossil check-in
that corresponds to Git 252d582a35d4e24f is
[c22e47c77a35ebcd](src:/timeline?c=c22e47c77a35ebcd).  That check-in
occurred 48 days ago on 2021-04-07.  The bug you report was fixed
on the following day (2021-04-08) by
check-in [0e4789860b81c31d](src:/timeline?c=0e4789860b81c31d).

[1]: https://fossil-scm.org/

(5) By Richard Hipp (drh) on 2021-05-25 13:27:46 in reply to 3

[This graph][1] shows an abbreviated sequence of check-ins starting with
the first check-in labeled as "3.36.0" and ending with the latest check-in
at the time this problem was reported.  The sequence shows:

  1.  Where the bug was fixed
  2.  The check-in against which the bug was reported (highlighted)
  3.  Where the bug was introduced

Snarky rhetorical question:  How would you display this kind of information
using Git?

[1]: https://sqlite.org/src/timeline?bid=y5cee689dy7aca8dy26b005a9nef4ac0dnc22e47cn466f5089y0e47898&c=c22e47c77a