[OAK-2296] Update sql2.txt test to account for name property presence in non test nodes

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.1.6
• Component/s: query
• Assignee: Chetan Mehrotra
• Reporter: Chetan Mehrotra
• Created: 26/Nov/14 07:20
• Updated: 08/Oct/19 15:21
• Resolved: 04/Feb/15 09:52

Description

Test executed from sql2.txt [1] fail for some cases if property names used in test data are also used in non test data. For example when running with oak-lucene where the index definition also uses name property then test case fails as Lucene search also includes index related nodes.

As a fix testcase should be modified to include testdata path restriction

select [jcr:path]
  from [nt:base]
  where [name] is not null union all select [jcr:path]
  from [nt:base]
  where [name] is not null
/oak:index/test-index/indexRules/nt:base/properties/allProps
/oak:index/test-index/indexRules/nt:base/properties/allProps
/oak:index/test-index/indexRules/nt:base/properties/prop1
/oak:index/test-index/indexRules/nt:base/properties/prop1
/test/a
/test/a
/test/b
/test/b

[1] https://svn.apache.org/repos/asf/jackrabbit/oak/trunk/oak-core/src/test/resources/org/apache/jackrabbit/oak/query/sql2.txt

Issue Links

• blocks: OAK-2282 Make current testcases pass with new index implementation