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, -- *Eduardo Oliveira * *IT* ***Email:* eduardo.oliveira@adclick.pt *Web: *www.adclickint.com **<http://www.adclickint.com/> * * <http://www.adclickint.com/> <http://www.adclickint.com/>
-----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:
- -- 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-----
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>
-- *Eduardo Oliveira * *IT* ***Email:* eduardo.oliveira@adclick.pt *Web: *www.adclickint.com **<http://www.adclickint.com/> * * <http://www.adclickint.com/> <http://www.adclickint.com/>
Great, thank you. 2013/1/28 Sjoerd Mullender <sjoerd@acm.org>
-- *Eduardo Oliveira * *IT* ***Email:* eduardo.oliveira@adclick.pt *Web: *www.adclickint.com **<http://www.adclickint.com/> * * <http://www.adclickint.com/> <http://www.adclickint.com/>
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 -----
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 -----
participants (3)
-
Eduardo Oliveira -
Sjoerd Mullender -
Stefan Manegold