Tested in Aqua Data Studio 14.0.3-14 Build #: 34647 on Ubuntu 12.04(Cassandra 2.0.1)
1. Problem with tablename in the "" if it is higlighted.
When highlight( select with help of mouse or SHIFT + ->) tablename and try Query/Describe for "<keyspace>"."<tablename>" or "<tablename>" you will get message "<keyspace>"."<tablename>" or "<tablename>" does not exist. Without higlighting it works normaly if cursor is in SELECT, UPDATE, INSERT statements.
2. If cursor is in statements: TRUNCATE, DROP TABLE, ALTER TABLE, CREATE TABLE, CREATE INDEX, DROP INDEX
Query/Describe gives message "Table . does not exist" except when tablename without "" is highlighted.
The behaviors described in this issue are not specific to Cassandra only, and they are expected behaviors of the Describe action.
1. The entire highlighted text is passed to the Describe action. If quotes are included in the highlighted text, they are treated as part of the table name. We don't strip the quotes because different databases support different quote identifiers.
2. The only SQL statements that the Describe action can handle are SELECT, INSERT, UPDATE, and DELETE. It can't handle DDL statements.
Issue #10712 |
Closed |
Won't Fix |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
The behaviors described in this issue are not specific to Cassandra only, and they are expected behaviors of the Describe action.
1. The entire highlighted text is passed to the Describe action. If quotes are included in the highlighted text, they are treated as part of the table name. We don't strip the quotes because different databases support different quote identifiers.
2. The only SQL statements that the Describe action can handle are SELECT, INSERT, UPDATE, and DELETE. It can't handle DDL statements.