diff options
| author | drh <> | 2022-12-12 18:58:53 +0000 |
|---|---|---|
| committer | drh <> | 2022-12-12 18:58:53 +0000 |
| commit | 89e160a96a672f283705823c8ca2e746b530f779 (patch) | |
| tree | b015128c68a199aa5992f36d6e805b95e60260b0 /ext/wasm/api/sqlite3-api-prologue.js | |
| parent | 124fc52d96f47899371782a3f3ed7f9cbf6bbeb8 (diff) | |
| download | sqlite-89e160a96a672f283705823c8ca2e746b530f779.tar.gz sqlite-89e160a96a672f283705823c8ca2e746b530f779.zip | |
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
Diffstat (limited to 'ext/wasm/api/sqlite3-api-prologue.js')
0 files changed, 0 insertions, 0 deletions