JCR SQL Queries

5 02 2009

Care needs to be taken

SELECT *  FROM nt:base  WHERE jcr:path LIKE '/userenv/%'

works, but

SELECT *  FROM nt:base  WHERE jcr:path LIKE '/userenv%'

does not.

5 02 2009: Glenn Golden (21:57:46) :

Why does the second query not work?
5 02 2009: Ian Boston (23:06:37) :

No idea :), remember is a JSR-170 SQL query, not a RDBMS SQL query.

T F D