close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 14 years ago

Closed 14 years ago

#1027 closed defect (fixed)

Wrong type conversion with Teradata

Reported by: Sergio Oshiro Owned by: Jorge
Priority: highest Milestone:
Component: Database Version:
Severity: blocker Keywords:
Cc:

Description

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

Change History (2)

comment:1 Changed 14 years ago by Jorge

Status: new → accepted

comment:2 Changed 14 years ago by Jorge

Resolution: → fixed
Status: accepted → closed

(In [2743]) fixes #1027, libtolodbc should check for constants returned by ODBC 3.0

Note: See TracTickets for help on using tickets.