Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv711
Modified Files:
Tag: Nov2008
is_distinct_broken.SF-2430201.sql
is_distinct_broken.SF-2430201.stable.out
server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.sql
server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.stable.out
Log Message:
Change tables names....
In this case of a timeout in server_aborts... (table drop is not executed)
is_distinct is not affected...
U server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.sql
Index: server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.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
--- server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.sql
17 Nov 2008 20:08:10 -0000 1.1.2.1
+++ server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.sql
23 Dec 2008 11:38:45 -0000 1.1.2.2
@@ -1,3 +1,3 @@
-create table way_tags (way integer, k string);
-SELECT * FROM way_tags WHERE way IN (SELECT way WHERE k = 'bridge');
-drop table way_tags;
+create table way_tags_2183292 (way integer, k string);
+SELECT * FROM way_tags_2183292 WHERE way IN (SELECT way WHERE k = 'bridge');
+drop table way_tags_2183292;
U is_distinct_broken.SF-2430201.stable.out
Index: is_distinct_broken.SF-2430201.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.out,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- is_distinct_broken.SF-2430201.stable.out 18 Dec 2008 21:52:07 -0000
1.1.2.2
+++ is_distinct_broken.SF-2430201.stable.out 23 Dec 2008 11:38:45 -0000
1.1.2.3
@@ -36,7 +36,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.way_tags # table_name
+% sys.way_tags_2430201 # table_name
% way # name
% int # type
% 8 # length
U is_distinct_broken.SF-2430201.sql
Index: is_distinct_broken.SF-2430201.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- is_distinct_broken.SF-2430201.sql 15 Dec 2008 10:04:26 -0000 1.1.2.2
+++ is_distinct_broken.SF-2430201.sql 23 Dec 2008 11:38:45 -0000 1.1.2.3
@@ -1,16 +1,16 @@
-create table way_tags (way int, k int);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(23950375,1);
-insert into way_tags values(24644162,1);
-insert into way_tags values(24644162,1);
-insert into way_tags values(24644162,1);
+create table way_tags_2430201 (way int, k int);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(23950375,1);
+insert into way_tags_2430201 values(24644162,1);
+insert into way_tags_2430201 values(24644162,1);
+insert into way_tags_2430201 values(24644162,1);
-select distinct way from way_tags group by way, k having count(*) > 1;
+select distinct way from way_tags_2430201 group by way, k having count(*) > 1;
-drop table way_tags;
+drop table way_tags_2430201;
select distinct (select 10 union all select 10);
U server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.stable.out
Index:
server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.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
---
server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.stable.out
23 Nov 2008 17:13:29 -0000 1.1.2.1
+++
server_aborts_on_nested_query_without_from_in_subquery.SF-2183292.stable.out
23 Dec 2008 11:38:45 -0000 1.1.2.2
@@ -27,7 +27,7 @@
# 18:01:11 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=38731 -G
# 18:01:11 >
-% sys.way_tags, sys.way_tags # table_name
+% sys.way_tags_2183292, sys.way_tags_2183292 # table_name
% way, k # name
% int, clob # type
% 1, 0 # length
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
