Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10631
Modified Files:
Tag: SQL_2-24
All
Added Files:
Tag: SQL_2-24
select_between_wrong_result.SF-2080189.sql
Log Message:
added test for bug # 2080189
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v
retrieving revision 1.1.2.3
retrieving revision 1.1.2.4
diff -u -d -r1.1.2.3 -r1.1.2.4
--- All 28 Aug 2008 10:43:33 -0000 1.1.2.3
+++ All 28 Aug 2008 10:47:08 -0000 1.1.2.4
@@ -16,3 +16,4 @@
year_overflow_bug.SF-2075133
select_not_wrong_result.SF-2080151
select_in_wrong_result.SF-2080168
+select_between_wrong_result.SF-2080189
--- NEW FILE: select_between_wrong_result.SF-2080189.sql ---
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;
drop table A;
-------------------------------------------------------------------------
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-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
