jackrabbit-oak-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alexparvule...@apache.org
Subject svn commit: r1389381 - in /jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query: sql2.txt sql2_measure.txt
Date Mon, 24 Sep 2012 13:50:36 GMT
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
+



Mime
View raw message