When using a drop statement with enabled team coding option, it is possible to drop a database object without logging in VCS. Other statements (alter, create or replace...) works well.
With the latest version of Toad configured with team coding and GIT , you cannot alter an object if not logged in VCS (as expected) but can drop a table.
To reproduce the issue follow the steps below:
1. Configure Toad with git
2. Do not log into VCS
3. Try to alter a table. Toad will ask you to login GIT as expected.
4. If you click cancel, Toad will insist but if you click cancel again, you will get a message saying the objects were checked out by Team Coding
and then the log will show:
'Cannot check-out tabls; VCS Provider is not logged in.
Error: Table must be checked out to edit'
Therefore, you cannot alter the table as expected.
5. But, if you follow the same steps but with a DROP statement instead to drop a table, Toad will ask you to login to the VCS, but If you click cancel, you get a message in the Editor, showing that the table was dropped successfully.
The Logs show:
'Output: Cannot delete table: VCS Provider is not logged in'
Note: you can drop the table even when logged into Git with Toad - (There are no additional prompts).
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center