Skip site navigation (1) Skip section navigation (2)

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1002454 ] ODBC-Driver uses false Selectstatement.
Date: 2007-03-06 11:33:06
Message-ID: 20070306113306.5BCB32172A7@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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-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=1002454&group_id=1000125

pgsql-odbc by date

Next:From: noreplyDate: 2007-03-06 14:56:41
Subject: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Previous:From: greg.campbellDate: 2007-03-05 22:36:37
Subject: Re: MSysConf on PG 8.2 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group