Parentheses matching only works partially

Teradata Studio
Teradata Employee

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)

Mike Bellhouse
Senior Business Information Modeller
International Architecture
2 REPLIES
Highlighted
Teradata Employee

Re: Parentheses matching only works partially

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.

Teradata Employee

Re: Parentheses matching only works partially

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

Mike Bellhouse
Senior Business Information Modeller
International Architecture