topic [Databricks SQL] Commented Escape Character (\) Causes Unexpected Behavior in Data Engineering

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

Graham — Wed, 29 Jun 2022 17:33:06 GMT

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?

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

JBOCACHICA — Wed, 29 Jun 2022 19:02:19 GMT

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

Regards

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

BilalAslamDbrx — Fri, 01 Jul 2022 09:59:39 GMT

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

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

BilalAslamDbrx — Fri, 08 Jul 2022 13:32:00 GMT

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

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

jose_gonzalez — Wed, 20 Jul 2022 23:05:15 GMT

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.