The following bug has been logged on the website:
Bug reference: 7891
Logged by: Alain Reymond
Email address: [email protected]
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
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
