Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21406
Modified Files:
Tag: SQL_2-24
All
Added Files:
Tag: SQL_2-24
constraint_with_schemas.SF-2080219.sql
Log Message:
added test for bug #2080219
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v
retrieving revision 1.1.2.5
retrieving revision 1.1.2.6
diff -u -d -r1.1.2.5 -r1.1.2.6
--- All 28 Aug 2008 10:51:41 -0000 1.1.2.5
+++ All 28 Aug 2008 10:57:14 -0000 1.1.2.6
@@ -18,3 +18,4 @@
select_in_wrong_result.SF-2080168
select_between_wrong_result.SF-2080189
table_update.SF-2080207
+constraint_with_schemas.SF-2080219
--- NEW FILE: constraint_with_schemas.SF-2080219.sql ---
create schema s1;
create schema s2;
create table s1.A(a varchar(10) NOT NULL UNIQUE);
create table s2.A(a varchar(10) NOT NULL);
set schema s2;
insert into A values('abc');
set schema s1;
insert into A values('abc');
select * from s1.A;
select * from s2.A;
drop table s1.A;
drop table s2.A;
create table s1.A(a varchar(10) NOT NULL UNIQUE);
create table s2.A(a varchar(10) NOT NULL);
set schema s1;
insert into A values('abc');
set schema s2;
insert into A values('abc');
drop table s1.A;
drop table s2.A;
set schema sys;
drop schema s2;
drop schema s1;
-------------------------------------------------------------------------
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
