Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory 
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1704/src/test/BugTracker-2008/Tests

Added Files:
        select_between_wrong_result.SF-2080189.sql 
Log Message:
propagated changes of Thursday Aug 28 2008 - Friday Aug 29 2008
from the SQL_2-24 branch to the development trunk

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/28 - nielsnes:
        
src/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.sql,1.1.2.1
added test for bug # 2080189
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/29 - nielsnes:
        
src/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.sql,1.1.2.2
adding stable output
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


--- 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);

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

Reply via email to