Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Q Analyzer - Auto-Completion |
| Version | Future |
Case-01: Fail
|
|
347 KB
| SQL Server 2012/14/Oracle12c | ||
| Windows | Ubuntu | |
| ADS 18-Preview-18 | Y | Y |
| ADS v17 | Y | Y |
| ADS v16 | Y | Y |
| ADS v15 | Y | Y |
| ADS v14 | Y | Y |
|
Y - Yes, issue reproduced. N-issue is not reproduced. |
||
Same issue we have seen in "Function Editor" window.
Same issue we have seen in "Function Editor" window.
@jenny: pls debug & provide your analysis on this issue.
@jenny: pls debug & provide your analysis on this issue.
Case 1: Quotes are not inserted when auto completing a table name
The "Quote Identifier for Table Completion" and "Quote Identifier for Column Completion" options are saved as document properties. The auto completion code retrieves the document properties to insert the quotes when doing auto completion.
The document properties are only set when launching the Query Analyzer window in ADS and the Edit Query dialog in VA. The document properties are not set when launching the Procedure Editor or the Function Editor. That's why quotes are not inserted.
Case 2: After WHERE, table names are in auto-completion pop-up
In the Procedure Editor or Function Editor, the SQL statement is CREATE OR REPLACE PROCEDURE, ALTER PROCEDURE, CREATE OR REPLACE FUNCTION, or ALTER FUNCTION. Currently, our SQL parser doesn't parse these SQL statements correctly. The parser always tells the auto completion code to do Table auto completion.
Case 1: Quotes are not inserted when auto completing a table name
The "Quote Identifier for Table Completion" and "Quote Identifier for Column Completion" options are saved as document properties. The auto completion code retrieves the document properties to insert the quotes when doing auto completion.
The document properties are only set when launching the Query Analyzer window in ADS and the Edit Query dialog in VA. The document properties are not set when launching the Procedure Editor or the Function Editor. That's why quotes are not inserted.
Case 2: After WHERE, table names are in auto-completion pop-up
In the Procedure Editor or Function Editor, the SQL statement is CREATE OR REPLACE PROCEDURE, ALTER PROCEDURE, CREATE OR REPLACE FUNCTION, or ALTER FUNCTION. Currently, our SQL parser doesn't parse these SQL statements correctly. The parser always tells the auto completion code to do Table auto completion.
Issue #14941 |
| New |
Completion |
| No due date |
| No fixed build |
| No time estimate |
N-issue is not reproduced.