Bugs item #1959450, was opened at 2008-05-07 14:13
Message generated for change (Settings changed) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959450&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
>Resolution: Invalid
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Romulo Goncalves (romulog)
Summary: hexadecimal too big
Initial Comment:
The following sql code gives an error which was not expected to happen.
create table t1 (id int);
select id from t1 where bit_and(id,0xFFFFFFFFFFFFFFF0000) > 0;
drop table t1;
MAPI = [EMAIL PROTECTED]:50000
QUERY = select id from t1 where bit_and(id,0xFFFFFFFFFFFFFFF0000) > 0;
ERROR = !invalid hexadecimal number or hexadecimal too large
(0xFFFFFFFFFFFFFFF0000) in: "select id from t1 where
bit_and(id,0xFFFFFFFFFFFFFFF0000"
!syntax error, unexpected ')' in: ")"
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-05-08 11:21
Message:
Logged In: YES
user_id=1498628
Originator: YES
This time MonetDB is right.
16^19 = 75557863725914323419136
2^64 = 18446744073709551616
So such hexadecimal does not fit into a 64 bit int.
I declare this bug closed...
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959450&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
