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

[BUG] startswith and endswith produce the wrong value for NULL on empty string #112

Closed
revans2 opened this issue Jun 4, 2020 · 2 comments · Fixed by #256
Closed

[BUG] startswith and endswith produce the wrong value for NULL on empty string #112

revans2 opened this issue Jun 4, 2020 · 2 comments · Fixed by #256
Assignees
Labels
bug Something isn't working SQL part of the SQL/Dataframe plugin

Comments

@revans2
Copy link
Collaborator

revans2 commented Jun 4, 2020

Describe the bug
If you do a startswith or endswith searching for an empty string, and one of the data values is a null we return true while the CPU returns null

@revans2 revans2 added bug Something isn't working ? - Needs Triage Need team to review and classify SQL part of the SQL/Dataframe plugin labels Jun 4, 2020
@kuhushukla kuhushukla self-assigned this Jun 4, 2020
@revans2
Copy link
Collaborator Author

revans2 commented Jun 18, 2020

Please note that #205 should address this too. #121 provided a work around that we can do in the short term. @kuhushukla are you still planning to look at this? If not I can put something together quickly before the release.

@kuhushukla
Copy link
Collaborator

@revans2 , thanks for taking this up. I missed the ping on this one. Apologies.

tgravescs pushed a commit to tgravescs/spark-rapids that referenced this issue Nov 30, 2023
Signed-off-by: spark-rapids automation <70000568+nvauto@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working SQL part of the SQL/Dataframe plugin
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants