Added asterix project
git-svn-id: https://asterixdb.googlecode.com/svn/trunk/asterix@12 eaa15691-b419-025a-1212-ee371bd00084
diff --git a/asterix-app/src/test/resources/demo_aql/rainbow/110-self-join-dblp.aql b/asterix-app/src/test/resources/demo_aql/rainbow/110-self-join-dblp.aql
new file mode 100644
index 0000000..c5b900b
--- /dev/null
+++ b/asterix-app/src/test/resources/demo_aql/rainbow/110-self-join-dblp.aql
@@ -0,0 +1,28 @@
+use dataverse demo_aql;
+
+declare type DBLPType as open {
+ id: int32,
+ dblpid: string,
+ title: string,
+ authors: string,
+ misc: string
+}
+
+declare nodegroup group1 on rainbow-01, rainbow-02, rainbow-03, rainbow-04, rainbow-05;
+
+declare dataset DBLP(DBLPType)
+ partitioned by key id on group1;
+
+write output to rainbow-01:"/home/onose/hyracks-rainbow/results/110-self-join-dblp.adm";
+
+set simthreshold '.8f';
+
+for $k in (
+ for $i in dataset('DBLP')
+ for $j in dataset('DBLP')
+ where $i.title ~= $j.title
+ order by $i.id, $j.id
+ return {'dblp1': $i, 'dblp2': $j}
+)
+where $k.dblp1.id < $k.dblp2.id
+return $k