Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv6252
Modified Files:
Tag: May2009
primekeyconstraint.SF-2783425.sql
primekeyconstraint.SF-2783425.stable.err
primekeyconstraint.SF-2783425.stable.out
Log Message:
back port (exact copy)
U primekeyconstraint.SF-2783425.stable.out
Index: primekeyconstraint.SF-2783425.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.out,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- primekeyconstraint.SF-2783425.stable.out 7 Jun 2009 06:39:41 -0000
1.1.2.1
+++ primekeyconstraint.SF-2783425.stable.out 8 Jun 2009 05:52:14 -0000
1.1.2.2
@@ -52,6 +52,18 @@
% wrd, int, int # type
% 1, 1, 1 # length
[ 2, 1, 1 ]
+[ 2, 5, NULL ]
+% sys.way_nds, sys.way_nds, sys.way_nds # table_name
+% L6, way, idx # name
+% wrd, int, int # type
+% 1, 1, 1 # length
+[ 2, 1, 1 ]
+[ 2, NULL, 3 ]
+% sys.way_nds, sys.way_nds, sys.way_nds # table_name
+% L10, way, idx # name
+% wrd, int, int # type
+% 1, 1, 1 # length
+[ 2, 1, 1 ]
[ 2, NULL, 3 ]
[ 2, 5, NULL ]
U primekeyconstraint.SF-2783425.sql
Index: primekeyconstraint.SF-2783425.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- primekeyconstraint.SF-2783425.sql 7 Jun 2009 06:39:41 -0000 1.1.2.1
+++ primekeyconstraint.SF-2783425.sql 8 Jun 2009 05:52:14 -0000 1.1.2.2
@@ -17,6 +17,7 @@
ALTER TABLE way_nds ADD CONSTRAINT pk_way_nds PRIMARY KEY (way, idx);
select way,idx from way_nds;
-select count(way), way, idx from way_nds group by way, idx having
-count(way) > 1;
+select count(way), way, idx from way_nds group by way, idx having count(way) >
1;
+select count(idx), way, idx from way_nds group by way, idx having count(idx) >
1;
+select count(*), way, idx from way_nds group by way, idx having count(*) > 1;
drop table way_nds;
U primekeyconstraint.SF-2783425.stable.err
Index: primekeyconstraint.SF-2783425.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.err,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- primekeyconstraint.SF-2783425.stable.err 7 Jun 2009 06:39:41 -0000
1.1.2.1
+++ primekeyconstraint.SF-2783425.stable.err 8 Jun 2009 05:52:14 -0000
1.1.2.2
@@ -69,8 +69,9 @@
# 08:02:34 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=30582
# 08:02:34 >
-MAPI = mone...@eir:30582
+MAPI = mone...@alf:38363
QUERY = ALTER TABLE way_nds ADD CONSTRAINT pk_way_nds PRIMARY KEY (way, idx);
+ERROR = !SQLException:assert:CONSTRAINT PRIMARY KEY: NOT NULL constraint
violated for column way_nds.way
# 08:02:34 >
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
