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