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
The count function in SQL is case sensitive and COUNT fails. But SQL functions are generally considered to be case-insensitive.
count
COUNT
import datetime df = daft.from_pydict( { "integers": [1, 2, 3, 4], "floats": [1.5, 2.5, 3.5, 4.5], "bools": [True, True, False, False], "strings": ["a", "b", "c", "d"], "bytes": [b"a", b"b", b"c", b"d"], "dates": [ datetime.date(1994, 1, 1), datetime.date(1994, 1, 2), datetime.date(1994, 1, 3), datetime.date(1994, 1, 4), ], "lists": [[1, 1, 1], [2, 2, 2], [3, 3, 3], [4, 4, 4]], "nulls": [None, None, None, None], } ) df = daft.sql("SELECT COUNT(*) FROM df").show()
This causes an exception
InvalidSQLException: Unsupported SQL: 'Function `COUNT` not found'
Both count(*) and COUNT(*) should work.
count(*)
COUNT(*)
SQL
Version 0.3.8
0.3.8
The text was updated successfully, but these errors were encountered:
[BUG]: sql functions case sensitivit (#3063)
d243cee
closes #3056
universalmind303
Successfully merging a pull request may close this issue.
Describe the bug
The
count
function in SQL is case sensitive andCOUNT
fails. But SQL functions are generally considered to be case-insensitive.To Reproduce
This causes an exception
Expected behavior
Both
count(*)
andCOUNT(*)
should work.Component(s)
SQL
Additional context
Version
0.3.8
The text was updated successfully, but these errors were encountered: