See support issue #172
I can't see User-Defined Table Type. The application does not allow displaying the types of data defined by the user, when they are of a table type.
Our DB platform is Azure Sql Server.
My question is about user-defined data types, because in SQL Server I use two types:
User-Defined Data Types
User-Defined Table Types
In Aqua Data I can only see the User-Defined Data Types, but nowhere are the Use-Defined Table Types shown.
Attached is an image extracted from SQL Server Management Studio, and another from Aqua Data Studio.
316 KB
166 KB
182 KB
106 KB
5 KB
Revision no. 57568
Author: harish.khattri
Revision no. 57569
Author: harish.khattri
Revision no. 57568
Author: harish.khattri
Revision no. 57569
Author: harish.khattri
Revision no. 57572
Author: harish.khattri
Revision no. 57572
Author: harish.khattri
Revision no. 57575
Author: harish.khattri
Revision no. 57575
Author: harish.khattri
Revision no. 57577
Author: harish.khattri
Revision no. 57577
Author: harish.khattri
This is working fine on build 29.
Test cases added to testrail : Test cases URL
Thanks,
Bhushan
Revision no. 57588
Author: harish.khattri
Revision no. 57588
Author: harish.khattri
This is working fine on build 31.
Test cases updated to testrail : Test cases URL
Thanks,
Bhushan
Automation test result
Automation test result
Revision no. 57607
Author: harish.khattri
Revision no. 57607
Author: harish.khattri
The automation TC_15738_UserDefined_TableType_Schema_Script_Microsoft_SQL_Azure_(RTM)_-_12.0.2000.8 test case failed even after many retries. See results here: Automation-V20.6_Nhi_03_03_20
It failed at line 183 of TC_15738/Steps.cs::CreateSchemaScript() method. The repository object cannot be located: repo.ScriptGeneratorMicrosoftSQLAzure.PreviewInfo.WaitForItemExists(30000)
Looking at the code further up, there are no steps to configure the schema script generation for show the results as Preview. The if preview is expected then you must add steps in the automation to configure for preview. Please fix this.
The automation TC_15738_UserDefined_TableType_Schema_Script_Microsoft_SQL_Azure_(RTM)_-_12.0.2000.8 test case failed even after many retries. See results here: Automation-V20.6_Nhi_03_03_20
It failed at line 183 of TC_15738/Steps.cs::CreateSchemaScript() method. The repository object cannot be located: repo.ScriptGeneratorMicrosoftSQLAzure.PreviewInfo.WaitForItemExists(30000)
Looking at the code further up, there are no steps to configure the schema script generation for show the results as Preview. The if preview is expected then you must add steps in the automation to configure for preview. Please fix this.
The automation test cases seem to take a long time to complete. This is due to several long sleep statements after the create database step. This is not the correct way. Rather than unconditionally doing the sleep, it should wait just long enough for the create database to complete. I've checked in my suggested fix for this in SVN #24101. Basically I've replaced all of the sleep calls with a single call to repo.AquaDataStudio6CreateDatabaseTxt.ResultsInfo.WaitForItemExists(60000). The will wait up to 1 minute for the create database to complete, but will return as soon as the create database is done. This is the preferred way of doing things. Please review the suggested changes and make any corrections that you feel is necessary. Please apply this approach when you try to fix issues in other areas.
The automation test cases seem to take a long time to complete. This is due to several long sleep statements after the create database step. This is not the correct way. Rather than unconditionally doing the sleep, it should wait just long enough for the create database to complete. I've checked in my suggested fix for this in SVN #24101. Basically I've replaced all of the sleep calls with a single call to repo.AquaDataStudio6CreateDatabaseTxt.ResultsInfo.WaitForItemExists(60000). The will wait up to 1 minute for the create database to complete, but will return as soon as the create database is done. This is the preferred way of doing things. Please review the suggested changes and make any corrections that you feel is necessary. Please apply this approach when you try to fix issues in other areas.
Verfiied on ADS 20.6 RC3 on windowss,mac and ubuntu machine
with AZURE database, verified creation of user defined table types ,drop and script generation
test result
https://idera.testrail.net/index.php?/runs/view/3225&group_by=cases:section_id&group_order=asc&group_id=21890
Verfiied on ADS 20.6 RC3 on windowss,mac and ubuntu machine
with AZURE database, verified creation of user defined table types ,drop and script generation
test result
https://idera.testrail.net/index.php?/runs/view/3225&group_by=cases:section_id&group_order=asc&group_id=21890
Issue #15738 |
Verified |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 20.6.0-dev-40-no-ofsc |
No time estimate |
USER DEFINED TABLE TYPE - Create
INDIVIDUAL NODES
GUI OPERATIONS
Create
Drop
Properties
NO EDIT TABLE DATA
NO SELECT TOP 1000
SCRIPTING TO WINDOW, NEW WINDOW, FILE
Create
Drop
INDIVIDUAL NODES
GUI OPERATIONS
None
SCRIPTING
None
These commands will need to be added in the code. The underlying gui menu's will need to be created to support the create for each object. Additionally, we will need to provide the underlying code to support the scripting features mentioned above. This also includes the Schema Script Generator.