create OR REPLACE transient/temporary TABLE not recognized by parser

Question

create OR REPLACE transient/temporary TABLE not recognized by parser

devxor opened this issue 2 years ago · 8 comments

Describe the bug
"create OR REPLACE transient/temporary table" not recognized by parser.
Thx for quickly adding the support for "OR REPLACE TABLE"!
It seems that the "OR REPLACE" is only working with the "TABLE", but not with the Snowflake specific "TRANSIENT TABLE" or "TEMPORARY TABLE". However the support for snowflake's transient/temporary table is there e.g. "create TRANSIENT/TEMPORARY table" is working properly.
Snowflake Docs: Working with Temporary and Transient Tables

To Reproduce

CREATE OR REPLACE TRANSIENT TABLE someTable (
    someField VARCHAR(4)
)

CREATE OR REPLACE TEMPORARY TABLE someTable (
    someField VARCHAR(4)
)

Expected behavior
To get a proper output from the parser.

Answer 1 · 2022-06-07T10:50:21.000Z

@devxor aha ) because they are not added as statements - will do it today!

Answer 2 · 2022-06-07T11:06:28.000Z

Thx for the quick response!

Answer 3 · 2022-06-09T11:00:49.000Z

@xnuinside Hi! Sorry for asking, but when you will have time for the fix? Thx!

Answer 4 · 2022-06-09T11:03:09.000Z

@devxor sorry, didn't have a chance yesterday, will try today

Answer 5 · 2022-06-10T07:20:28.000Z

@devxor it wasn't so fast as I expected )) need to work on it little bit today also

Answer 6 · 2022-06-10T10:42:30.000Z

already released on 0.26.4, test - https://github.com/xnuinside/simple-ddl-parser/blob/main/tests/test_simple_ddl_parser.py#L2772 and sorry for the delay :)

Answer 7 · 2022-06-10T11:30:22.000Z

I will close the issue, will free open new) if you have some special DDL you need to parse - you can share it full & I will check if something didn't supported yet, and will add it

Answer 8 · 2022-06-10T13:59:45.000Z

@xnuinside thank you very much! It's working now! :)