]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 124fc52) | patch
If a subquery has a result column of the form "CAST(... AS NUMERIC)" then cast-to-numeric
authordrh <>
Mon, 12 Dec 2022 18:58:53 +0000 (18:58 +0000)
committerdrh <>
Mon, 12 Dec 2022 18:58:53 +0000 (18:58 +0000)
commit89e160a96a672f283705823c8ca2e746b530f779
treeb015128c68a199aa5992f36d6e805b95e60260b0tree
parent124fc52d96f47899371782a3f3ed7f9cbf6bbeb8commit | diff
If a subquery has a result column of the form "CAST(... AS NUMERIC)" then
give that column no affinity rather than NUMERIC affinity.  This is because
casting to numeric preserves real values that could be integers but numeric
affinity does not.  By using no affinity on the column, we make the behavior
consistent if the subquery is implemented as a co-routine or is materialized.

FossilOrigin-Name: ece07d091c2ef3367a914187e0b6512c1f2390b8c34844536ad50e88c7e8c2f2
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/select.c diff | blob | blame | history
test/cast.test diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git