Changeset: ec4abca8bc5b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ec4abca8bc5b
Modified Files:
sql/test/osm/Tests/drop_constraint_bug.sql
Branch: Apr2011
Log Message:
use unique table names to avoid conflict in case preceeding test fails
diffs (23 lines):
diff --git a/sql/test/osm/Tests/drop_constraint_bug.sql
b/sql/test/osm/Tests/drop_constraint_bug.sql
--- a/sql/test/osm/Tests/drop_constraint_bug.sql
+++ b/sql/test/osm/Tests/drop_constraint_bug.sql
@@ -5,15 +5,15 @@
"timestamp" timestamptz(7),
CONSTRAINT "ways_id_pkey" PRIMARY KEY ("id")
);
-CREATE TABLE way_tags (way integer, k varchar(255), v varchar(1024),
+CREATE TABLE way_tags2 (way integer, k varchar(255), v varchar(1024),
primary key (way, k), foreign key(way) references ways);
alter table ways drop constraint ways_id_pkey;
SELECT count(*) FROM ways
-LEFT JOIN way_tags ON
- ways.id = way_tags.way
+LEFT JOIN way_tags2 ON
+ ways.id = way_tags2.way
WHERE
k = 'highway' AND
v = 'secondary';
-drop table way_tags;
+drop table way_tags2;
drop table ways;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
