Skip to content

Fix numeric compare affinity for SQLite#989

Merged
mvorisek merged 3 commits intodevelopfrom
sqlite_float_bind
Nov 15, 2023
Merged

Fix numeric compare affinity for SQLite#989
mvorisek merged 3 commits intodevelopfrom
sqlite_float_bind

Conversation

@mvorisek
Copy link
Copy Markdown
Member

@mvorisek mvorisek commented May 2, 2022

fix #950

in theory, the fix should be done on whole SQL AST, but such approach requires AST parser, so for simplicity, the fix is done on comparison expressions created using Query::where() method only

@mvorisek mvorisek added the bug label May 2, 2022
@mvorisek mvorisek changed the title Fix float value bind for Sqlite Fix numerical compare for Sqlite May 2, 2022
@mvorisek mvorisek changed the title Fix numerical compare for Sqlite Fix numeric compare for Sqlite May 2, 2022
@mvorisek mvorisek force-pushed the sqlite_float_bind branch 10 times, most recently from f3bc2d8 to c7b3b9d Compare May 6, 2022 22:10
@mvorisek mvorisek added the MAJOR label May 6, 2022
@mvorisek mvorisek changed the title Fix numeric compare for Sqlite Fix numeric compare May 6, 2022
@mvorisek mvorisek force-pushed the sqlite_float_bind branch 11 times, most recently from 5c18e4b to b5d0903 Compare May 7, 2022 17:28
@mvorisek mvorisek force-pushed the sqlite_float_bind branch 3 times, most recently from 5910acb to 2b639aa Compare May 30, 2022 12:35
@mvorisek mvorisek force-pushed the sqlite_float_bind branch from 2b639aa to dcad20f Compare June 25, 2022 08:43
@mvorisek mvorisek force-pushed the sqlite_float_bind branch 9 times, most recently from 781b4ea to a5c4309 Compare October 28, 2023 20:41
@mvorisek mvorisek changed the title Fix numeric compare for SQLite Fix numeric affinity for SQLite Oct 28, 2023
@mvorisek mvorisek force-pushed the sqlite_float_bind branch 7 times, most recently from e2f26c5 to 830fc0b Compare October 28, 2023 23:37
@mvorisek mvorisek changed the title Fix numeric affinity for SQLite Fix numeric compare affinity for SQLite Oct 29, 2023
@mvorisek mvorisek force-pushed the sqlite_float_bind branch 7 times, most recently from 93161aa to 5ceb93a Compare October 31, 2023 14:07
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Development

Successfully merging this pull request may close these issues.

SQLite does not compare integer/float values correctly

1 participant