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

Modified Files:
      Tag: SQL_2-24
        All 
Added Files:
      Tag: SQL_2-24
        select_in_wrong_result.SF-2080168.sql 
Log Message:
add test for bug 2080168 



--- NEW FILE: select_in_wrong_result.SF-2080168.sql ---

CREATE TABLE A (
a varchar(10)
);
INSERT INTO A VALUES ('a1');
INSERT INTO A VALUES ('a2');
INSERT INTO A VALUES ('a3');

SELECT a FROM A
WHERE a < (SELECT a FROM A WHERE a = 'a4')
AND a IN (SELECT a FROM A);

drop table A;

U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- All 28 Aug 2008 10:33:37 -0000      1.1.2.2
+++ All 28 Aug 2008 10:43:33 -0000      1.1.2.3
@@ -15,3 +15,4 @@
 view_reply_incorrect.SF-2075097
 year_overflow_bug.SF-2075133
 select_not_wrong_result.SF-2080151
+select_in_wrong_result.SF-2080168


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