[Databricks SQL] Commented Escape Character (\) Causes Unexpected Behavior

[Graham]

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?

[JBOCACHICA]

I recommend you to go to your query plan in order to understand what is happening on the background.

Regards

[Kaniz]

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.

[BilalAslamDbrx]

@Graham Carman​ that's definitely odd, I can reproduce it. I'll follow up on this.

[BilalAslamDbrx · Accepted solution]

@Graham Carman​ we're tracking this as a defect / issue on our side. For now, please don't include the escape character in comments.

[Kaniz]

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.

[jose_gonzalez]

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.