itsjunetime opened a new pull request, #11540:
URL: https://github.com/apache/datafusion/pull/11540

   ## Which issue does this PR close?
   
   Closes #11529 
   
   ## Rationale for this change
   This is a very simple implementation for the change suggested in #11529, and 
is easy to review and comprehend.
   
   ## What changes are included in this PR?
   This causes datafusion to return an error when someone attempts to execute a 
command that contains a `SHOW` statement whose variable does not exist in the 
`information_schema.df_settings` table. This provides a better UX for the user, 
as they get told exactly what's going on (with a clear error) when they execute 
this command, instead of getting an empty table as the result (which was 
happening previously).
   
   ## Are these changes tested?
   
   Yes - Additions were made to the sqllogictest tests to cover the use case 
addressed here.
   
   ## Are there any user-facing changes?
   
   I think this counts as a user-facing change - it would be easy to rely on 
the behavior of "SHOW <variable> will return an empty result if <variable> 
doesn't exist" and so it's very possible someone does rely on that. 
   
   I'd be happy to update documentation if that's necessary with this change, 
though I'm somewhat uncertain as to whether this warrants that - the previous 
behavior wasn't specified in docs, so I don't know if it is necessary here. It 
probably couldn't hurt, I think.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to