Disable Server Reistration->Permissions-> [Allow DDL Statements], then try to execute a DROP TABLE #TEMPTABLE and it will prevent, even though it should not because it is a temp table.
Worked before 14.0-dev-17, but a change in 14.0-dev-17 broken the functionality.
Might be a change to SqlParser.java in SVN 31512 : <aquadatastudio:8202>Auto complete enhancements for MongoDB support
Verified in ADS v15.0.10-3. The drop issue with temp table is now resolved. I updated the "Edit Server Properties" to the exact ones as in the attached screenshot for the test. Works in Sybase ASE, Sybase IQ, Sybase Anywhere and SQL Server.
Issue #12687 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 15.0.10-3 |
No time estimate |
1 issue link |
is broken by #8202
Issue #8202Auto complete enhancements for MongoDB support |
Verified in ADS v15.0.10-3. The drop issue with temp table is now resolved. I updated the "Edit Server Properties" to the exact ones as in the attached screenshot for the test. Works in Sybase ASE, Sybase IQ, Sybase Anywhere and SQL Server.