| Ticket Hash: | 8f157e8010b22af03cb95f6e4f070fb4ccc07fcf | ||
| Title: | Heap Buffer Overflow in multiSelectOrderBy | ||
| Status: | Fixed | Type: | Code_Defect |
| Severity: | Minor | Priority: | Low |
| Subsystem: | Unknown | Resolution: | Fixed |
| Last Modified: |
2020-06-15 13:56:11 4.85 years |
Created: |
2020-06-14 20:14:12 4.85 years |
| Version Found In: | |||
| User Comments: | ||||
yongheng added on 2020-06-14 20:14:12:
Affect at least trunk and 3.32 release version. POC: --- CREATE TABLE a(b); CREATE VIEW c(d) AS SELECT b FROM a ORDER BY b; SELECT sum(d) OVER( PARTITION BY(SELECT 0 FROM c JOIN a WHERE b =(SELECT b INTERSECT SELECT d FROM c) AND b = 123)) FROM c; --- drh added on 2020-06-15 13:56:11: Simplified test case that does not involve window functions:
Problem first appeared in the 3.25.0 release on 2018-09-15 and seems to have been caused by the new use of transitive properties for constant propagation - the optimization identified as "3c" in the change log | ||||