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