cockroachdb / cockroachdb/cockroach

Certain values in comments trigger SQL failures

Open
#116,128 1 comment 0 reactions 0 assignees View on GitHub
C-bug O-community
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**

When executing a command (I was using CloudSQL Shell), if it contains "use enums", it fails, even if it is in a comment.

**To Reproduce**

In a CloudSQL Shell execute:
```
CREATE TABLE IF NOT EXISTS usage_tracking2 (
-- use enums
id INT PRIMARY KEY
);
```

**Expected behavior**
For the table to be created.

**Additional data / screenshots**

A very similar issue exists with "use it", e.g.

```
CREATE TABLE IF NOT EXISTS usage_tracking2 (
-- use it
id INT PRIMARY KEY
);
```

complains about the Database `it` not existing.

**Environment:**
- CockroachDB version: v23.1.13
- Client app: Cloud SQL via Web Browser

**Additional context**
Removed the comment for now.

Jira issue: CRDB-34443

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.