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
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 |