...
Note: In the event that all operations are using the new approach - using xpath_component - then it may be possible to remove the xpath field entirely from the fragments table.
Cps Path Query capabilities can be extended
Presently, Cps Path queries limit leaf-condition, text-condition, etc. to the final path component. The proposed solution will allow for future improvement where conditions could be applied to any or all path components.
For example, given these two queries:
- /bookstore/categories[@code='1']/books[@title='Matilda']
- /bookstore/categories[@name='SciFi']/books[@title='Matilda']
- /bookstore/categories/books[@title='Matilda']
Presently, only case 1 will return data, as "categories[@code='1']" is the list element reference, with 'code' being the list key for categories.
Cases 2 and 3 will return nothing. Given the proposed solution uses an SQL sub-query for each path-component, with a little work, cases 2 and 3 would be supported.
Index-only lookup where leaf-condition is in the xpath
...