Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CREATE TABLE doesn't work when using multi-line comments #1404

Open
wpowers42 opened this issue Feb 1, 2024 · 0 comments
Open

CREATE TABLE doesn't work when using multi-line comments #1404

wpowers42 opened this issue Feb 1, 2024 · 0 comments

Comments

@wpowers42
Copy link

wpowers42 commented Feb 1, 2024

If I run a CREATE TABLE cell with a multi-line /* comment */ at the top, it doesn't create the table. It seems like it is running the CREATE TABLE query, but doesn't commit the transaction?

It works fine if I run it instead using a single-line -- comment.

Querybook: v3.29.0
Database: Redshift

Steps to reproduce

DROP TABLE IF EXISTS querybook_test;
/* Comment */
CREATE TABLE querybook_test AS ( SELECT 1 AS a);
SELECT * FROM querybook_test;
(psycopg2.errors.UndefinedTable) relation "querybook_test" does not exist
-- Comment
CREATE TABLE querybook_test AS ( SELECT 1 AS a);
SELECT * FROM querybook_test;
a
1

Screenshot

CleanShot 2024-01-31 at 17 11 50

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant