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.