| 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 ) ; --- | ||||