โ06-29-2022 10:33 AM
The Problem:
I've observed erratic behavior when I add a comment containing a trailing escape character (\) to a CREATE TABLE statement.
For example, this query returns data (though it shouldn't):
CREATE TABLE example_table
SELECT 1
-- This comment has an escape character: \
WHERE 1 = 0;
SELECT * FROM example_table;
Has anyone seen this?
โ07-08-2022 06:32 AM
@Graham Carmanโ we're tracking this as a defect / issue on our side. For now, please don't include the escape character in comments.
โ06-29-2022 12:02 PM
I recommend you to go to your query plan in order to understand what is happening on the background.
Regards
โ06-30-2022 07:09 AM
Hi @Graham Carmanโ, We havenโt heard from you on the last response from @John Bocachicaโ, and I was checking back to see if his suggestions helped you. Or else, If you have any solution, please share it with the community as it can be helpful to others.
โ07-01-2022 02:59 AM
@Graham Carmanโ that's definitely odd, I can reproduce it. I'll follow up on this.
โ07-08-2022 06:32 AM
@Graham Carmanโ we're tracking this as a defect / issue on our side. For now, please don't include the escape character in comments.
โ07-10-2022 10:01 PM
Hi @Graham Carmanโ , We haven't heard from you on the last response from @Bilal Aslamโโ, and I was checking back to see if their suggestions helped you. Or else, If you have any solution, please share it with the community as it can be helpful to others.
Also, please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.
โ07-20-2022 04:05 PM
Hi @Graham Carmanโ,
Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group