Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv14454/src/test/BugTracker-2008/Tests
Modified Files:
alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
Log Message:
propagated changes of Sunday Aug 16 2009 - Monday Aug 17 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/08/16 - nielsnes:
src/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.err,1.2.6.1
approved output
disallow explain with alter
made sure we allways group by on bats
(fixes bug 2837561)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
14 Nov 2008 14:39:43 -0000 1.2
+++ alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
17 Aug 2009 10:54:15 -0000 1.3
@@ -80,25 +80,28 @@
# 16:00:59 > mclient -lsql -umonetdb -Pmonetdb --host=alviss --port=38461
# 16:00:59 >
-MAPI = mone...@alviss:34140
+MAPI = mone...@alf:32175
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...@alviss:34140
+MAPI = mone...@alf:32175
QUERY = alter table A add constraint test1 primary key (test);
-ERROR = !SQLException:assert:INSERT INTO: PRIMARY KEY constraint 'a.test1'
violated
-MAPI = mone...@alviss:34140
+ERROR = !SQLException:assert:UPDATE: PRIMARY KEY constraint 'a.test1' violated
+MAPI = mone...@alf:32175
QUERY = insert into A (test) values (1);
ERROR = !SQLException:assert:INSERT INTO: PRIMARY KEY constraint 'a.test1'
violated
-MAPI = mone...@alviss:34140
+MAPI = mone...@alf:32175
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...@alviss:34140
-QUERY = alter table A add constraint test1 primary key (test, id);
-ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column a.id
-MAPI = mone...@alviss:34140
+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
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...@alviss:34140
+ERROR = !CONSTRAINT PRIMARY KEY: a table can have only one PRIMARY KEY
+MAPI = mone...@alf:32175
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
