id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1027	Wrong type conversion with Teradata	Sergio Oshiro	Jorge	"Hi,

We are using Teradata as database and TOL/tolbase with ODBC on Linux 64.
The following code should return a variable of type Date:
{{{
Date today = (Set DBTable(""select current_date as today""))[1][1];
}}}
But it results on the following errors:
{{{
Warning: [201] (Funcion DBTable) La consulta debería devolver un texto, una fecha o un número en el campo 1
ERROR: [93] Tipos incompatibles en Element (ó [ ] ): today es de tipo Text, pero no de tipo Date.
ERROR: [94] today no se pudo crear.
}}}
The same code on TOL/tolbase on Windows connected on the same Teradata database doesn't causes any errors.

Best regards,
Sergio
"	defect	closed	highest		Database		blocker	fixed