Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16125/src/test/BugTracker-2008/Tests
Modified Files:
alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
Log Message:
propagated changes of Monday Sep 14 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/09/14 - nielsnes:
src/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.err,1.2.6.2
make sure we reset null/default and unique flags in columns when transactions
fail
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
17 Aug 2009 10:54:15 -0000 1.3
+++ alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
14 Sep 2009 08:43:29 -0000 1.4
@@ -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
------------------------------------------------------------------------------
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
