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