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:
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/>
* *<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-----
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>
-----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/>
* *<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-----
-- *Eduardo Oliveira * *IT* ***Email:* eduardo.oliveira@adclick.pt *Web: *www.adclickint.com **<http://www.adclickint.com/> * * <http://www.adclickint.com/> <http://www.adclickint.com/>
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> <http://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
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> <http://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
-- *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 -----
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/>
_______________________________________________ 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/>
* * <http://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