We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
min(X,Y)
max(X,Y)
Quick observation that min and max don't work logically when arguments are different type. I tested between integer and real which are obvious.
min
max
integer
real
Limbo:
limbo> select min(1, 5); -- Correct 1 limbo> select min(1, 5.0); -- Incorrect 5.0 limbo> select max(1, 5.0); -- As well incorrect 1
Compared to SQLite:
sqlite> select min(1, 5); 1 sqlite> select min(1, 5.0); 1 sqlite> select max(1, 5.0); 5.0
I expect Limbo should follow SQLite logic.
The text was updated successfully, but these errors were encountered:
e910c4b
Merge 'fix: cmp integer/float' from Jean Arhancet
c738674
Closes #339 Reviewed-by: Lauri Virtanen <[email protected]> Closes #340
Successfully merging a pull request may close this issue.
Quick observation that
min
andmax
don't work logically when arguments are different type. I tested betweeninteger
andreal
which are obvious.Limbo:
Compared to SQLite:
I expect Limbo should follow SQLite logic.
The text was updated successfully, but these errors were encountered: