Monetdb ODBC datatype conversion problem
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 😓 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)ID123..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-------- 18589934592 21.2885E+10 31.7180E+10 42.1475E+10 52.5770E+10 63.0065E+10 73.4360E+10 83.8655E+10 94.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
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
Hello Sjoerd,I created a bug report ( bug 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. 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. Thanks againBaraa 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
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
I see that you have created a changeset for this bug. That may be a stupid question but I would like to know how I can apply these changes as fast as possible. I was really waiting this fix :) Thank you, Regards,Baraa Date: Sat, 2 Nov 2013 18:19:44 +0100 From: sjoerd@monetdb.org To: users-list@monetdb.org Subject: Re: Monetdb ODBC datatype conversion problem 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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2013-11-06 12:15, baraa Mohamad wrote:
I see that you have created a changeset for this bug. That may be a stupid question but I would like to know how I can apply these changes as fast as possible. I was really waiting this fix :)
You could try to compile things yourself. If that is not possible, I could possibly provide you with a pre-compiled version, depending on what system you need it for.
Thank you,
Regards, Baraa
Date: Sat, 2 Nov 2013 18:19:44 +0100 From: sjoerd@monetdb.org To: users-list@monetdb.org Subject: Re: Monetdb ODBC datatype conversion problem
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
_______________________________________________ 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQCVAwUBUnop5z7g04AjvIQpAQLbqAP/fk+iOHkiXMOlOrUwnM52JtI+uWznxPoi bWr3Kyv3R5dyma84l3Ti6eMFn7+SHwkdXASkVPYRPzuXEmIzCRahxrwUoD53Ee6F QO2VhkVoGaWSl9oMOx1HiXGReYBNm72Ae8CnEckQ2TqiistCm/cXpKL/8N8g1Kbr uf6cCe2d/SM= =wEaU -----END PGP SIGNATURE-----
It would be very appreciated if you could provide me with a pre-compiled version. I'm using Ubuntu 10.04.4 LTS (lucid) (64 bit). Regards, Baraa
Date: Wed, 6 Nov 2013 12:37:11 +0100 From: sjoerd@acm.org To: users-list@monetdb.org Subject: Re: Monetdb ODBC datatype conversion problem
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 2013-11-06 12:15, baraa Mohamad wrote:
I see that you have created a changeset for this bug. That may be a stupid question but I would like to know how I can apply these changes as fast as possible. I was really waiting this fix :)
You could try to compile things yourself. If that is not possible, I could possibly provide you with a pre-compiled version, depending on what system you need it for.
Thank you,
Regards, Baraa
Date: Sat, 2 Nov 2013 18:19:44 +0100 From: sjoerd@monetdb.org To: users-list@monetdb.org Subject: Re: Monetdb ODBC datatype conversion problem
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
_______________________________________________ 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQCVAwUBUnop5z7g04AjvIQpAQLbqAP/fk+iOHkiXMOlOrUwnM52JtI+uWznxPoi bWr3Kyv3R5dyma84l3Ti6eMFn7+SHwkdXASkVPYRPzuXEmIzCRahxrwUoD53Ee6F QO2VhkVoGaWSl9oMOx1HiXGReYBNm72Ae8CnEckQ2TqiistCm/cXpKL/8N8g1Kbr uf6cCe2d/SM= =wEaU -----END PGP SIGNATURE----- _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
baraa Mohamad -
Sjoerd Mullender -
Sjoerd Mullender