Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

  1. /bookstore/categories[@code='1']/books[@title='Matilda']
  2. /bookstore/categories[@name='SciFi']/books[@title='Matilda']
  3. /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

...