Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv3616/src/test/BugTracker-2008/Tests
Added Files:
table_update.SF-2080207.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/table_update.SF-2080207.sql,1.1.2.1
added test for bug #2080207
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: table_update.SF-2080207.sql ---
CREATE TABLE A
(a varchar(10),
b varchar(10));
CREATE TABLE B
(a varchar(10),
b varchar(10));
insert into a values('1','2');
insert into a values('2','2');
insert into b values('1','2');
insert into b values('3','2');
update A set a='a' where A.a not in (select B.a from B where A.b=B.b);
select * from a;
drop table B;
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
