CREATE TYPE shows 'failed' but no details are available and the UDT is created

Teradata Studio
Senior Apprentice

CREATE TYPE shows 'failed' but no details are available and the UDT is created

Hi,

I'm doing some testing with the ARRAY type and have come across the following:

If I execute a CREATE TYPE request such as the following the history window shows that the 'statement failed', but there are no details of the failure - normally we'd get the JDBC state code (I think that's what it is) and the TD error code. If I then look at the SYSUDTLIB database the TYPE has been created.

My command is:

The 'Result' column for this command shows:

Executed as Single statement.  Failed [

Elapsed time = 00:00:00.000

STATEMENT 1: CREATE  failed.

If I run the same command from SQLA I get the following messages back:

/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT    -I/usr/tdbms/etc   -L/usr/td

bms/lib -L/usr/tdbms/lib  -fpic -c TD_GetUDTContext.c

/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT    -I/usr/tdbms/etc   -L/usr/td

bms/lib -L/usr/tdbms/lib  -fpic -c U_00005B2A_EP.cpp

U_00005B2A_EP.cpp: In function 'void U_00005B2A_EP(void**, void*)':

U_00005B2A_EP.cpp:282: warning: deprecated conversion from string constant

to 'char*'

U_00005B2A_EP.cpp:282: warning: deprecated conversion from string constant

to 'char*'

/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT    -I/usr/tdbms/etc   -L/usr/td

bms/lib -L/usr/tdbms/lib  -fpic -c Teradata_new_delete.cpp

/usr/bin/gcc -D_REENTRANT -D_LIBC_REENTRANT    -I/usr/tdbms/etc   -L/usr/td

bms/lib -L/usr/tdbms/lib   -fpic -c  pre_TD_GetUDTContext.c

/usr/bin/gcc -shared -fpic -Xlinker -rpath -Xlinker /usr/tdbms/lib  -Xlinke

r -rpath -Xlinker /usr/tdbms/lib -Wl,--version-script=/var/opt/teradata/tdt

emp/UDFTemp/03F0.16383.436d28/UserUdf_versions.scr -D_REENTRANT -D_LIBC_REE

NTRANT    -I/usr/tdbms/etc   -L/usr/tdbms/lib -L/usr/tdbms/lib  -o @FileLis

t  -lpdt  -ludt  -lxml  -ludt -logrx  -ludt  -ludf  -lm -ljil -lstdc++

So I can understand that there are 'warnings' from the compiler on the dbms side, but the TYPE has ben created, I can use it in a table definition.

I guess what I'm after is for Studio to recognise (if it can) that these messages are 'warnings' and not 'failures' or 'errors'. If it must be shown as a 'failure' then at least show the error details.

Is that possible?

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
4 REPLIES
Senior Apprentice

Re: CREATE TYPE shows 'failed' but no details are available and the UDT is created

I think I tried to be too clever with my post above. What looks like a blank whit eline was meant to be 'code'. the SQL command that caused this issue is:

CREATE TYPE phonenumbers_ary AS CHAR(10) ARRAY[5];

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: CREATE TYPE shows 'failed' but no details are available and the UDT is created

Dave, I wasn't able to recreate the failure when I ran the CREATE TYPE above. It was successful in Teradata 15.10 and 14.10 systems. But we have an issue opened regarding the 'Warning' messages from the SQL execution displayed in the SQL History that will hopefully resolve your issue.

Senior Apprentice

Re: CREATE TYPE shows 'failed' but no details are available and the UDT is created

Hi Francine,

Many thanks for the info. Any idea when that resolution may be available to use?

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: CREATE TYPE shows 'failed' but no details are available and the UDT is created

Dave, The issue has not yet been scheduled.