Bugs item #2080189, was opened at 2008-08-28 16:06
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080189&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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Qian Qiao (drizzlerain)
Assigned to: Nobody/Anonymous (nobody)
Summary: The result of SELECT ... BETWEEN is wrong
Initial Comment:
OS: RedHat Linux AS 4
GCC: 3.4.6
1.setup:
CREATE TABLE A
(A DECIMAL(5));
INSERT INTO A VALUES (12);
INSERT INTO A VALUES (20);
INSERT INTO A VALUES (40);
INSERT INTO A VALUES (12);
2.execute:
SELECT COUNT(*)
FROM A
WHERE a BETWEEN 11.999 AND 12 OR
a BETWEEN 19.999 AND 2.001E1;
3.question:
The result should be 3
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080189&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
