BUG #7891: ODBC error on SQL_REAL

From: alain(dot)reymond(at)ceia(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7891: ODBC error on SQL_REAL
Date: 2013-02-19 17:35:24
Message-ID: E1U7r6C-0002Zn-R0@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7891
Logged by: Alain Reymond
Email address: alain(dot)reymond(at)ceia(dot)com
PostgreSQL version: 9.2.3
Operating system: Centos 5.9 (32 bits)
Description:

Hello,

I use Postgresql 9.2.3 under Centos 5.9. (32 bits).
We access our database through unixodbc (unixODBC-2.2.11-10.el5.i386).

I have defined a table
CREATE TABLE rresultats
(
numbil integer,
numparam smallint,
mesure smallint,
dev real
)

I access the table via esql for cobol.

When I try to insert a record in the table, I get a sqlcode = -7 in return.
It seems that SQL_REAL is not properly mapped to the comp-1 in cobol ( =
float in C).

Here is the logfile :
[ODBC][19186][SQLBindParameter.c][193]
Entry:
Statement = 0x83227c8
Param Number = 4
Param Type = 1
C Type = 7 SQL_C_FLOAT
SQL Type = 7 SQL_REAL
Col Def = 7
Scale = 0
Rgb Value = 0x83225a8
Value Max = 4
StrLen Or Ind = 0x83225a4
[ODBC][19186][SQLBindParameter.c][339]
Exit:[SQL_SUCCESS]
[ODBC][19186][SQLExecute.c][183]
Entry:
Statement = 0x83227c8
[ODBC][19186][SQLExecute.c][344]
Exit:[SQL_ERROR]
DIAG [S1000] ERREUR: syntaxe en entrée invalide pour le type
real : « 15,5 » au caractère 141;
Error while executing the query

[ODBC][19186][SQLError.c][342]
Entry:
Statement = 0x83227c8
SQLState = 0x82e434a
Native = 0xbfa1e540
Message Text = 0x82e4350
Buffer Length = 1023
Text Len Ptr = 0xbfa1e546
[ODBC][19186][SQLError.c][379]
Exit:[SQL_SUCCESS]
SQLState = S1000
Native = 0xbfa1e540 -> 7
Message Text = [[unixODBC]ERREUR: syntaxe en entrée
invalide pour le type real : « 15,5 » au caractère 141;
Error while executing the query]

I tried with double precision : same thing.

Curiously, we have a version using unixODBC-2.2.11-7.1 and Posgresql 8.4 and
have no problem...

Regards

Browse pgsql-bugs by date

  From Date Subject
Next Message mbaranczak 2013-02-19 23:10:24 BUG #7897: RPM fails to set up links for all the tools
Previous Message Lou Picciano 2013-02-19 17:16:27 Re: Nested xmlagg doesn't give a result 9.2.3