Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1379/src/test/BugTracker-2008/Tests
Modified Files:
Tag: Aug2009
alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
Log Message:
make sure we reset null/default and unique flags in columns when transactions
fail
U alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
Index: alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.err,v
retrieving revision 1.2.6.1
retrieving revision 1.2.6.2
diff -u -d -r1.2.6.1 -r1.2.6.2
--- alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
16 Aug 2009 14:22:25 -0000 1.2.6.1
+++ alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
14 Sep 2009 05:31:59 -0000 1.2.6.2
@@ -80,28 +80,25 @@
# 16:00:59 > mclient -lsql -umonetdb -Pmonetdb --host=alviss --port=38461
# 16:00:59 >
-MAPI = mone...@alf:32175
+MAPI = mone...@alf:31886
QUERY = alter table A add constraint test1 primary key (test);
ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column a.test
-MAPI = mone...@alf:32175
+MAPI = mone...@alf:31886
QUERY = alter table A add constraint test1 primary key (test);
ERROR = !SQLException:assert:UPDATE: PRIMARY KEY constraint 'a.test1' violated
-MAPI = mone...@alf:32175
+MAPI = mone...@alf:31886
QUERY = insert into A (test) values (1);
ERROR = !SQLException:assert:INSERT INTO: PRIMARY KEY constraint 'a.test1'
violated
-MAPI = mone...@alf:32175
+MAPI = mone...@alf:31886
QUERY = alter table A add constraint test1 primary key (test, id);
ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column a.test
-MAPI = mone...@alf:32175
-QUERY = insert into A values (1, NULL);
-ERROR = !SQLException:assert:INSERT INTO: NOT NULL constraint violated for
column a.id
-MAPI = mone...@alf:32175
-QUERY = insert into A values (NULL, 1);
-ERROR = !SQLException:assert:INSERT INTO: NOT NULL constraint violated for
column a.test
-MAPI = mone...@alf:32175
+MAPI = mone...@alf:31886
QUERY = alter table A add constraint test1 primary key (test, id);
-ERROR = !CONSTRAINT PRIMARY KEY: a table can have only one PRIMARY KEY
-MAPI = mone...@alf:32175
+ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column a.id
+MAPI = mone...@alf:31886
+QUERY = alter table A add constraint test1 primary key (test, id);
+ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column a.test
+MAPI = mone...@alf:31886
QUERY = insert into t2 select * from t1;
ERROR = !SQLException:assert:INSERT INTO: PRIMARY KEY constraint
't2.t2_id_pkey' violated
U alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
Index: alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.out,v
retrieving revision 1.2.6.1
retrieving revision 1.2.6.2
diff -u -d -r1.2.6.1 -r1.2.6.2
--- alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
16 Aug 2009 14:22:25 -0000 1.2.6.1
+++ alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
14 Sep 2009 05:31:59 -0000 1.2.6.2
@@ -34,7 +34,9 @@
[ 1 ]
[ 1 ]
[ 1 ]
-[ 0 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
[ 1 ]
% sys.b # table_name
% test # name
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
