Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv20364/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:
approved output
disallow explain with alter
made sure we allways group by on bats
(fixes bug 2837561)
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
retrieving revision 1.2.6.1
diff -u -d -r1.2 -r1.2.6.1
--- 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
16 Aug 2009 14:22:25 -0000 1.2.6.1
@@ -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
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
retrieving revision 1.2.6.1
diff -u -d -r1.2 -r1.2.6.1
--- alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
14 Nov 2008 14:39:47 -0000 1.2
+++ alter_add_constraint_should_check_existing_data.SF-2075241.stable.out
16 Aug 2009 14:22:25 -0000 1.2.6.1
@@ -34,9 +34,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
+[ 0 ]
[ 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
