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 | App - Visual Editing |
| Version | Future |
Database version: Teradata :14.0
CREATE FUNCTION tduser.MYUDF
(D int, E int, F int)
RETURNS int
// langugae sql
contains sql
DETERMINISTIC
sql SECURITY
DEFINER collation INVOKER
INLINE TYPE 1
return D+E-F
;
|
|
221 KB
|
|
116 KB
|
|
118 KB
If I rename a function in Teradata and change its name in the General Tab Name text box and under the Function text, I get no errors (See pic works)
But if i rename a function and change only its name in the Name: text box as in (does_not_work screenshot) I get an error message. So during a rename do we just need the Rename Function ... or do we also require the Replace Function as in the below SQL ?
RENAME FUNCTION MYUDF (INTEGER, INTEGER, INTEGER) TO MYUDF_does_not_work
GO
REPLACE FUNCTION MYUDF_does_not_work
(D int, E int, F int)
RETURNS int
contains sql
DETERMINISTIC
sql SECURITY
DEFINER collation INVOKER
INLINE TYPE 1
return D+E-F
;
There is no DDL in transaction in teradata and we do multiple DDL statements, so it is possible that a statement passes while another statement fails. This is a known issue. There seems to be a different problem here, that if you are adding to the name then the replace statement fails even though it should pass. This is a database or jdbc driver problem. If you are removing from the name then both statements work as expected. Please test to see if this occurs in versions 13.1, 13, 12 of teradata OR try the old jdbc driver on teradata 14 and see if that works. Will also look further into this over here...
There is no DDL in transaction in teradata and we do multiple DDL statements, so it is possible that a statement passes while another statement fails. This is a known issue. There seems to be a different problem here, that if you are adding to the name then the replace statement fails even though it should pass. This is a database or jdbc driver problem. If you are removing from the name then both statements work as expected. Please test to see if this occurs in versions 13.1, 13, 12 of teradata OR try the old jdbc driver on teradata 14 and see if that works. Will also look further into this over here...
We have tried with both jdbc drivers i.e jdbc-13.0 and jdbc-14.0 and we have same issue in both the drivers.
We have tried with both jdbc drivers i.e jdbc-13.0 and jdbc-14.0 and we have same issue in both the drivers.
Above issue also reproducible,when we alter stored procedures.
Above issue also reproducible,when we alter stored procedures.
Issue #9674 |
| Closed |
Completion |
| No due date |
| No fixed build |
| No time estimate |
If I rename a function in Teradata and change its name in the General Tab Name text box and under the Function text, I get no errors (See pic works)
But if i rename a function and change only its name in the Name: text box as in (does_not_work screenshot) I get an error message. So during a rename do we just need the Rename Function ... or do we also require the Replace Function as in the below SQL ?
RENAME FUNCTION MYUDF (INTEGER, INTEGER, INTEGER) TO MYUDF_does_not_work
GO
REPLACE FUNCTION MYUDF_does_not_work
(D int, E int, F int)
RETURNS int
contains sql
DETERMINISTIC
sql SECURITY
DEFINER collation INVOKER
INLINE TYPE 1
return D+E-F
;