]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Further fix for ticket [57c47526c34f01e8]. If a subquery has a result set
authordrh <>
Mon, 12 Dec 2022 21:22:23 +0000 (21:22 +0000)
committerdrh <>
Mon, 12 Dec 2022 21:22:23 +0000 (21:22 +0000)
commit7ca4312ff2dc94bed3897275eeb822aa286f96bb
tree8d451628c558fa8ebd11d045274f980f2f5f6046
parent33ce0b3ff34530a47e928fbce053c76db83ab3d2
parent89e160a96a672f283705823c8ca2e746b530f779
Further fix for ticket [57c47526c34f01e8].  If a subquery has a result set
column of the form "CAST(expr AS NUMERIC)" do not give that column NUMERIC
affinity.  NUMERIC affinity always goes to an integer if able, but a CAST
to numeric is a no-op if the input is a number.  So the two are not equivalent.

FossilOrigin-Name: f0325359d5795237b79f90f21b42d7d942c7e918137cb0231d404365d3041e81
manifest
manifest.uuid
test/cast.test