Bit functions (XOR and inverse)
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
This was fixed in the Oct2012-SP2 release (bug 2291 (http://bugs.monetdb.org/2291)) which was released back in December 2012. Oct2012-SP3 has been released in January 2013.
On 2013-01-28 17:53, Eduardo Oliveira wrote:
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-- *Eduardo Oliveira * /IT/ ***Email:* eduardo.oliveira@adclick.pt mailto:eduardo.oliveira@adclick.pt *Web: *www.adclickint.com http://www.adclickint.com/ **http://www.adclickint.com/
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
Hi,
Sjoerd i just download the latest version at http://dev.monetdb.org/downloads/Fedora/17/x86_64/
MonetDB-11.13.9-20130115.fc17.x86_64.rpmhttp://dev.monetdb.org/downloads/Fedora/17/x86_64/MonetDB-11.13.9-20130115.fc17.x86_64.rpm15-Jan-2013 11:32 841K
check:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2012-SP3) Database: MonetDB v11.13.9 (Oct2012-SP3), 'mapi:monetdb://localhost.localdomain:50000/eb' Type \q to quit, ? for a list of available commands auto commit mode: on sql>SELECT 11 ^ 3; +--------------------------+ | power_single_value | +==========================+ | 1331 | +--------------------------+ 1 tuple (0.869ms)
2013/1/28 Sjoerd Mullender sjoerd@acm.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
This was fixed in the Oct2012-SP2 release (bug 2291 (http://bugs.monetdb.org/2291)) which was released back in December 2012. Oct2012-SP3 has been released in January 2013.
On 2013-01-28 17:53, Eduardo Oliveira wrote:
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-- *Eduardo Oliveira * /IT/ ***Email:* eduardo.oliveira@adclick.pt mailto:eduardo.oliveira@adclick.pt *Web: *www.adclickint.com http://www.adclickint.com/ **http://www.adclickint.com/
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net/
iQCVAwUBUQaw3z7g04AjvIQpAQKO5wQAt0A1dMPv7ummGVf7+aZ+77Diip/4XOzj qxoPimI4KOfproy3/MyUzxS9ZqWnsgwqu1GpqKOZ74Y91AlnsYiNrrgROHnilVE1 6Dj/jOHc08UJhLdMEEHCCnrQDn1WXOX27f1mR966QG/n29lj3i5cBvMB2hRxRM5I BwmkQzfc7Tg= =5WIi -----END PGP SIGNATURE-----
Ah. Then we made a mistake with marking the version in the bug report I quoted. The bug was fixed, but then it was fixed in the Feb2013 branch. The current plan is to release that sometime in February.
On 2013-01-28 19:19, Eduardo Oliveira wrote:
Hi,
Sjoerd i just download the latest version at http://dev.monetdb.org/downloads/Fedora/17/x86_64/
MonetDB-11.13.9-20130115.fc17.x86_64.rpm http://dev.monetdb.org/downloads/Fedora/17/x86_64/MonetDB-11.13.9-20130115.fc17.x86_64.rpm 15-Jan-2013 11:32 841K
check:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2012-SP3) Database: MonetDB v11.13.9 (Oct2012-SP3), 'mapi:monetdb://localhost.localdomain:50000/eb' Type \q to quit, ? for a list of available commands auto commit mode: on sql>SELECT 11 ^ 3; +--------------------------+ | power_single_value | +==========================+ | 1331 | +--------------------------+ 1 tuple (0.869ms)
2013/1/28 Sjoerd Mullender <sjoerd@acm.org mailto:sjoerd@acm.org>
This was fixed in the Oct2012-SP2 release (bug 2291 (http://bugs.monetdb.org/2291)) which was released back in December 2012. Oct2012-SP3 has been released in January 2013.
On 2013-01-28 17:53, Eduardo Oliveira wrote:
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-- *Eduardo Oliveira * /IT/ ***Email:* eduardo.oliveira@adclick.pt
mailto:eduardo.oliveira@adclick.pt
<mailto:eduardo.oliveira@adclick.pt
mailto:eduardo.oliveira@adclick.pt> *Web: *www.adclickint.com http://www.adclickint.com
_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- *Eduardo Oliveira
/IT/ ***Email:* eduardo.oliveira@adclick.pt mailto:eduardo.oliveira@adclick.pt *Web: *www.adclickint.com http://www.adclickint.com/ **http://www.adclickint.com/
Great, thank you.
2013/1/28 Sjoerd Mullender sjoerd@acm.org
Ah. Then we made a mistake with marking the version in the bug report I quoted. The bug was fixed, but then it was fixed in the Feb2013 branch. The current plan is to release that sometime in February.
On 2013-01-28 19:19, Eduardo Oliveira wrote:
Hi,
Sjoerd i just download the latest version at http://dev.monetdb.org/downloads/Fedora/17/x86_64/
MonetDB-11.13.9-20130115.fc17.x86_64.rpm <
http://dev.monetdb.org/downloads/Fedora/17/x86_64/MonetDB-11.13.9-20130115.f...
15-Jan-2013 11:32 841K
check:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2012-SP3) Database: MonetDB v11.13.9 (Oct2012-SP3), 'mapi:monetdb://localhost.localdomain:50000/eb' Type \q to quit, ? for a list of available commands auto commit mode: on sql>SELECT 11 ^ 3; +--------------------------+ | power_single_value | +==========================+ | 1331 | +--------------------------+ 1 tuple (0.869ms)
2013/1/28 Sjoerd Mullender <sjoerd@acm.org mailto:sjoerd@acm.org>
This was fixed in the Oct2012-SP2 release (bug 2291 (http://bugs.monetdb.org/2291)) which was released back in December 2012. Oct2012-SP3 has been released in January 2013.
On 2013-01-28 17:53, Eduardo Oliveira wrote:
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-- *Eduardo Oliveira * /IT/ ***Email:* eduardo.oliveira@adclick.pt
mailto:eduardo.oliveira@adclick.pt
<mailto:eduardo.oliveira@adclick.pt
mailto:eduardo.oliveira@adclick.pt> *Web: *www.adclickint.com http://www.adclickint.com
_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- *Eduardo Oliveira
/IT/ ***Email:* eduardo.oliveira@adclick.pt <mailto:
eduardo.oliveira@adclick.pt>
*Web: *www.adclickint.com http://www.adclickint.com/ **http://www.adclickint.com/
-- Sjoerd Mullender
The patch you refer to is available in the Feb2013 branch of MonetDB's HG repository [1] and will be released with the upcoming Feb2013 release (scheduled for February 2013).
Best, Stefan
[1] http://dev.monetdb.org/hg/MonetDB/
----- Original Message -----
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-- *Eduardo Oliveira
- *IT*
***Email:* eduardo.oliveira@adclick.pt *Web: *www.adclickint.com **http://www.adclickint.com/
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Oops, I was too quick and Sjoerd obviously knows better. Ignore my reply below and listen to Sjoerd's reply instead: http://mail.monetdb.org/pipermail/users-list/2013-January/005805.html
Stefan
----- Original Message -----
The patch you refer to is available in the Feb2013 branch of MonetDB's HG repository [1] and will be released with the upcoming Feb2013 release (scheduled for February 2013).
Best, Stefan
[1] http://dev.monetdb.org/hg/MonetDB/
----- Original Message -----
Hi,
I'm running MonetDB v11.13.9 (Oct2012-SP3), i have some doubts about bit functions, i was trying the bit functions looking at MySQL docs in MonetDB: http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html
And when i used ^, the pow was calculated instead of XOR, the ~ don't work as expected too.
I google and I found this http://permalink.gmane.org/gmane.comp.db.monetdb.scm/28212
This patch will be applied on MonetDb, any date of release of MonetDb with ^ already as XOR?
Right now what operator should i used to make a xor? I tested xor XOR and MonetDb didn't recognize.
If i want to insert in binary form how i do? b'binary' works?
Thanks in advance,
-- *Eduardo Oliveira
- *IT*
***Email:* eduardo.oliveira@adclick.pt *Web: *www.adclickint.com **http://www.adclickint.com/
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Eduardo Oliveira -
Sjoerd Mullender -
Stefan Manegold