Changeset: 8fc79f20d6ef for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8fc79f20d6ef
Modified Files:
sql/test/BugTracker-2011/Tests/predicate.Bug-2908.sql
sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out
Branch: Aug2011
Log Message:
Changed test for bug 2908 so that it also works in isolation.
diffs (30 lines):
diff --git a/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.sql
b/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.sql
--- a/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.sql
+++ b/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.sql
@@ -6,5 +6,5 @@ 1 then cast('VIEW' as varchar(20)) when
t."temporary" = 1 then cast('LOCAL TEMPORARY' as varchar(20)) else
cast('INTERNAL TABLE TYPE' as varchar(20)) end as table_type, cast('' as
varchar(1)) as remarks from sys."schemas" s, sys."tables" t where s."id" =
-t."schema_id" and t."name" like '%' and (1 = 0 or (t."type" = 0 and t."system"
+t."schema_id" and t."name" like 'x%z' and (1 = 0 or (t."type" = 0 and
t."system"
= false and t."temporary" = 0)) order by table_type, table_schem, table_name;
diff --git a/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out
b/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out
--- a/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out
+++ b/sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out
@@ -33,12 +33,9 @@ Ready.
% ., .s, .t, ., . # table_name
% table_cat, table_schem, table_name, table_type, remarks # name
% varchar, varchar, varchar, varchar, varchar # type
-% 0, 3, 20, 5, 0 # length
-[ NULL, "sys", "sensor_readings_2678", "TABLE", "" ]
-[ NULL, "sys", "table1_bug2771", "TABLE", "" ]
-[ NULL, "sys", "table2_bug2771", "TABLE", "" ]
+% 0, 0, 0, 0, 0 # length
-# 14:49:53 >
-# 14:49:53 > "Done."
-# 14:49:53 >
+# 17:24:21 >
+# 17:24:21 > "Done."
+# 17:24:21 >
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
