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 | abhishekj(*) |
| Priority | Critical |
| Complexity | Unknown |
| Component | Tools - Schema Script Gen |
| Version | 18.0 |
Execute the attached uddt_scripts_1.sql on SQL SERVER 2000.
Now Open Schema Script Generator for same server.
Select 'User Defined Data Types' from object list.
Result - It is observed that no objects are shown in Objects panel.
Please refer screenshot.
| ADS Version | Operating System | |||||||
| Windows | Linux | OSX | MS SQL 2000 | MS SQL 2005 | MS SQL 2008 | MS SQL 2012 | MS SQL 2014 | |
| v18 | Y | Y | Y | Y | N | N | N | N |
| v17 | Y | Y | Y | Y | N | N | N | N |
| v16 | Y | Y | Y | Y | N | N | N | N |
| v15 | N | N | N | N | N | N | N | N |
|
367 B
|
|
109 KB
|
|
87 KB
|
|
45 KB
|
|
173 KB
|
|
87 KB
Extraction fix that will make sure versions 2000 and below add the uddt to the list of uddts when the schema even though schema is blank. 2000 and below didn't have schemas, but we simulate owner as schema.
Committed revision: 52958
pls verify and close.
pls verify and close.
Verified and Closed in v18.0.0-Preview-52
Please refer to the screenshot : 14978_P52.png
Verified and Closed in v18.0.0-Preview-52
Please refer to the screenshot : 14978_P52.png
RE-OPEN:
The revision made above in this issue has broken the schema sync dependencies functionality for SQL server on all the versions.
Please execute below script to reproduce the issue:
CREATE TYPE [t1_1_UDT] FROM numeric(10,0) NULL GO CREATE TABLE abc ( c1 t1_1_UDT NOT NULL ) GO
When table is selected for deployment, ADS is not showing dependencies of table on UDT in RD tab.
Please refer the attachment.
The changes made in ExtractDataType#getDataTypeList() causes the issues. You might want to take a look at flag created v2000EqualOrGreater or the else block added at line #917.
RE-OPEN:
The revision made above in this issue has broken the schema sync dependencies functionality for SQL server on all the versions.
Please execute below script to reproduce the issue:
CREATE TYPE [t1_1_UDT] FROM numeric(10,0) NULL GO CREATE TABLE abc ( c1 t1_1_UDT NOT NULL ) GO
When table is selected for deployment, ADS is not showing dependencies of table on UDT in RD tab.
Please refer the attachment.
The changes made in ExtractDataType#getDataTypeList() causes the issues. You might want to take a look at flag created v2000EqualOrGreater or the else block added at line #917.
The previous fix was suppose to be made for 2000 and below but was accidently done for 2000 and above. extraction fixed, please retest.
Committed revision: 53005
The previous fix was suppose to be made for 2000 and below but was accidently done for 2000 and above. extraction fixed, please retest.
Committed revision: 53005
When table is selected for deployment, ADS is showing dependencies of table on UDT in RD tab.
Please refer the 14978_P56.png
Also UDT's are extracted in schema script generator in MSSQL Server 2000
Please refer the UDT_14978_P56.png
Verified in v18.0.0-Preview-56
When table is selected for deployment, ADS is showing dependencies of table on UDT in RD tab.
Please refer the 14978_P56.png
Also UDT's are extracted in schema script generator in MSSQL Server 2000
Please refer the UDT_14978_P56.png
Verified in v18.0.0-Preview-56
Issue #14978 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.0-preview-55 |
| No time estimate |
Extraction fix that will make sure versions 2000 and below add the uddt to the list of uddts when the schema even though schema is blank. 2000 and below didn't have schemas, but we simulate owner as schema.
Committed revision: 52958