SQLite

View Ticket
Login
Ticket Hash: e5504e987e419fb0ddd5a27ff66a79f36d1af453
Title: Segfault in sqlite3VdbeCursorMoveto
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2020-06-07 00:43:52
Version Found In:
User Comments:
yongheng added on 2020-06-06 23:21:36:
POC:
---
CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ; INSERT INTO v0 VALUES ( 4294967295 ) ; SELECT NTILE ( ( SELECT 10.100000 * SUM ( CASE WHEN v1 LIKE 'abc' THEN v1 * ( 127 - v1 ) ELSE 9223372036854775807 END ) WHERE v1 = v1 ) ) OVER( ORDER BY v1 ) - 1 AS nt , min ( v1 ) OVER( PARTITION BY v1 ORDER BY v1 ) FROM v0 WHERE v1 = 2 AND v1 IN ( SELECT v1 FROM v0 ) ;
---