โ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 our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.