]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When the result of a subquery is to be stored in a register and that
authordrh <>
Wed, 12 Jan 2022 20:31:14 +0000 (20:31 +0000)
committerdrh <>
Wed, 12 Jan 2022 20:31:14 +0000 (20:31 +0000)
commit8efc6a8c09b359fd3c231df6884c4df6198d7de6
treedfd5cf9e9dd448d3697780ad2969667bbaba2342
parent04f97602e2c48db69e7ca7ac28ac570ae4587a59
When the result of a subquery is to be stored in a register and that
subquery has an ORDER BY clause and an OFFSET, NULL out the destination
register before starting the ORDER BY so that the register will be set
correctly even if the OFFSET is larger than the number of output rows.
Fix for the problem reported in
[forum:/forumpost/0ec80f12d02acb3f|forum post 0ec80f12d02acb3f].

FossilOrigin-Name: 9282bcde301cee2a5c3c068b5b0b7ce992c155ece894413a6a9a51a81e4133fd
manifest
manifest.uuid
src/select.c
test/subquery.test