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 | Minor |
| Complexity | Unknown |
| Component | Q Analyzer - Auto-Completion |
| Version | 19.0 |
create procedure spTest
as
select *
from dbtest..tabletest t
where t.___
return
go
|
|
112 KB
|
|
109 KB
|
|
134 KB
As part of this issue, see if scenario 2 is resolved in: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/14941?tab=comment#8A37887A-7F6A-6DF9-76C4-5CA09856D353
I have added preliminary support for CREATE [PROCEDURE | FUNCTION] and ALTER [PROCEDURE | FUNCTION]. Note we are not offering full DDL syntax support for autocompletion in these statements, for examples, procedures and functions with control flow constructs (IF ELSE, WHILE, etc.) are not guaranteed to work.
@qa - when verifying/regression testing this functionality, please note:
1. Single statements (separated by GO) functionality should remain identical to v18 (i.e. no regression)
2. Support for multiple statements in the CREATE ... scope (without the statement separators) might be limited. I think we will likely tweak this on a case by case basis.
I have added preliminary support for CREATE [PROCEDURE | FUNCTION] and ALTER [PROCEDURE | FUNCTION]. Note we are not offering full DDL syntax support for autocompletion in these statements, for examples, procedures and functions with control flow constructs (IF ELSE, WHILE, etc.) are not guaranteed to work.
@qa - when verifying/regression testing this functionality, please note:
1. Single statements (separated by GO) functionality should remain identical to v18 (i.e. no regression)
2. Support for multiple statements in the CREATE ... scope (without the statement separators) might be limited. I think we will likely tweak this on a case by case basis.
Verified in ADS 19 beta 36 build.
Tested on SQL Server 14 , PostgreSQL and Mysql databases.
Verified in ADS 19 beta 36 build.
Tested on SQL Server 14 , PostgreSQL and Mysql databases.
Issue #15414 |
| Verified |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 19.0.0-beta-35 |
| No time estimate |
1 issue link |
is a duplicate of #12663
Issue #12663allow autocompletion within CREATE [PROC|FUNCTION|VIEW, etc] body of procedures in the editor |
As part of this issue, see if scenario 2 is resolved in: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/14941?tab=comment#8A37887A-7F6A-6DF9-76C4-5CA09856D353