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

Error on Distinct #528

Closed
daryllabar opened this issue Aug 13, 2024 · 2 comments · Fixed by #531
Closed

Error on Distinct #528

daryllabar opened this issue Aug 13, 2024 · 2 comments · Fixed by #531

Comments

@daryllabar
Copy link

Trying to run this query:

SELECT DISTINCT [From] FROM email 

Getting this error

Msg 10337, Level 16, State 1, Line 9
An unexpected error occurred.

System.ArgumentNullException: Key cannot be null.
Parameter name: key
See the Execution Plan tab for details of where this error occurred
@MarkMpn
Copy link
Owner

MarkMpn commented Aug 13, 2024

Interesting - can you please try this as a workaround for now?

SELECT DISTINCT [From] + '' FROM email 

@daryllabar
Copy link
Author

That appears to work.

@MarkMpn MarkMpn linked a pull request Aug 24, 2024 that will close this issue
@MarkMpn MarkMpn mentioned this issue Aug 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants