Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv4959/src/test/BugTracker-2008/Tests
Modified Files:
table_update.SF-2080207.sql
Log Message:
propagated changes of Saturday Aug 30 2008 - Tuesday Sep 02 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/08/30 - nielsnes:
src/test/BugTracker-2008/Tests/table_update.SF-2080207.sql,1.1.2.2
added dynamic type checks in more cases (fixes
auto_coersion_bug.SF-2075157.sql,string_length_not_checked.SF-2075078.sql)
added checks in alter table (fixes alter_view_not_allowed.SF-2075195.sql)
fixed hanling of not in (fixes select_in_wrong_result.SF-2080168.sql)
use the new thetauselect (fixes select_not_wrong_result.SF-2080151.sql)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: table_update.SF-2080207.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/table_update.SF-2080207.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- table_update.SF-2080207.sql 29 Aug 2008 22:01:30 -0000 1.2
+++ table_update.SF-2080207.sql 2 Sep 2008 13:22:17 -0000 1.3
@@ -12,6 +12,8 @@
insert into b values('1','2');
insert into b values('3','2');
+select a from a where A.a not in (select B.a from B where A.b=B.b);
+
update A set a='a' where A.a not in (select B.a from B where A.b=B.b);
select * from 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
