Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv31167
Modified Files:
Tag: SQL_2-18
All
Added Files:
Tag: SQL_2-18
alter_table_add_fkey.SF-1737668.sql
Log Message:
Add test for bug
alter_table_add_fkey.SF-1737668
--- NEW FILE: alter_table_add_fkey.SF-1737668.sql ---
create table t2 (id int , name varchar(1024), CONSTRAINT pk_t2_id PRIMARY KEY
(id));
create table t3 (age int , address int, CONSTRAINT pk_t3_age PRIMARY KEY (age));
create table t1 (id int , age int);
insert into t1 values(1, 10);
insert into t1 values(2, 11);
insert into t1 values(3, 12);
insert into t1 values(4, 13);
insert into t1 values(5, 14);
insert into t2 values(10, 'monetdb');
insert into t2 values(11, 'moetdb');
insert into t2 values(12, 'montdb');
insert into t2 values(13, 'monetb');
insert into t2 values(14, 'metdb');
insert into t3 values(1, 101);
insert into t3 values(2, 118);
insert into t3 values(3, 108);
insert into t3 values(4, 18);
insert into t3 values(5, 1);
alter table t1 add constraint fk_t1_id_t2_id FOREIGN key(id) references t2(id);
alter table t1 add constraint fk_t1_age_t3_age FOREIGN key(age) references
t3(age);
drop table t1;
drop table t3;
drop table t2;
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.58.2.2
retrieving revision 1.58.2.3
diff -u -d -r1.58.2.2 -r1.58.2.3
--- All 9 Jun 2007 17:11:54 -0000 1.58.2.2
+++ All 15 Jun 2007 09:09:08 -0000 1.58.2.3
@@ -73,3 +73,4 @@
auto_commit.SF-1724151
update_pkey_bug.SF-1733712
update_fkey_with_value_not_in_the_pkey.SF-1734143
+alter_table_add_fkey.SF-1737668
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
