Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv25083
Modified Files:
primekeyconstraint.SF-2783425.sql
primekeyconstraint.SF-2783425.stable.out
Log Message:
improved test
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.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- primekeyconstraint.SF-2783425.stable.out 7 Jun 2009 20:02:42 -0000
1.3
+++ primekeyconstraint.SF-2783425.stable.out 7 Jun 2009 21:05:08 -0000
1.4
@@ -53,6 +53,19 @@
% 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 ]
# 08:02:34 >
# 08:02:34 > Done.
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.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- primekeyconstraint.SF-2783425.sql 7 Jun 2009 18:18:43 -0000 1.2
+++ primekeyconstraint.SF-2783425.sql 7 Jun 2009 21:05:08 -0000 1.3
@@ -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;
------------------------------------------------------------------------------
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
