SQLite

View Ticket
Login
Ticket Hash: 7be932dfa60a8a6b3b26bcf7623ec46e0a403ddb
Title: Adverse interaction between .stats and .eqp in the CLI
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2018-06-07 15:23:52
Version Found In: 3.24.0
User Comments:
drh added on 2018-06-07 15:11:38: (text/x-fossil-wiki)
The following script causes a segfault in the CLI:

<blockquote><verbatim>
CREATE TABLE t1(a,b);
INSERT INTO t1 VALUES(1,2),(99,100),(4,3);
.eqp full
.stats on
SELECT * FROM t1;
</verbatim></blockquote>

This problem appears to be a case of using a prepared statement
after it has been finalized.  The problem was introduced by
check-in [ae34edb7f4fa7b37] on 2018-03-20 and first appeared in
the version 3.23.0 release.

To be clear:  This is a problem with the command-line shell auxiliary
program that uses SQLite.  It is not a defect in SQLite itself.

This problem was discovered during internal testing and has not been
reported in the wild.