On 2013-11-02 16:35, baraa Mohamad wrote:
> Hello Sjoerd,
> 
> I created a bug report ( bug 3392
> <http://bugs.monetdb.org/show_bug.cgi?id=3392>).
> I hope you can help me solve this problem. Do I can post a part of the
> log file here or I should better wait the answer for the bug report.

No, leave it in the bug report.  That is equally public, and you have
provided a pointer for those who are interested.

> P.S: setting the ODBCDEBUG variable has not worked for me to create the
> ODBC log file so I created it using unixODBC allow trace option, I hope
> this can give the needed info.

As long as it fails in the same way, I guess it's going to be good enough.

> Thanks again
> Baraa
> 
> Date: Sat, 2 Nov 2013 09:15:11 +0100
> From: sjoerd@monetdb.org
> To: users-list@monetdb.org
> Subject: Re: Monetdb ODBC datatype conversion problem
> 
> Yuu can try to create and look at debug output from the ODBC driver.
> See bug 2910, comment 1 for instructions on how to do that
> (http://bugs.monetdb.org/show_bug.cgi?id=2910#comment_text_1).
> If you can't figure out what it means, you can create a bug report and
> attach the log.
>  
> On 2013-11-02 00:29, baraa Mohamad wrote:
>> Dear MonetDB users,
>> 
>> I have created a database link from oracle to monetdb using Monetdb ODBC
>> driver, the link works fine but i have a strange results Emoji
>> 
>> I have the following configurations: 
>> host1: Oracle (ubuntu 64bit)
>> host2: MonetDB (ubntu 64bit)
>> ODBC driver: MonetDB odbc (64bit) using unixODBC driver manager 
>> 
>> on monetdb i have the following table:   emp (id *integer *, name varchar);
>> 
>> test query:  select id from emp where id<20; 
>> 
>> when I execute this query directly on montdb I get the following results
>> (IDs from 1 to 19)
>> ID
>> 1
>> 2
>> 3
>> .
>> .
>> 19
>> 
>> BUT when I execute this query from oracle using dblink 
>> 
>> select "id" from "emp"@monetdb where "id"<20 ;
>> 
>> 
>> I GET THE FOLLOWING RESULTS: 
>> 
>> ID
>> --------
>> *1*
>> *8589934592*
>> *2*
>> *1.2885E+10*
>> *3*
>> *1.7180E+10*
>> *4*
>> *2.1475E+10*
>> *5*
>> *2.5770E+10*
>> *6*
>> *3.0065E+10*
>> *7*
>> *3.4360E+10*
>> *8*
>> *3.8655E+10*
>> *9*
>> *4.2950E+10*
>> *10*
>> 
>> I cannot figure out the cause of the problem and how I can solve it (it
>> seems a problem related to datatype conversion using ODBC) 
>> *Could you please tell me what I should do....*
>> 
>> Best regards,
>> Baraa
>> 
>> 
>> _______________________________________________
>> users-list mailing list
>> users-list@monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
>> 
>  
> -- 
> Sjoerd Mullender
>  
> 
> 
> _______________________________________________ users-list mailing list
> users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
> 
> 
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
> 

-- 
Sjoerd Mullender