[ 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=10024 54&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-06 09: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'::float8 and 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=10024 54&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly