SQLite: View Ticket

Ticket Hash:	2971fbe3f993e95a1f5ef4acd39c8d370b94c31a
Title:	Heap buffer overflow on SQL input (3)
Status:	Fixed	Type:	Incident
Severity:	Minor	Priority:	Low
Subsystem:	Shell	Resolution:	Fixed
Last Modified:	2023-03-17 00:45:50 2.14 years ago	Created:	2023-03-16 20:26:32 2.14 years ago
Version Found In:	3.41.1

User Comments:

drh added on 2023-03-16 20:26:32:

This is test5.sql from forum post d24ec63447:

CREATE  TEMPORARY  TABLE t2 AS  WITH  RECURSIVE sqlite_temp_schema AS ( VALUES (X'53514C697465')) SELECT  ALL *, *, *, *, *, *, *, *, * FROM (temp.sqlite_temp_schema), ( VALUES ( NOT  CURRENT_TIME ,  CURRENT_TIME )) AS t2;
ALTER  TABLE t2 ADD  COLUMN c0 CONSTRAINT constr1 AS (rootpage BETWEEN (rootpage) NOT  NULL  AND (((rootpage) NOT  IN (((rootpage) NOT  NULL ) NOT  NULL )) NOT  NULL ) NOTNULL ->>(rootpage) NOT  NULL );
SELECT * FROM t2;

drh added on 2023-03-17 00:45:50:

Same as [33aa4c0de8a62e33]