java lang StackOverflowError at java util regex Pattern$Bound check v7.3

[MattE]

Hi,

I've got a piece of Redshift SQL which runs fine in DBeaver. However, when i put it into a tDBRow which is properly configured to connect to redshift i get the string of errors below. There are no regex functions at the line numbers Talend is reporting. Any ideas?

Error

Exception in thread "main" java.lang.StackOverflowError

at java.util.regex.Pattern$Bound.check(Pattern.java:5310)

at java.util.regex.Pattern$Bound.match(Pattern.java:5330)

at java.util.regex.Pattern$GroupHead.match(Pattern.java:4660)

at java.util.regex.Pattern$NotBehind.match(Pattern.java:5204)

[Anonymous]

Hi

It is a compilation error in the generated code, there must be a symbol error in the query, can you show us the query?

Regards

Shong

[MattE]

The query was fine, as i said it ran in DBeaver with no problem. The issue seemed to be how the Talend formatter formatted the code.

select blah, blah, blah

from tableA a

inner join tableB b on a.id = b.id

a.date = b.date

I removed the line breaks, pasted it into a separate tDBRow, copy and pasted back into my original tDBRow and it worked for some reason.