Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv6314
Modified Files:
Tag: SQL_2-18
alter_table_add_fkey.SF-1737668.sql
Log Message:
Correct the previous checkin done by mistake
Index: alter_table_add_fkey.SF-1737668.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/Attic/alter_table_add_fkey.SF-1737668.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- alter_table_add_fkey.SF-1737668.sql 15 Jun 2007 11:56:51 -0000 1.1.2.2
+++ alter_table_add_fkey.SF-1737668.sql 15 Jun 2007 11:59:43 -0000 1.1.2.3
@@ -1,6 +1,6 @@
-create table t1 (id int , age int);
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);
@@ -8,17 +8,17 @@
insert into t1 values(4, 13);
insert into t1 values(5, 14);
-insert into t2 values(1, 'monetdb');
-insert into t2 values(2, 'moetdb');
-insert into t2 values(3, 'montdb');
-insert into t2 values(4, 'monetb');
-insert into t2 values(5, 'metdb');
+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(10, 101);
-insert into t3 values(11, 118);
-insert into t3 values(12, 108);
-insert into t3 values(13, 18);
-insert into t3 values(14, 1);
+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);
-------------------------------------------------------------------------
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
