Re: #<DOUBLE-FLOAT quiet NaN> problem

On Fri, 16 Oct 2009, Carlos Konstanski wrote:

> Date: Fri, 16 Oct 2009 14:22:19 -0600 (MDT)
> From: Carlos Konstanski <[email protected]>
> To: [email protected]
> Subject: Re: [CLSQL] #<DOUBLE-FLOAT quiet NaN> problem
> 
> On Fri, 16 Oct 2009, Carlos Konstanski wrote:
>
>>  Date: Fri, 16 Oct 2009 14:12:53 -0600 (MDT)
>>  From: Carlos Konstanski <[email protected]>
>>  To: [email protected]
>>  Subject: [CLSQL] #<DOUBLE-FLOAT quiet NaN> problem
>>
>>  I am getting an object of type #<DOUBLE-FLOAT quiet NaN> instead of
>>  the value 0.9d0 that I should be getting from a query using the
>>  backends db-odbc and Oracle 10g. This has started happening after
>>  upgrading to clsql-4.1.1. I'm using the super basic (clsql:query) to
>>  issue the SELECT.
>>
>>  What can I do to help get this fixed? It's causing a big problem over
>>  here.
>>
>>  Thanks,
>>  Carlos Konstanski
>
> I am beginning to suspect unixODBC. It also was updated
> recently. Rolling back unixODBC now.
>
> Carlos

I am unable to roll back to the old unixODBC in gentoo because it
won't build on an up-to-date system. But I am quite convinced that
unixODBC is the problem, or at least its interaction with the Oracle
ODBC driver. I am working around the problem with no difficulty by
employing the :oracle backend. Good to go.

Carlos