[ psqlodbc-Bugs-1002454 ] ODBC-Driver uses false Selectstatement.

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


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1002454&group_id=1000125