Changeset: 76bf6d9368ba for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=76bf6d9368ba
Added Files:
sql/test/rdf/Tests/q8_v_small.reqtests
sql/test/rdf/Tests/q8_v_small.sql
Modified Files:
sql/server/rel_optimizer.c
sql/test/rdf/Tests/All
Branch: default
Log Message:
use small(er) union test
diffs (truncated from 1141 to 300 lines):
diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -5309,12 +5309,12 @@ rel_mark_used(mvc *sql, sql_rel *rel, in
sql_rel *l = rel->l;
positional_exps_mark_used(rel, l);
- rel_mark_used(sql, rel->l, 1);
+ // rel_mark_used(sql, rel->l, 1);
/* based on child check set expression list */
if (is_project(l->op) && need_distinct(l))
positional_exps_mark_used(l, rel);
positional_exps_mark_used(rel, rel->r);
- rel_mark_used(sql, rel->r, 1);
+ // rel_mark_used(sql, rel->r, 1);
}
break;
diff --git a/sql/test/rdf/Tests/All b/sql/test/rdf/Tests/All
--- a/sql/test/rdf/Tests/All
+++ b/sql/test/rdf/Tests/All
@@ -23,6 +23,7 @@ q6_v
q7_t
q7_v
q8_t
-q8_v
+#q8_v
+q8_v_small
drop_tables_t
drop_tables_v
diff --git a/sql/test/rdf/Tests/q8_v_small.reqtests
b/sql/test/rdf/Tests/q8_v_small.reqtests
new file mode 100644
--- /dev/null
+++ b/sql/test/rdf/Tests/q8_v_small.reqtests
@@ -0,0 +1,1 @@
+create_tables_v
diff --git a/sql/test/rdf/Tests/q8_v_small.sql
b/sql/test/rdf/Tests/q8_v_small.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/rdf/Tests/q8_v_small.sql
@@ -0,0 +1,1100 @@
+with A as (
+ (select subj, obj FROM prop14657240_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660343_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17582582_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657202_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657244_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657245_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660087_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660290_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660329_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660333_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659612_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659802_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659801_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657234_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659613_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659939_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660254_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659603_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659615_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657207_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657217_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659708_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660306_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657206_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657208_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657221_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657249_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659533_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660330_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302406_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660321_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop11121625_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659714_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657215_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660308_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657214_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657200_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657213_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657220_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657016_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302355_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302445_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302397_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302372_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302421_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302393_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657017_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657219_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302388_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302389_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302454_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302479_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302441_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302416_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302469_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302376_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302517_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302367_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302512_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659709_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660148_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302395_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302419_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302424_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302377_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302426_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302370_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302493_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302463_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14660331_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302457_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302481_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659715_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659532_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302436_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302468_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302413_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302516_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302478_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302361_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302371_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302362_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302363_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302386_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302390_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302430_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14657247_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302507_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302433_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302366_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302396_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302477_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302439_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302514_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302438_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302467_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302459_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302482_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302443_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302435_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop14659514_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302486_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302425_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302392_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302473_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302455_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302434_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302492_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302437_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302501_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302490_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302460_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302519_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302398_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302518_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302495_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302489_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302364_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302474_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302431_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302496_pso where subj = 12854543)
+ UNION ALL
+ (select subj, obj FROM prop17302440_pso where subj = 12854543)
+ )
+SELECT * from (
+ (SELECT b.subj
+ FROM A,
+ prop14657240_pso as B
+ WHERE A.obj = B.obj
+ AND B.subj <> 12854543
+ )
+ UNION ALL
+ (SELECT b.subj
+ FROM A,
+ prop14660343_pso as B
+ WHERE A.obj = B.obj
+ AND B.subj <> 12854543
+ )
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
