Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

SQL: ODBC driver crashes with SELECT statement involving a TIMESTAMP parameter.

The following statement causes the client tocrash and generate a core dump when executed by an ODBC C client:
SELECT FTS FROM TESTTBL WHERE (? <= '1999-01-01 10:01:01.111')
Where the table TESTTBL and the field FTS are created by the following statement:
CREATE TABLE TESTTBL (FTS TIMESTAMP)

Using the following ODBC escape syntax in the SELECT statement eliminates this problem:
SELECT FTS FROM TESTTBL WHERE (? <= {ts '1999-01-01 10:01:01.111'})

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1A01 Service Pack

CAUSE:

Bug# OE00133750

FIX:

Upgrade to OpenEdge 10.1B01 or later. If upgrading to OpenEdge 10.1B01 or later is not feasible, then use the ODBC escape syntax. For example:
SELECT FTS FROM TESTTBL WHERE (? <= {ts '1999-01-01 10:01:01.111'})