Bugs item #1002454, was opened at 2007-03-06 11:33
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1002454&group_id=1000125
Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: ODBC-Driver uses false Selectstatement.
Initial Comment:
Hello
Rerering to this link:
http://pg-forum.de/showthread.php?p=6476#post6476
this is an short overview from my log:
conn=01FE0E70, query='INSERT INTO T_AKTION (ROWVERSION, NAKTIONKEY, AENDERUNGSDATUM, BEARBEITER, DTDATUMBIS,
DTDATUMVON,ERFASSER, ERFASSUNGSDATUM, NMANDANTKEY, SBEZEICHNUNG) VALUES (1,'68'::float8, '2007-03-06
09:58:08'::timestamp,E'IP', '2007-03-16 00:00:00'::timestamp, '2007-03-06 00:00:00'::timestamp, E'IP'
,'2007-03-0609:58:08'::timestamp, '1'::float8, E'06.03-16.03-104-IP' )'
conn=01FE0E70, query='SELECT IntToChar( ROWVERSION) from T_AKTION WHERE NAKTIONKEY=NULL '
[ fetched 0 rows ]
conn=01FE0E70, query='ROLLBACK'
conn=01FE0E70, query='SELECT IntToChar( ROWVERSION) from T_AKTION WHERE NAKTIONKEY='68'::float8 '
[ fetched 0 rows ]
conn=01FE0E70, query=' UPDATE T_Lookuptable SET Aenderungsdatum = '2007-03-06 09:58:08'::timestamp WHERE LutID =
'4'::float8and nMandantKey = '1'::float8'
conn=01FE0E70, query='COMMIT'
the following statements are created by win-odbc-driver psqlodbc-08_02_0200 under a OpenSuse 10.2 Postgresql 8.1.5-13
Database:
conn=01FE0E70, query='SELECT IntToChar( ROWVERSION) from T_AKTION WHERE NAKTIONKEY=NULL '
[ fetched 0 rows ]
conn=01FE0E70, query='ROLLBACK'
The statement is wrong.
It shouldnt be "...=NULL".
It has to be " IS NULL".
----------------------------------------------------------------------
>Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-17 11:54
Message:
Could you attach the Mylog output ?
regards,
Hiroshi Inoue
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1002454&group_id=1000125