I was working with the following Aster Express query in Studio:
SELECT DISTINCT path, count(*) cnt
FROM nPath (
PARTITION BY customer_id, session_id
ORDER BY datestamp
TRUE AS PAGE,
page = 'BILL MANAGER ENROLLMENT' AS BME
ACCUMULATE (page OF ANY (PAGE, BME)) AS path
I noticed that if I try to find the matching parenthesis for example the second one after BME)). If I highlight this parenthesis it shows the matching one as (PAGE which is clearly incorrect. I then went through all the parentheses in this snippet. Some highlight the partner but others don't. Is there a better way to match parentheses?
I am using Studio 15.10.00.04 (and saw the same with 15.10.00.02)
Mike, I pasted your SQL statement into my Studio 15.10.00.04 and when I put the cursor after BME)), it showed the matching left paranthesis as (page, which is correct. You are missing an ending parenthesis for the statement to be complete. I tried this with both Aster 6.0 and Aster 6.10. Aster 6.10 provides a parser so the statement shows a red at the end to indicate you are missing the ending right parenthesis.
I was selecting the parenthesis rather than clicking after it. Studio works correctly for me. The interface is different from another I work with.