Received: from kv.minsk.by (www.kv.minsk.by [194.226.122.171]) by hub.org (8.10.1/8.10.1) with ESMTP id e7MDoHT61093 for ; Tue, 22 Aug 2000 09:50:23 -0400 (EDT) Received: from vestalex (really [192.168.16.254]) by kv.minsk.by via smail with smtp id (Debian Smail3.2.0.101) for ; Tue, 22 Aug 2000 16:49:26 +0300 (MST) Message-ID: <000a01c00c3f$e784ffe0$fe10a8c0@belhard.com> From: "Alex Drobyish" To: Subject: ODBC driver fails to change float/numeric fields Date: Tue, 22 Aug 2000 16:50:12 +0300 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0007_01C00C59.0A4CC580" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200008/145 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C00C59.0A4CC580 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit Problem description: both MS Access and Borland SQL Explorer consistently return different and strange errors when attempting to edit fields with floating point type. ODBC driver version: 6.50.0000 Postgresql database version: 7.0.2 Error messages seen on the screen: "Error while executing the query; ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8' You will have to retype this query using an explicit cast" The commlog (psqlodbc.log) file is attached. The odbc trace log (sql.log) file is over 500K, tell me if it is needed. Please Cc: me as I am not subscribed to this list. Alex Drobysh ------=_NextPart_000_0007_01C00C59.0A4CC580 Content-Type: application/octet-stream; name="psqlodbc_4294427771.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="psqlodbc_4294427771.log" conn=3D49217656, SQLDriverConnect( in)=3D'DSN=3DPostgreSQL;UID=3Dprice;DATA= BASE=3Dtest;', fDriverCompletion=3D0 DSN info: DSN=3D'PostgreSQL',server=3D'192.168.16.7',port=3D'5432',dbase=3D= 'test',user=3D'price',passwd=3D'xxxxxx' onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',= showsystable=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.50.0000', fetch=3D100, socket=3D4096, unknown= _sizes=3D2, max_varchar_size=3D254, max_longvarchar_size=3D8190 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, use_decl= arefetch=3D0 text_as_longvarchar=3D0, unknowns_as_longvarchar=3D0, bools= _as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D49217656, query=3D' ' conn=3D49217656, query=3D'set DateStyle to 'ISO'' conn=3D49217656, query=3D'set geqo to 'OFF'' conn=3D49217656, query=3D'set ksqo to 'ON'' conn=3D49217656, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D49217656, SQLDriverConnect(out)=3D'DSN=3DPostgreSQL;DATABASE=3Dtest;= SERVER=3D192.168.16.7;PORT=3D5432;UID=3Dprice;PWD=3Dxxxxxx;READONLY=3D0;PRO= TOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEM= TABLES=3D0;CONNSETTINGS=3D' conn=3D49232184, SQLDriverConnect( in)=3D'DSN=3DPostgreSQL;UID=3Dprice;DATA= BASE=3Dtest;', fDriverCompletion=3D0 DSN info: DSN=3D'PostgreSQL',server=3D'192.168.16.7',port=3D'5432',dbase=3D= 'test',user=3D'price',passwd=3D'xxxxxx' onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',= showsystable=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.50.0000', fetch=3D100, socket=3D4096, unknown= _sizes=3D2, max_varchar_size=3D254, max_longvarchar_size=3D8190 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, use_decl= arefetch=3D0 text_as_longvarchar=3D0, unknowns_as_longvarchar=3D0, bools= _as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D49232184, query=3D' ' conn=3D49232184, query=3D'set DateStyle to 'ISO'' conn=3D49232184, query=3D'set geqo to 'OFF'' conn=3D49232184, query=3D'set ksqo to 'ON'' conn=3D49232184, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D49232184, SQLDriverConnect(out)=3D'DSN=3DPostgreSQL;DATABASE=3Dtest;= SERVER=3D192.168.16.7;PORT=3D5432;UID=3Dprice;PWD=3Dxxxxxx;READONLY=3D0;PRO= TOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEM= TABLES=3D0;CONNSETTINGS=3D' conn=3D49232184, query=3D'select relname, usename, relhasrules from pg_clas= s, pg_user where relkind =3D 'r' and relname !~ '^pg_|^dd_' and relname !~ = '^xinv[0-9]+' and int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 7 rows ] conn=3D49232184, SQLDisconnect conn=3D49217656, query=3D'select relname, usename, relhasrules from pg_clas= s, pg_user where relkind =3D 'r' and relname like 'abcd' and relname !~ '^p= g_|^dd_' and relname !~ '^xinv[0-9]+' and int4out(usesysid) =3D int4out(rel= owner)order by relname' [ fetched 1 rows ] conn=3D49217656, query=3D'SELECT * FROM "abcd"' [ fetched 2 rows ] conn=3D49217656, query=3D'select u.usename, c.relname, a.attname, a.atttypi= d, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules = from pg_user u, pg_class c, pg_attribute a, pg_type t where u.usesysid =3D = c.relowner and c.oid=3D a.attrelid and a.atttypid =3D t.oid and (a.attnum >= 0) and c.relname like 'abcd' order by attnum' [ fetched 3 rows ] SQLColumns: table=3D'abcd',field_name=3D'a',type=3D25,sqltype=3D21955200,na= me=3D'text' SQLColumns: table=3D'abcd',field_name=3D'b',type=3D25,sqltype=3D21955200,na= me=3D'text' SQLColumns: table=3D'abcd',field_name=3D'c',type=3D1700,sqltype=3D21955200,= name=3D'numeric' conn=3D49217656, query=3D'select c.relname, i.indkey, i.indisunique, i.indi= sclustered, c.relhasrules from pg_index i, pg_class c, pg_class d where c.o= id =3D i.indexrelid and d.relname =3D 'abcd' and d.oid =3D i.indrelid' [ fetched 0 rows ] conn=3D49232184, SQLDriverConnect( in)=3D'DSN=3DPostgreSQL;UID=3Dprice;DATA= BASE=3Dtest;', fDriverCompletion=3D0 DSN info: DSN=3D'PostgreSQL',server=3D'192.168.16.7',port=3D'5432',dbase=3D= 'test',user=3D'price',passwd=3D'xxxxxx' onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',= showsystable=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.50.0000', fetch=3D100, socket=3D4096, unknown= _sizes=3D2, max_varchar_size=3D254, max_longvarchar_size=3D8190 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, use_decl= arefetch=3D0 text_as_longvarchar=3D0, unknowns_as_longvarchar=3D0, bools= _as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D49232184, query=3D' ' conn=3D49232184, query=3D'set DateStyle to 'ISO'' conn=3D49232184, query=3D'set geqo to 'OFF'' conn=3D49232184, query=3D'set ksqo to 'ON'' conn=3D49232184, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D49232184, SQLDriverConnect(out)=3D'DSN=3DPostgreSQL;DATABASE=3Dtest;= SERVER=3D192.168.16.7;PORT=3D5432;UID=3Dprice;PWD=3Dxxxxxx;READONLY=3D0;PRO= TOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEM= TABLES=3D0;CONNSETTINGS=3D' conn=3D49232184, query=3D'SELECT "a" ,"b" ,"c" FROM "abcd"' [ fetched 2 rows ] conn=3D49232184, SQLDisconnect conn=3D49232184, SQLDriverConnect( in)=3D'DSN=3DPostgreSQL;UID=3Dprice;DATA= BASE=3Dtest;', fDriverCompletion=3D0 DSN info: DSN=3D'PostgreSQL',server=3D'192.168.16.7',port=3D'5432',dbase=3D= 'test',user=3D'price',passwd=3D'xxxxxx' onlyread=3D'0',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',= showsystable=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.50.0000', fetch=3D100, socket=3D4096, unknown= _sizes=3D2, max_varchar_size=3D254, max_longvarchar_size=3D8190 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, use_decl= arefetch=3D0 text_as_longvarchar=3D0, unknowns_as_longvarchar=3D0, bools= _as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D49232184, query=3D' ' conn=3D49232184, query=3D'set DateStyle to 'ISO'' conn=3D49232184, query=3D'set geqo to 'OFF'' conn=3D49232184, query=3D'set ksqo to 'ON'' conn=3D49232184, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D49232184, SQLDriverConnect(out)=3D'DSN=3DPostgreSQL;DATABASE=3Dtest;= SERVER=3D192.168.16.7;PORT=3D5432;UID=3Dprice;PWD=3Dxxxxxx;READONLY=3D0;PRO= TOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEM= TABLES=3D0;CONNSETTINGS=3D' conn=3D49232184, query=3D'SELECT COUNT(*) FROM "abcd" WHERE "a"=3D'abvc' A= ND "b"=3D'gfdgf' AND "c"=3D2.15' ERROR from backend during send_query: 'ERROR: Unable to identify an operat= or '=3D' for types 'numeric' and 'float8' You will have to retype this query using an explicit cast' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, errmsg=3D'Error = while executing the query' ----------------------------------------------------------= -- hdbc=3D49232184, stmt=3D49297964, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D49246820, parameters_allocated=3D3 statement_type=3D0, statement=3D'SELECT COUNT(*) FROM "ab= cd" WHERE "a"=3D? AND "b"=3D? AND "c"=3D?' stmt_with_params=3D'SELECT COUNT(*) FROM "abcd" WHERE "a"= =3D'abvc' AND "b"=3D'gfdgf' AND "c"=3D2.15' data_at_exec=3D-1, current_exec_param=3D-1, put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, cursor_type= =3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR02F03A2C' ----------------QResult Info -----------------------------= -- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: U= nable to identify an operator '=3D' for types 'numeric' and 'float8' You will have to retype this query using an explicit cast' ------------------------------------------------------------ henv=3D50270144, conn=3D49232184, status=3D1, num_stmts=3D16 sock=3D49238512, stmts=3D49246752, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D168, reverse=3D0, errornumber=3D0, errormsg=3D'(NULL)' buffer_in=3D49238552, buffer_out=3D49242652 buffer_filled_in=3D137, buffer_filled_out=3D0, buffer_read_in= =3D137 conn=3D49232184, SQLDisconnect conn=3D49217656, SQLDisconnect ------=_NextPart_000_0007_01C00C59.0A4CC580--