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

has_table does not check the existence of volatile tables #86

Open
Similacrest opened this issue Jul 19, 2019 · 1 comment
Open

has_table does not check the existence of volatile tables #86

Similacrest opened this issue Jul 19, 2019 · 1 comment

Comments

@Similacrest
Copy link

Similacrest commented Jul 19, 2019

engine.execute('CREATE VOLATILE TABLE test(id BIGINT) UNIQUE PRIMARY INDEX (id) ON COMMIT PRESERVE ROWS;')

engine.has_table('test')

False

Maybe check

HELP VOLATILE TABLE

too?

@sandan
Copy link
Member

sandan commented Oct 14, 2019

@ShareDVI has_table currently looks at TableKinds in teradatasqlalchemy:
O - non-partitioned tables
T - partitioned tables
V - views

The Teradata SQLEngine doesn't keep volatile tables in the data dictionary since it is non-persistent. Perhaps we can add a has_volatile_table to the dialect?

Also, be aware that teradatasqlalchemy will be succeeding sqlalchemy-teradata as the primary dialect. Any changes will be pushed to teradatasqlalchemy.

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

2 participants