Nested function calls with a parameters


Nested function calls with a parameters


Is there any restrictions on function calls with parameters bound? My quite complex query results in:

[SQLState HY000][Error 3610][Teradata][ODBC Teradata Driver][Teradata Database] Internal error: Please do not resubmit the last request. SubCode, CrashCode: 0, 3651

I cut down the query and run from Teradata Studio and it occurent that even simple expression (note the parameter placeholder):

select floor(floor(?));

ends with: "Parameter Metadata Incosistent. The number of parameters reported in the SQL doesn't match the number of parameters reported by database"


select floor(?);

is OK.

I have tried also but without a success:

select floor(a), floor(?) as a;

But following code is OK:

select abs(abs(?));

I'm using Teradata Express 15.00.02