Teradata : Double quotes are generated twice in Profile name for Alter window > Preview SQL tab
1. Create Profile through Query Analyzer
CREATE PROFILE "Profile1"
GO
2. Follow bellow instructions to reprodue bug:
Go to Security node in Schema Browser
Expand Profiles node
Right click on Profile1
Select Alter Profile option
Go to Preview SQL tab
Actual Result: Twice double quotes are generated around the Profile name. And Unless we do not make any changes no script should be displayed in Preview SQL tab.
|
49 KB
In dev-356 twice double quotes are generated for profile name in Modify profile script when we try to generate modify profile script through script object to window as->Alter
Also after clicking on Alter button it gives an error message:[Teradata Database] [TeraJDBC 13.00.00.06] [Error 3706] [SQLState 42000] Syntax error: Blank name in quotation marks.
Validation check fixed so that if no modifications made, scripting will not occur.
Scripting of object name will no longer be double double quoted. This was a bug in code, now fixed.
Validation check fixed so that if no modifications made, scripting will not occur.
Scripting of object name will no longer be double double quoted. This was a bug in code, now fixed.
Verified in ADS v16.0.0-dev-15. Now the profiles won't have the double " " on Alter.
Verified in ADS v16.0.0-dev-15. Now the profiles won't have the double " " on Alter.
Issue #12315 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
1 issue link |
relates to #11531
Issue #11531Unable to rename procedure name in Alter function window in Paraccel |
In dev-356 twice double quotes are generated for profile name in Modify profile script when we try to generate modify profile script through script object to window as->Alter
Also after clicking on Alter button it gives an error message:[Teradata Database] [TeraJDBC 13.00.00.06] [Error 3706] [SQLState 42000] Syntax error: Blank name in quotation marks.