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.

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

Unexpected Results when Using ROUND() #7222

Closed
suyZhong opened this issue Dec 29, 2023 · 1 comment · Fixed by dolthub/go-mysql-server#2224
Closed

Unexpected Results when Using ROUND() #7222

suyZhong opened this issue Dec 29, 2023 · 1 comment · Fixed by dolthub/go-mysql-server#2224

Comments

@suyZhong
Copy link

Consider the test case below. The result of the query is different from MySQL.

SELECT ROUND('');
-- MySQL: 0
-- Dolt: Empty set

Besides, it would cause below query return an unexpected result.

SELECT 1 WHERE (ROUND('')) UNION ALL SELECT 1 WHERE (NOT (ROUND(''))) UNION ALL SELECT 1 WHERE ((ROUND('')) IS NULL);
-- Expected: 1
-- Actual: Empty set

I originally find this by building dolt from source code 3c8cc08

@max-hoffman
Copy link
Contributor

Thanks! Tagging @jycor for visibility, might not get to this one until next week because of the New Year.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants