All Forums Teradata Studio
MikeBellhouse 2 posts Joined 05/09
19 Aug 2015
Parentheses matching only works partially

Hello,
I was working with the following Aster Express query in Studio:
SELECT DISTINCT path, count(*) cnt
FROM nPath (
ON bank_web_clicks
PARTITION BY customer_id, session_id
ORDER BY datestamp
MODE(NONOVERLAPPING)
PATTERN ('PAGE+.BME')
SYMBOLS
(
TRUE AS PAGE,
page = 'BILL MANAGER ENROLLMENT' AS BME
)
RESULT (
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)

fgrimmer 553 posts Joined 04/09
19 Aug 2015

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.

MikeBellhouse 2 posts Joined 05/09
20 Aug 2015

Francine,
I was selecting the parenthesis rather than clicking after it. Studio works correctly for me. The interface is different from another I work with.
Thanks,
Mike

You must sign in to leave a comment.