SQLite

This is test3.sql from forum post d24ec63447:

CREATE  TABLE  IF  NOT  EXISTS dbstat(pagetypeREAL);
CREATE  TEMPORARY  TABLE  IF  NOT  EXISTS dbstat AS  SELECT  ALL dbstat.*, *, *, *, *, *, dbstat.*, *, *, *, *, *, *, *, *, *, *, *, *, *, '%Y-%m-%d', *, *, *, *, * FROM (dbstat AS dbstat NOT  INDEXED , sqlite_schema AS dbstat NOT  INDEXED ) GROUP  BY  FALSE  HAVING  FALSE  ORDER  BY 5e200 NULLS  FIRST;
ALTER  TABLE dbstat ADD  COLUMN pagetype CONSTRAINT constr1 GENERATED  ALWAYS  AS ( RAISE ( IGNORE )->> FALSE  OR  FALSE );
SELECT * FROM dbstat;

Unable to recreate the problem using ASAN or Valgrind. Possible an instrumentation error on the part of the original reporter. The reported instrumentation puts the problem in the CLI, not the core SQLite library, on the main input buffer. A few extra bytes of space are now added on the end of that buffer as a safety margin.

Reopened

The problem is that the sqlite3_error_offset() routine is returning a valid that is out-of-range for its input. Two errors: First, the sqlite3_error_offset() is returning an out-of-range value. Second, the CLI code that uses sqlite3_error_offset() is failing to properly deal with the out-of-range return value.

Reproducible test case (run under valgrind):

CREATE TABLE t1 AS SELECT *,*,*,*,*,*,* FROM sqlite_schema;
ALTER TABLE t1 ADD path GENERATED ALWAYS AS (no_such_function(1));
SELECT * FROM t1;