Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQLite does not compare integer/float values correctly #950

Closed
mvorisek opened this issue Jan 5, 2022 · 0 comments · Fixed by #989
Closed

SQLite does not compare integer/float values correctly #950

mvorisek opened this issue Jan 5, 2022 · 0 comments · Fixed by #989
Labels
bug

Comments

@mvorisek
Copy link
Member

mvorisek commented Jan 5, 2022 •
edited
Loading

https://dbfiddle.uk/9zyERqwV

SELECT 1.5 > '1';
SELECT 1.5 > '1.2';
SELECT 1.5 > ('1' + 0);
SELECT 1.5 > ('1.2' + 0);
SELECT typeof('1' + 0);
SELECT typeof('1.2' + 0);

https://dba.stackexchange.com/questions/311555/sqlite-spec-4-2-type-conversions-prior-to-comparison

https://dba.stackexchange.com/questions/332585/sqlite-comparison-of-the-same-operand-types-behaves-differently

https://sqlite.org/forum/info/0f96b67cf2c39ed4
@mvorisek mvorisek added the bug label Jan 5, 2022
@mvorisek mvorisek added the MAJOR label Apr 15, 2022
@mvorisek mvorisek mentioned this issue May 2, 2022
Merged
@mvorisek mvorisek removed the MAJOR label Oct 27, 2023
@mvorisek mvorisek changed the title Sqlite does not compare float values correctly SQLite does not compare float values correctly Oct 27, 2023
@mvorisek mvorisek changed the title SQLite does not compare float values correctly SQLite does not compare integer/float values correctly Nov 15, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix numeric compare affinity for SQLite atk4/data
1 participant
@mvorisek