Fw: Values in the select

Fw: Values in the select

am 11.01.2006 11:47:24 von a.j.langereis

This is a multi-part message in MIME format.

------=_NextPart_000_003F_01C616A4.C9FDD120
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=original
Content-Transfer-Encoding: 7bit

Second attempt: the size to large, therefore a piece from the top of the log
has been stripped of.

Regards,

Aarjan

----- Original Message -----
From: "A.J. Langereis"
To:
Sent: Monday, January 09, 2006 10:25 AM
Subject: Re: [ODBC] Values in the select


> Unfortunately it has not been solved yet: I missed your previous email.
>
> I have attached the complete log file, however the requested part is a bit
> messed up. Hopefully you are still able to make any sense out of it. If
> not,
> I'll make a new logfile, but that is a bit difficult at the moment due to
> a
> broken down workstation.
>
> Regards,
>
> Aarjan
>
> ----- Original Message -----
> From: "Ludek Finstrle"
> To: "A.j. Langereis"
> Cc:
> Sent: Sunday, January 08, 2006 12:12 PM
> Subject: Re: [ODBC] Values in the select
>
>
>>> > Attached is a file with both mylogs enabled.Note: I have put the log
>>> > through
>>> > a parser because the lines were only delimeted with a #10 instead of
>>> > both
>>> > #10 and #13
>>>
>>> The log is truncated in the middle of SQLExecDirect operation. I can't
>>> tell you anything now. I need whole log.
>>> I don't see neither what driver read from backend nor how you get tha
>>> data.
>>
>> What's the state? Could I release it from my mind?
>>
>> Thanks,
>>
>> Luf
>>
>>
>

------=_NextPart_000_003F_01C616A4.C9FDD120
Content-Type: application/octet-stream;
name="mylog_2697_without_top.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="mylog_2697_without_top.log"

[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D42, stmt=3D'select oid from pg_type where typname=3D'lo''=0A=
[3312] stmt_with_params =3D 'select oid from pg_type where typname=3D'lo''=
=0A=
[3312] Sending SELECT statement on stmt=3D120063008, cursor_name=3D'S=
QL_CUR07280420'=0A=
[3312]send_query(): conn=3D120025968, query=3D'select oid from pg_type wher=
e typname=3D'lo''=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 2=0A=
[3312]LIBPQ_execute_query: query =3D select oid from pg_type where typname=
=3D'lo'=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]LIBPQ_execute_query: rest types ...=0A=
[3312]CC_mapping: entering ...=0A=
[3312]CC_mapping: rows =3D 0, columns =3D 1=0A=
[3312]CC_mapping: column =3D 0=0A=
[3312]CC_mapping: set field info: name =3D oid, typ =3D 26, typlen =3D 4, a=
ttypmod =3D -1=0A=
[3312]in TL_Constructor=0A=
[3312]exit TL_Constructor=0A=
[3312]send_query: done sending query with status: 2=0A=
[3312]QR_fetch_tuples: cursor =3D '', self->cursor=3D0=0A=
[3312]QR_fetch_tuples: past CI_read_fields: num_fields =3D 1=0A=
[3312]MALLOC: tuple_size =3D 100, size =3D 800=0A=
[3312] done sending the query:=0A=
[3312]extend_column_bindings: entering ... self=3D120063144, bindings_alloc=
ated=3D0, num_columns=3D1=0A=
[3312]exit extend_column_bindings=0A=
[3312]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[3312]PGAPI_Fetch: stmt =3D 120063008, stmt->result=3D 120062160=0A=
[3312]manual_result =3D 1, use_declarefetch =3D 0=0A=
[3312]PGAPI_FreeStmt: entering...hstmt=3D120063008, fOption=3D1=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]TupleList: in DESTRUCTOR=0A=
[3312]TupleList: exit DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D101=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]SC_Destructor: self=3D120063008, self->result=3D0, self->hdbc=3D12002=
5968=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]ARDFields_free 72804a8 bookmark=3D72806a0[3312]ARD_unbind_cols freeal=
l=3D1 allocated=3D1 bindings=3D7280020=0A=
[3312]reset_a_column_binding: entering ... self=3D120063144, bindings_alloc=
ated=3D1, icol=3D1=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]GDATA_unbind_cols freeall=3D1 allocated=3D0 gdata=3D0=0A=
[3312]SC_Destructor: EXIT=0A=
[3312]CC_lookup_characterset: entering...=0A=
[3312]send_query(): conn=3D120025968, query=3D'select pg_client_encoding()'=
=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 2=0A=
[3312]LIBPQ_execute_query: query =3D select pg_client_encoding()=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 1=0A=
[3312]LIBPQ_execute_query: rest types ...=0A=
[3312]CC_mapping: entering ...=0A=
[3312]CC_mapping: rows =3D 1, columns =3D 1=0A=
[3312]CC_mapping: column =3D 0=0A=
[3312]CC_mapping: set field info: name =3D pg_client_encoding, typ =3D 19, =
typlen =3D 64, attypmod =3D -1=0A=
[3312]in TL_Constructor=0A=
[3312]exit TL_Constructor=0A=
[3312]CC_mapping: fetch column =3D pg_client_encoding, value =3D UTF8=0A=
[3312]send_query: done sending query with status: 2=0A=
[3312]QR_fetch_tuples: cursor =3D '', self->cursor=3D0=0A=
[3312]QR_fetch_tuples: past CI_read_fields: num_fields =3D 1=0A=
[3312]MALLOC: tuple_size =3D 100, size =3D 800=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]TupleList: in DESTRUCTOR=0A=
[3312]TupleList: exit DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D101=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]send_query(): conn=3D120025968, query=3D'set client_encoding to 'lati=
n9''=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 1=0A=
[3312]LIBPQ_execute_query: query =3D set client_encoding to 'latin9'=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]The query was executed successfully and the query did not return any =
result =
[3312]send_query: done sending command=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D0=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]CC_connect: returning...=0A=
[3312]szConnStrOut =3D 'DSN=3DPostgreSQL;DATABASE=3Dintwis9;SERVER=3Dlocalh=
ost;PORT=3D5432;SSLMODE=3Dprefer;UID=3Dintwis2;PWD=3Dxxxxxxx ;ReadOnly=3D0;P=
rotocol=3D6.4;FakeOidIndex=3D0;ShowOidColumn=3D0;RowVersioni ng=3D0;ShowSyst=
emTables=3D0;ConnSettings=3D;Fetch=3D100;Socket=3D8192;Unkno wnSizes=3D0;Max=
VarcharSize=3D254;MaxLongVarcharSize=3D8190;Debug=3D1;CommLo g=3D1;Optimizer=
=3D1;Ksqo=3D1;UseDeclareFetch=3D0;TextAsLongVarchar=3D1;Unkn ownsAsLongVarch=
ar=3D0;BoolsAsChar=3D1;Parse=3D0;CancelAsFreeStmt=3D0;ExtraS ysTablePrefixes=
=3Ddd_;;LFConversion=3D1;UpdatableCursors=3D0;DisallowPremat ure=3D0;TrueIsM=
inus1=3D0;BI=3D0;ByteaAsLongVarBinary=3D0;UseServerSidePrepa re=3D0;LowerCas=
eIdentifier=3D0' len=3D590,1024=0A=
[3312]PGAPI_DriverConnect: returning 0=0A=
[3312][[SQLGetDiagRec]]=0A=
[3312]PGAPI_GetDiagRec entering rec=3D1[3312]**** PGAPI_ConnectError: hdbc=
=3D120025968 <0>=0A=
[3312]enter CC_get_error=0A=
[3312]enter CC_create_errormsg=0A=
[3312]msg =3D ''=0A=
[3312]exit CC_create_errormsg=0A=
[3312]exit CC_get_error=0A=
[3312]CC_Get_error returned nothing.=0A=
[3312]PGAPI_GetDiagRec exiting 100=0A=
[3312][SQLGetFunctions][3312][SQLGetInfo(30)][3312]PGAPI_Get Info: entering.=
...fInfoType=3D23=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D2=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D24=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D2=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D79=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D3, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D83=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D0, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D78=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D81=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D15, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D72=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D10, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D82=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D90, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D44=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D17, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D43=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D144=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D0, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D150=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D4687, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D167=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D4687, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D146=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D151=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D168=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D111=0A=
[3312]PGAPI_GetInfo: p=3D'N', len=3D1, value=3D0, cbMax=3D512=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D16=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D0, value=3D0, cbMax=3D0=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D23=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D24=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D46=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D4=0A=
[3312][[SQLSetConnectAttr]] 1=0A=
[3312]PGAPI_SetConnectAttr 1=0A=
[3312]PGAPI_SetConnectOption: entering fOption =3D 1 vParam =3D 0=0A=
[3312]SetStmtOption(): SQL_MAX_ROWS, vParam =3D 0=0A=
[3312][[SQLSetConnectAttr]] 0=0A=
[3312]PGAPI_SetConnectAttr 0=0A=
[3312]PGAPI_SetConnectOption: entering fOption =3D 0 vParam =3D 0=0A=
[3312]SetStmtOption: SQL_QUERY_TIMEOUT, vParam =3D 0=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D52=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D52=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D52=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D48=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D1=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D0, cbMax=3D4=0A=
[3312][[SQLGetConnectAttr]] 109=0A=
[3312]PGAPI_GetConnectAttr 109=0A=
[3312]PGAPI_GetConnectOption: entering...=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D26=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D2, cbMax=3D4=0A=
[3312][[SQLAllocHandle]][3312]PGAPI_AllocStmt: entering...=0A=
[3312]SC_Constructor: entering ...=0A=
[3312]SC_Constructor: created stmt =3D 120063008=0A=
[3312]**** PGAPI_AllocStmt: hdbc =3D 120025968, stmt =3D 120063008=0A=
[3312]CC_add_statement: self=3D120025968, stmt=3D120063008=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10010=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10010=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10011=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10011=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10012=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10012=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10013=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10013=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 18,10=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 18,10=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 18,0=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 18,0=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 17,1243176=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 17,1243176=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 17,0=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 17,0=0A=
[3312][[SQLSetDescField]] h=3D120063228 rec=3D1 field=3D1004 val=3D12f828=
=0A=
[3312]PGAPI_SetDescField h=3D120063228 rec=3D1 field=3D1004 val=3D12f828,0=
=0A=
[3312]DESCRIPTOR ERROR: func=3DPGAPI_SetDescField, desc=3D'', errnum=3D11, =
errmsg=3D'bad parameter number'=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 0,30=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 0,30=0A=
[3312]PGAPI_SetStmtOption: entering...=0A=
[3312]SetStmtOption: SQL_QUERY_TIMEOUT, vParam =3D 30=0A=
[3312][SQLFreeStmt][3312]PGAPI_FreeStmt: entering...hstmt=3D120063008, fOpt=
ion=3D3=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312][SQLPrepare][3312]PGAPI_Prepare: entering...=0A=
[3312]**** PGAPI_Prepare: STMT_ALLOCATED, copy=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D36=0A=
[3312]PGAPI_GetInfo: p=3D'Y', len=3D1, value=3D0, cbMax=3D4=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 1227,1=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 1227,1=0A=
[3312]PGAPI_SetStmtOption: entering...=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 1228,1=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 1228,1=0A=
[3312]PGAPI_SetStmtOption: entering...=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 6=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 6=0A=
[3312]PGAPI_GetStmtOption: entering...=0A=
[3312]GetStmtOption(): SQL_CURSOR_TYPE 0=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 7=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 7=0A=
[3312]PGAPI_GetStmtOption: entering...=0A=
[3312]GetStmtOption(): SQL_CONCURRENCY 1=0A=
[3312][[SQLGetConnectAttr]] 108=0A=
[3312]PGAPI_GetConnectAttr 108=0A=
[3312]PGAPI_GetConnectOption: entering...=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 22,1=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 22,1=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 21,0=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 21,0=0A=
[3312][SQLExecDirect][3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'select 'asdfg'=
as asdfg t=3D1=12t   =01? emD • ttD =90? 'asdfg' as asdfg0 =
? / [3312]PDATA_free_params: ENTER, self=3D120063l =13 =
=01 0 =95 àŸ=95 ttD $? 3008 tD ttD àŸ=95 =10? àŸ=95 ttD =04=
? ecDirect][3312]PGAPI_ExecDirect: entering... tD ttD àŸ=95 =C8> =E0=
Ÿ• ttD =BC> =01 0 teàŸ=95 ttD =A4> 'asdfg' as asdf0 ? =
- [3312]PGAPI_SetStmtAttr Handle=3D120063008 22,l =13 =01 1=
=95 àŸ=95 ttD 8> dle=3D120063008 22,1 ttD àŸ=95 =18> , =95 =E0=
Ÿ• ttD =08> àŸ=95 ttD ü= / =1F [3312][[SQLGetConn=
ectAttr]] L =13 =01 8 =95 àŸ=95 ttD °= ): SQL_CONCURRENC=
Y 1 tD ttD àŸ=95 Œ= àŸ=95 ttD €= ntering... ttD àŸ=
=95 h=3D . =95 àŸ=95 ttD X=3D Handle=3D120063008 7 ttD àŸ=95 8=
=3D =95 àŸ=95 ttD (=3D =13 =01 0 elàŸ=95 ttD = as=
asdfg( =13 =01 . =3D'àŸ=95 ttD ä< g' as as( =13 =
=01 6 meàŸ=95 ttD =BC< asdfg' as as, ; + [3312][[SQLGetStm=
tAttr]] Handle=3D12006300d =13 =01 6 =95 àŸ=95 ttD X< ing...=
ttD àŸ=95 D< . =95 àŸ=95 ttD 4< asdfg' as as0 =13 =01 =
1 'sàŸ=95 ttD =08< ' as asd( =13 =01 . atàŸ=95 ttD =E0;=
t 'asdfg' as asd0 ? / [3312]PGAPI_SetStmtAttr Handle=3D12006300=
8 122l =13 =01 1 =95 àŸ=95 ttD t; dle=3D120063008 1227,1 tD =
ttD àŸ=95 P; àŸ=95 ttD D; ement=3D'select 'asdfg' as asdD =13 =
=01 6 teàŸ=95 ttD =08; 'asdfg' as asdf0 =13 =01 y st=
àŸ=95 ttD =D8: ect 'asdfg' as asdfg4 =13 =01 . emàŸ=95 t=
tD =A4: 'asdfg' as asdfg0 ? / [3312]PDATA_free_params: ENTER, s=
elf=3D120063l =13 =01 0 =95 àŸ=95 ttD 8: 0 ? - [33=
12]APD_free_params: ENTER, self=3D12006326l =13 =01 0 =95 àŸ=
=95 ttD Ü9 [3312][SQLFreeStmt][3312]PGAPI_FreeStmt: entering...hstmt=3D1=
20063008, fOption=3D3 ttD àŸ=95 =809 =3D =95 àŸ=95 ttD p9 'asdfg=
' as asdfg0 ? - [3312]PGAPI_SetStmtAttr Handle=3D120063008 0,3l =
=13 =01 0 =95 àŸ=95 ttD =049 120063008 0,30 ttD àŸ=95 =
=E88 3 =95 àŸ=95 ttD =D88 ' as asdd s b [3312]DESCRIPTOR ER=
ROR: func=3DPGAPI_SetDescField, desc=3D'', errnum=3D11, errmsg=3D'bad param=
eter number' ttD àŸ=95 P8 r =95 àŸ=95 ttD @8 f828,0 ttD àŸ=
=95 ,8 , =95 àŸ=95 ttD =1C8 0 ? - [3312]PGAPI_SetStmtAttr H=
andle=3D120063008 17,l =13 =01 0 =95 àŸ=95 ttD =C07 dle=3D12=
0063008 17,0 ttD àŸ=95 =A07 , =95 àŸ=95 ttD =907 dfg' as asdf4 =
=13 =01 6 meàŸ=95 ttD d7 asdfg' as as, ? - [3312]PG=
API_SetStmtAttr Handle=3D120063008 18,h =13 =01 0 =95 àŸ=95 t=
tD ü6 dle=3D120063008 18,0 ttD àŸ=95 Ü6 , =95 àŸ=95 ttD =CC6=
le=3D120063008 18,10 ttD àŸ=95 6 1 =95 àŸ=95 ttD =9C6 sdfg0=
=13 =01 3 emàŸ=95 ttD x6 'asdfg' as asdfg0 ? / [3=
312][[SQLGetStmtAttr]] Handle=3D120063008 10l =13 =01 3 =95 =E0=
Ÿ• ttD =0C6 20063008 10012 ttD àŸ=95 =F05 1 =95 àŸ=95 ttD =
=E05 asd0 =13 =01 1 atàŸ=95 ttD =BC5 t 'asdfg' as asd0 ?=
/ [3312][[SQLGetStmtAttr]] Handle=3D120063008 10l =13 =01 =
1 =95 àŸ=95 ttD P5 le=3D120063008 10010 ttD àŸ=95 05 1 =95 =E0=
Ÿ• ttD 5 fg' as asdfg8 =13 =01 8 12àŸ=95 ttD =F44 teme=
nt=3D'select 'asdfg' as as< =13 =01 8 atàŸ=95 ttD =B84 t 'as=
dfg' as asd0 =13 =01 8 ctàŸ=95 ttD =884 asdf$ =13 =
=01 . 06àŸ=95 ttD d4 ent=3D'select 'asdfg' as asdfg< =13 =01=
. 00àŸ=95 ttD (4 =3D'select 'asdfg' as asdf8 =13 =01 4 st=
àŸ=95 ttD =F03 , statement=3D'select 'asdfg' as asdfgD =13 =01=
6 'sàŸ=95 ttD 3 ' as asd( ; ) [3312]PGAPI_GetConnectOp=
tion: entering..` =13 =01 . =95 àŸ=95 ttD L3 H3 0 =95 =E0=
Ÿ• ttD 83 sdfg' as asd8 =13 =01 4 stàŸ=95 ttD =0C3 , st=
atement=3D'select 'asdfg' as asdfgD S A [3312][SQLGetInfo(30)][33=
12]PGAPI_GetInfo: entering...fInfoType=” =13 =01 1 =95 àŸ=
=95 ttD x2 ect 'asdfg' as asdfgD S A [3312][SQLGetInfo(30)][3312=
]PGAPI_GetInfo: entering...fInfoType=” =13 =01 6 =95 àŸ=
=95 ttD =F41 ect 'asdfg' as asdfgD S A [3312][SQLGetInfo(30)][33=
12]PGAPI_GetInfo: entering...fInfoType=” =13 =01 6 =95 àŸ=
=95 ttD p1 ect 'asdfg' as asdfgD S A [3312][SQLGetInfo(30)][3312=
]PGAPI_GetInfo: entering...fInfoType=” =13 =01 6 =95 àŸ=
=95 ttD =EC0 ect 'asdfg' as asdfgD S A [3312][SQLGetInfo(30)][33=
12]PGAPI_GetInfo: entering...fInfoType=” =13 =01 6 =95 àŸ=
=95 ttD h0 0 ttD àŸ=95 X0 =95 àŸ=95 ttD H0 =13 =01 0=
sdàŸ=95 ttD ,0 / =1D [3312][[SQLSetConnectAttr]] L =13 =
=01 0 =95 àŸ=95 ttD =E0/ Ü/ ement=3D'select 'asdfg' as asd<=
O =3D [3312]PGAPI_SetConnectOption: entering fOption =3D 1 vPara=
m =3D =88 =13 =01 0 =95 àŸ=95 ttD T/ ' as asd8 =13 =
=01 4 hsàŸ=95 ttD ,/ 8, statement=3D'select 'asdfg' as asdfD =13 =
=01 6 30àŸ=95 ttD =E8. t=3D'select 'asdfg' as asd8 =13 =
=01 4 hsàŸ=95 ttD °. 8, statement=3D'select 'asdfg' as asdfD =13=
=01 4 30àŸ=95 ttD l. t=3D'select 'asdfg' as asd8 =13 =
=01 4 hsàŸ=95 ttD 4. 8, statement=3D'select 'asdfg' as asdfD =13 =
=01 3 stàŸ=95 ttD =F0- ect 'asdfg' as asdfg4 =13 =01 =
0 tmàŸ=95 ttD =BC- statement=3D'select 'asdfg' as as@ =13 =01=
6 00àŸ=95 ttD |- =3D'select 'asdfg' as asdf8 G 5 [3312]PG=
API_GetInfo: p=3D'N', len=3D1, value=3D0, cbMax=3D51| =13 =01 2 =
=95 àŸ=95 ttD - ent=3D'select 'asdfg' as asdfg< =13 =01 4 s=
tàŸ=95 ttD Ä, , statement=3D'select 'asdfg' as asdfgD S C =
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=” =13=
=01 8 =95 àŸ=95 ttD 0, , value=3D1, cbMax=3D4 ttD àŸ=95 =
=10, =3D =95 àŸ=95 ttD , t=3D'select 'asdfg' as asd< =13 =01=
4 hàŸ=95 ttD =C8+ 08, statement=3D'select 'asdfg' as asdD S =
C [3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=”=
=13 =01 6 =95 àŸ=95 ttD 4+ ect 'asdfg' as asdfgD S =
C [3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=” =
=13 =01 7 =95 àŸ=95 ttD °* t 'asdfg' as asdD S C =
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=” =13=
=01 0 =95 àŸ=95 ttD 0* en=3D4, value=3D0, cbMax=3D4 ttD =E0=
Ÿ• =0C* =3D =95 àŸ=95 ttD ü) elect 'asdfg' as asd8 =13 =
=01 4 hsàŸ=95 ttD =C8) 8, statement=3D'select 'asdfg' as asdfD =13=
=01 3 63àŸ=95 ttD =84) nt=3D'select 'asdfg' as as8 K =
9 [3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D17, cbMax=€ =
=13 =01 4 =95 àŸ=95 ttD =04) )][3312]PGAPI_GetInfo: entering..=
..fInfoType=3D44 ttD àŸ=95 =C8( 4 =95 àŸ=95 ttD =B8( asdfg' as as=
@ =13 =01 2 00àŸ=95 ttD =8C( ment=3D'select 'asdfg' as asdf<=
K 9 [3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D10, cbMa=
x=„ =13 =01 4 =95 àŸ=95 ttD =08( )][3312]PGAPI_GetInfo: =
entering...fInfoType=3D72 ttD àŸ=95 =CC' 7 =95 àŸ=95 ttD =BC' df=
g' as asdfD =13 =01 1 30àŸ=95 ttD =90' t=3D'select 'asdfg' a=
s asd8 =13 =01 4 hsàŸ=95 ttD X' 8, statement=3D'select 'asdf=
g' as asdfD =13 =01 8 30àŸ=95 ttD =14' t=3D'select 'asdfg' a=
s asd8 =13 =01 4 hsàŸ=95 ttD Ü& 8, statement=3D'select 'as=
dfg' as asdfD =13 =01 3 30àŸ=95 ttD =98& t=3D'select 'asdfg'=
as asd8 =13 =01 4 hsàŸ=95 ttD `& 8, statement=3D'select 'as=
dfg' as asdfD =13 =01 9 30àŸ=95 ttD =1C& t=3D'select 'asdfg'=
as asd8 =13 =01 2 hsàŸ=95 ttD ä% 8, statement=3D'select '=
asdfg' as asdfD =13 =01 4 30àŸ=95 ttD =A0% t=3D'select 'asdf=
g' as asd8 =13 =01 2 **àŸ=95 ttD h% cDirect: hstmt=3D1200630=
08, statement=3D'select 'asdfg' as asdfg\ k Y [3312][SQLGetFuncti=
ons][3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D2Ä =
=13 =01 3 =95 àŸ=95 ttD =A4$ =A0$ àŸ=95 ttD =94$ C_cre=
ate_errormsH =13 =01 g =95 àŸ=95 ttD d$ CC_create_errormsg =
ttD àŸ=95 D$ s =95 àŸ=95 ttD 4$ 0$ àŸ=95 ttD $$ ect 'asdfg'=
as asdfgX g V [3312]PGAPI_GetDiagRec entering rec=3D1[3312]**** =
PGAPI_ConnectError: hdbc=3D120025968 <0> ttD àŸ=95 =9C# 0 =95 àŸ=
=95 ttD =8C# [3312]GetStmtOption(): SQL_CONCURRENCY 1=0A=

------=_NextPart_000_003F_01C616A4.C9FDD120
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

------=_NextPart_000_003F_01C616A4.C9FDD120--

Re: Fw: Values in the select

am 11.01.2006 22:44:41 von Ludek Finstrle

> Second attempt: the size to large, therefore a piece from the top of the

32kb is too large? I'm sorry but the mylog output is wrong.
The last line contains weird characters.

Feel free to send me the unchanged mylog output. I can't read anything
from the log. It ends in start of SQLExecDirect :-(

> >I'll make a new logfile, but that is a bit difficult at the moment due to
> >a
> >broken down workstation.

Maybe this is the right reason of bad mylog output. I'm waiting for
new one. Please don't forget to let us know when the workstation
will be ok.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match