You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-commits@jackrabbit.apache.org by al...@apache.org on 2012/09/24 15:50:36 UTC
svn commit: r1389381 - in
/jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query:
sql2.txt sql2_measure.txt
Author: alexparvulescu
Date: Mon Sep 24 13:50:36 2012
New Revision: 1389381
URL: http://svn.apache.org/viewvc?rev=1389381&view=rev
Log:
OAK-336 - Document SQL2 "measure"
Modified:
jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2.txt
jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2_measure.txt
Modified: jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2.txt
URL: http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2.txt?rev=1389381&r1=1389380&r2=1389381&view=diff
==============================================================================
--- jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2.txt (original)
+++ jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2.txt Mon Sep 24 13:50:36 2012
@@ -165,51 +165,26 @@ select id from [nt:base] where id is not
1
0
-measure select * from [nt:base] as c right outer join [nt:base] as p on p.id = c.p where p.id is not null and not isdescendantnode(p, '/jcr:system')
-c, 630
-p, 210
-query, 4
-
select * from [nt:base] as c right outer join [nt:base] as p on p.id = c.p where p.id is not null and not isdescendantnode(p, '/jcr:system')
/children/c1, /parents/p1
/children/c2, /parents/p1
/children/c3, /parents/p2
null, /parents/p0
-measure select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null
-c, 630
-p, 210
-query, 4
-
select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null
/parents/p0, null
/parents/p1, /children/c1
/parents/p1, /children/c2
/parents/p2, /children/c3
-measure select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null and c.p is null
-c, 630
-p, 210
-query, 1
-
select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null and c.p is null
/parents/p0, null
-measure select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null and c.p is not null
-c, 630
-p, 210
-query, 3
-
select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null and c.p is not null
/parents/p1, /children/c1
/parents/p1, /children/c2
/parents/p2, /children/c3
-measure select * from [nt:base] as p inner join [nt:base] as c on p.id = c.p
-c, 630
-p, 210
-query, 3
-
select * from [nt:base] as p inner join [nt:base] as c on p.id = c.p
/parents/p1, /children/c1
/parents/p1, /children/c2
Modified: jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2_measure.txt
URL: http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2_measure.txt?rev=1389381&r1=1389380&r2=1389381&view=diff
==============================================================================
--- jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2_measure.txt (original)
+++ jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2_measure.txt Mon Sep 24 13:50:36 2012
@@ -51,3 +51,28 @@ c, 630
p, 210
query, 3
+measure select * from [nt:base] as c right outer join [nt:base] as p on p.id = c.p where p.id is not null and not isdescendantnode(p, '/jcr:system')
+c, 630
+p, 210
+query, 4
+
+measure select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null
+c, 630
+p, 210
+query, 4
+
+measure select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null and c.p is null
+c, 630
+p, 210
+query, 1
+
+measure select * from [nt:base] as p left outer join [nt:base] as c on p.id = c.p where p.id is not null and c.p is not null
+c, 630
+p, 210
+query, 3
+
+measure select * from [nt:base] as p inner join [nt:base] as c on p.id = c.p
+c, 630
+p, 210
+query, 3
+